By using this website, you agree to our Terms of Use (click here)
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