In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Creating Customized Shipping Confirmation Report
I am experimenting with utilizing the Acumatica Shipment Confirmation Report as a our pseudo Bill of Lading. I am needing to add some items to the report form and may require adding tables and relations.
Currently, I would like to add "Ship From" location and address. The Shipping warehouse is already on the Transfer order and SOShipLine. However, if just lists the short name. I would like to add a section where it lists the long name and the address. I am not sure what table or relations I need to setup to reference the warehouse site listed on the SOshipline and query the physical address and long name in that warehouse location.
Any ideas please let me know!
You can make the following joins to get to the warehouse address.
- SOShipment to INSite on SiteID
- INSite to Address on AddressID
INSite also has the warehouse description in the Descr field.