By using this website, you agree to our Terms of Use (click here)
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).
Sincerely,
Tim Rodman
Hi all,
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!
Thanks all.
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.
Thanks,
Kurt
Online Members
