I am looking for a way to export a COMPLETE listing of ALL the existing Ship To ID’s.
I tried a BAQ that included “ShipTo.ShipToNum”, but that only yielded the primary Ship To and none of the additional ones. ???
I found a way to extract what I was looking for.
I created a BAQ using Erp.Customer and Erp.ShipTo.
It was simpler to do than I thought. :
Just make sure you don’t link the CustomerShipToNum to the ShipTo.ShipToNum.
The CustomerShipToNum is really the default ShipToNum for that customer to use.
No worries there. All is good.
Thanks for the heads up, though. 
Which in a BAQ returns empty fields for the ShipTo_ShipToNum. Kind of misleading isn’t it? I was under the impression that the default Customer Shipto numbers got ‘assigned’ 1 or 01 or 001 or something along those lines but the BAQ returns an empty column on ShipTo_ShipToNum for the defaulting rows.
Was I imagining that the defaulting was to some version of 1, 01,001 ?
Not sure where the “1, 01,001” is coming from. I guess it depends on how the BAQ was set up. We would have to check that out to be sure.
The default ShipTo is on the customer record.
Other ShipTo address are in the ShipTo table associated to the customer.
I guess I was imagining that there was a record created in ShipTo table for even the defaults and those got the first number in a series.
Thanks for confirming.
It’s been years since I’ve used Epicor, but as I recall…
- ShipNum is actually a string. Anything is acceptable as long as it’s unique.
- A null string is acceptable.
- Epicor making the “1st” ShipTo record have a blank/null ShipNum, makes it automatically become the default for the customer, as the Customer record will have a blank/null ShipNum.
- You should consider a blank/null ShipNum to be just like any other value. It doesn’t mean that a ShipTo record doesn’t exist. Blank matches to Blank.