DMT Error

Epicor ERP 10
1

I’musing DMT to uncheck the Residential check box in Customer Maintenance–>ShipTo–>Manifest–>Detail. I used the DMT to make the template, selecting the exact info I was pulling in a baq. To test, I did only one customer and it threw an error. The error was Column ‘CustNumCustID’ does not belong to table.

I am pulling the info in a BAQ from ShipTo table and the ShipTo Name and ResDelivery to populate the csv file for DMT. What am i missing/doing wrong? It processes, shows no errors besides the pop up and nothing changes.

2

The default BAQ headers will not match the headers for the DMT usually. Did you change those to match your template?

3

I just copied the info, not the headers.

4

There is a CustID and a CustNum in the customer table. Did you grab the wrong one maybe? I know I always get confused on which one they want.

5

I know what I did, I need to add that field. IT is required in DMT for that table. Sorry, think I just answered my own question.

1 Like
6

I do that all the time. Glad you got it figured out.

7

But what is the CustNumCustID, I can’t find that in the customer table or the shipto table.

8

You’re in a test environment right? (just have to make sure I don’t mess anything up for you)

Just try the CustNum first and see if that does it. If that doesn’t work, I would guess it’s the custID, and you’ll have to join the ship to to the Customer table to get it.

I think there is some ambiguity with the CustID and CustNum coming from some legacy information that wouldn’t be there if they could start fresh, but they can’t because of existing data in companies systems.

edit, plus it says Customer ID here.

image.png811×304 20.7 KB

9

YES! Test Environment is best right now! LOL! Thanks! Maybe I should learn to read. LOL!

10

CustNumCustID is CustID from the Customer table. Worked like a charm!

11

Just a little background, CustNum (and VendNum) are the internal IDs for Customer’s (and Suppliers). You’ll notice that you can change the CustID and the Supplier ID in their respective maintenance programs. Without some kind of internal ID, you would not be able to do that. This is a newer feature that appeared in E9 I believe and VERY helpful for multi-company processing where you have to sync with other databases. I wish the same was done with the Country table. There’s a CountryNum and ID but often the ID is used as the key. Maybe 10.x?

Mark W.

1 Like