Vendor Contact DMT

[smason (Scott Mason)]

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.

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

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

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

[smason (Scott Mason)]

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

Name and PerConID to the DMT file.

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.

[Ernie (Ernie Lowell)]

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.