Vendor Contact DMT

Epicor ERP 10
1

I’m trying to use DMT to update a UDF in the VendCnt table.

I see the required fields and have them in my dataset.
image

I’ve tried it with just those fields and it failed. I added ConNum and it also failed. I added VendorNum and it failed.

image
image1501×649 96.4 KB

Here’s what the latest data set looks like I’m trying with:

image
image959×337 26.1 KB

Has anyone successfully used DMT to update a UDF on a vendor contact? Something that should be easy is becoming a big headache.

2

I think I solved it by adding a couple more columns.

Name and PerConID to the DMT file.

image
image1075×60 8.71 KB

Now it’s running and updating. Still a couple it can’t find but the majority are running through.

I chalk this up to another example of the Epicor documentation needing to be updated.

3

A thought… it looks like Purchase Point is an index column (from the Data Dictionary). Even if you aren’t using Purchase Points, try adding the column and leave it blank.

1 Like
4

@smason

I just wanted to let you know that in version 2021.35, your answer is what solved my DMT issues. - adding PerConID and Name did the trick. Thank you!

1 Like