DMT - PO Receipt Combined Error

Epicor ERP 10
,
1

I am Trying to run a DMT for PO Receipt Combined. When I create the template I receive the error “A Valid PO is Required.” I am able to manually receive these POs in Epicor and when I check the Database the data matches what I have in the DMT Load Files.

For a second run I tried just DMT’ing the PO Receipt Header which also came back with the same error “A Valid PO is required” When I look up this PO in Epicor it definitely exists. When I tried going into Receipt Entry to just created the header manually that also worked. Then I looked at the database and the data matched my DMT Load Files.

A Strange Third test that didn’t error, but also didn’t work was when I Tried a DMT Load for PO Receipt Header but in the VendorNumVendorID field I used the VendorNum the DMT appeared to be successful without error, however the record did not load into Epicor.

I contacted Epicor Support and they said they were able to run successfully in their Test environment and that I’d have to contact their Professional Servies Consultants. Before I went that route I wanted to see if anyone has successfully done this or could maybe provide me some insight on something I could be doing wrong.

Thank you!

2

Try putting the VendorID in VendorNumVendorID on the combined template. Works for me with just the 4 required fields… Don’t use VendorNum for that field, which is the number the system will assign and use as the key when linking to the vendor master file from other tables… So same thing when putting the vendor in for the detail lines, if you are using your VendorID, then it goes in the vendornumbervendorid field, not VendorNum. If you use VendorNum, you probably need to do a BAQ to get the vendornum for your vendors.

Also, when you go to check to see if it worked how are you checking? When you open rec. entry, are you searching for the packing slip?

If this doesn’t work for you, post up the columns you used in your DMT template…

3

Looks like what I was missing was having the Purchase Point present. Thanks for the help!