Specific Question for people who have migrated their master data from V8 to E10 - specifically custnum field. when I import my customers into Epicor through the DMT, the custnum field from Vantage changes when it gets to E10. this means that every piece of data that references the customer table, needs to reference the (new) customer number (custnum). Open AR, Sales Order, etc. Is there a way to keep the customer numbers the same from system to system or is there another way to reference the old number to the new number? looking to hear what other people have done.
I suppose the same would go for Supplier numbers as well… Again, what have other people done to help with this?
If you look at DMT for your Sales Order imports, etc. you’ll see a field named custnumcustid…or something similar that you’ll populate with the customer ID. This is what will link everything together.
Same with the supplier imports. I forget the specific field name if you look at the available columns, you should see it.
Mike has it right - the CustomerNumCustID field and VendorNumVendID field replaces the custNum field.
Many other tricks out there on doing the DMT.
If you want my checklist that I have used many times for doing the DMT load - send me a note or call.