Finding the ShipTo Address in the ShipHead and/or ShipDtl tables

Epicor ERP 10
1

My question has to do with finding the Ship To Address from the Ship tables used to create the Packing List. This has to do with a special report I need to create that is very similar to the Packing List Report. Knowing line items from an order can have their own Ship To addresses, I don’t understand why I’m not finding the Ship To address in the ShipDtl table. What I have found doesn’t make sense either … to me, having experience in other ERP systems.

What I’ve found are fields called ShipToCustNum & ShipToNum within the ShipDtl table. The field description of the ShipToCustNum in the Data Dictionary Viewer states … “Ship To Customer Number. This along with ShipToNum provides the foreign key field to a given ShipTo. Normally this has the same value as the CustNum field. However, if the customer allows 3rd party shipto (Customer.AllowShipTo3) then this could be a different custnum.” So, using these 2 fields, I have to find the ShipTo Address within the Customer Table, correct?

If this is true, it is what it is. If there is a better way to find the ShipTo address for an item to be shipped, I’m very interested in the proper procedure for finding this data.

Thanks,

Kent

2

Join ShipDtl and ShipTo using the ShipToCustNum and ShipToNum.

3

Kent, that’s pretty much it. Customer info is stored separately from transactional information, so you do have to go find it. Have you considered creating another report using the Packing List report RDD, or is the report different enough that’s not a possibility?

4

John & Jonathan,

Thank you for replying to my issue. I’m a little new to the Epicor environment, (which you probably already figured that out) and not familiar with the Packing List RDD report. That being said, I did look at the Packing List SSRS within Report Builder and saw there was a lot going on there and thought I’d create my own report. My report is a bit different, but I understand your recommendation.

Thanks for the ShipTo table. I missed that and thought I needed to use the Customer table.

Again, thank you for replying.