Notifications
Announcements
How to get shippedFrom and shippedTo field from sales order to temp table in sales packing slip report?
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().
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.
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?
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
Hi Lucifer,
To add field to the standard report, you need to do some customization:
dynamicsfox.com/.../
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 843 Super User 2025 Season 2
André Arnaud de Cal... 405 Super User 2025 Season 2
Martin Dráb 322 Most Valuable Professional
