Announcements
No record found.
How to get shippedFrom and shippedTo field from sales order to temp table in sales packing slip report?
Hi Lucifer,
To add field to the standard report, you need to do some customization:
dynamicsfox.com/.../
Thanks , but I want to get shippedTo field from sales order form to my report. I checked it was coming from invent site table control name - logisticEntityPostalAddress table. But it was not there. Can you pls help me with that
Can you give us some details, please? What are the field names in InventSite table, or where can we see the fields in saler order form?
In InventSite Form> Tab > Tab address > AddressGrid > AddressGrid_Address(string). This field has data source as LogisticsEntityPostalAddressView. On UI, this field is in Sales Order header> General > Storage dimenstion > site. when you click the site it will take you to another page, Go in Addresses tab and you will see this field under address.
I want to use this field in SalesPackingSlipReport > SalesPackingSlipHeaderTmp DS. In the field that i created. Can you tell me how this can be done.
So it's not about any "shippedFrom" and "shippedTo" fields and you're actually interested in the address of the default site on order header, right? Not the actual sites used by sales lines.
First of all, you need to decide whether you want to get the value that is currently set on the order, or the value that was there when the packing was posted. It doesn't have to be the same thing.
If you want the current value, you can easily get sales table by calling salesTable() method of CustPackingSlipJour. There you'll use InventSiteId to find the site etc.
If you want a value from the packing slip journal, consider if getting it from the warehouse wouldn't work for you. If not, you'll need to add a field and populate it in an extension of CustPackingSlipJour.initFromSalesTable().
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 590 Super User 2026 Season 1
Giorgio Bonacorsi 349
Diego Mancassola 263
