How to get shippedFrom and shippedTo field from sales order to temp table in sales packing slip report?
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:
André Arnaud de Cal...
292,162
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156