DMT Update Mandatory Fields?

Epicor 9.05.702a

We are wanting to update some of our customers CustIDs via DMT. CustID is a mandatory field for the template. Is it possible to do this? My thought is this isn’t possible and the old customer record with the old CustID would have to be deleted and then a new one created with the new CustID, does this sound correct?

Thanks for any input.

If my memory serves me correct, and i believe it does, CustID is a front facing field for the users of the system to identify customers by account # or some other method rather than the CustNum which is the true key field on the table that Epicor uses to link to other tables and records. While it is required, you can indeed change it without deleting the original record in the Customer table.

This functionality is supported via the custom field: NewCustID. The following DMT import file would change the CustID from CUST2 to CUST3 :

Company,CustID,NewCustID
EPIC06,CUST2,CUST3