I am trying to add contacts to our Suppliers using DMT. The contact will have the same name “Remittance Recipient” but the email address is different based on the Supplier. When I do this via the menu a new PerConID is created for each Supplier, however when I do this via DMT it seems to update the last Person Contact with this name. I assume I am doing something wrong but have tried several things and cannot get it to work.
Here is an example of my DMT file. Anyone tried to do this before?
I would try adding a 0 PerConID and see if that gets a new PerCon added.
1 Like
I tried adding PerConID = 0 and got an error message
Table: PerCon Msg: Record not found.
Record not found.
So far the only way I can get a new PerCon added via DMT is to use a unique Name
We are doing this now actually.
My DMT skips that field entirely.
@JasonMcD Are you loading Supplier Contacts where the Name is the same but the other data is different?
Not intentionally lol. But we certainly do have the same Cummins rep 3x in our system, with 3 different PerConID’s but the same name every time, and tied to 3 different supplier IDs.
It seems to be very willing to let you add new records with zero accountability for uniqueness.
I skip VendorNum also, FYI. (Your column B)
And I skipped PerConName - I saw no need for that.
Interesting. It does check if the same name is applied to the same vendor already.
But the same name on multiple suppliers is fine.
I tried removing the VendorNum & PerConName as well but still no luck. Seems if the Name is the same as a prior Person Contact it adds a link to the existing contact and updates all the links with the last records data (in my case the email address).
Aha, I see the light! Yes I am seeing this too! Oh man.
But as you said, you get the freedom to make duplicates in the UI. Not duplicates for that vendor, but in general. But the DMT acts differently.
I did this with blank PerConID for new PerCon records. It generated new numbers for me. After that, I did a query to find what numbers were assigned and added that to my supplier DMT to ensure the correct ones were added at that level. ( split the process into two DMT, one for PERCON, one for supplier contact)
2 Likes
Splitting the process into two DMT files does work, however I had to add the email address to the PerCon file as I tried creating the new PerCon records and then putting the new PerConID’s in my Supplier Contact file along with the corresponding email address. Email address was not updated for the Supplier or the Person Contact. I am not sure about other contact fields but assume this would be the same. It is ok if you only have a few records to match between your new Person Contact when creating your Supplier Contact DMT. I however have 280+ Supplier Contacts to deal with. I think my best solution is to make the Supplier Contact name unique rather than trying to use a generic name for all my Remittance contacts.
I agree that making unique names/percon records for each email/ purchase point makes sense. My comment was more about the logic of now epicor creates new PerConID and making sure everything is aligned when you are done. I hope this helps 
1 Like