After spending a few weeks setting up our company on a clean database for E10.2.100, I used DMT to import some customers from our v5.2. The DMT tool did not match up the CustNum that I had there in the .CSV, and instead created its own CustNum numbering which doesn’t match up with my records and wil…

Well I finally hunted it down after 4 hours of searching today! This is stored in the database table Erp.CompanySequence

Typically, when using DMT, you would not need to use the CustNum to do the importing, instead using CustID, and let the system create/use the new CustNum from the new Database. This way you import customers, and then orders, and everything in the database should sync up.

Orders and Invoices reference the CustNum, not the CustID. So if I did what you suggest, all of my imported orders would be referencing incorrect customers. Big mess! This is why a reset may be necessary, so that they can all be in sync.

CustomerCustID is the field in the Sales OrderDMT that relates the Sales order to the customer ID, so as Tim said you would just use that. If you didn’t want to join in the customerid in from your old transacitonal data, then I would have thought that importing the customer with the custnum as well…

Every DMT import that needs to reference a customer, uses the CustID. The CustNum you provide is ignored. The import process looks up the CustNum for the CustID you provided, and uses that. Other DMT “gotcha’s”… Importing OrderDtl records with gaps in the OrderLine, end up with a different Line…

And if for some reason you get an error in an order line it will show the subsequent lines as errors also, but they appear to be added in, but with a different line number. The other thing I found is that if for some reason your input line numbers don’t match the DMT will ignore and create line num…

[image] ckrusen: Importing job materials will ignore the MtlSeq and just number them sequentially 10, 20, 30… How do you get it to do this? I want it to do that, but it makes me set one. [image] DMT add a material ERP 10 …

I’m pretty sure (going from memory from over 2 years ago), that the MtlSeq you provide is just ignored.

Reset CustNum to 0

Epicor ERP 10

Banderson (Brandon Anderson) August 16, 2018, 12:46pm 9

How do you get it to do this? I want it to do that, but it makes me set one.