DMT how to update ShipTo table?

Epicor ERP 10
1

Hello,

I was asked to replace all ShipViaCode in the ShipTo Table from Value “FSC” to value “LMA” (170 records to change)

I try to use DMT, and I see a required field being CustNumCustID?

Can anyone explain to me the meaning?
image
I tried to read my file to import having Company, CustNum, ShipToNum, Name, TerritoryID, ShipViaCode.
Got an error that column CustNumCustID is missing …
image

So I must be missing something here…anyone can enlight me ?

thanks

Pierre

2

I would have to test it to be sure, but I think it’s looking for a concatenated field with custNum and CustID next to each other. I haven’t actually done that DMT, but have heard others talking about it.

3

Use the CustID for that CustNum (It does the lookup for you). It’s the same thing as the VendorNumVendorID on the supplier table. Since the system assigns the CustNum, it allows you to have all your data ready before hand without having to lookup that CustNum after loading the customers.

4

It is just looking for the CustID value (found in Customer.CustID).

1 Like
5

it is looking for the Customer Code. When you update ship to’s you need to specify the Customer Code and the Ship To code.

6

Thank you all,

Ended up naming my column CustnumCustID and placed the CustID as value.

Worked with a few errors (20) where i did it manually…

thank you.