DMT Tool Error InvcHead

Epicor ERP 9
1

I am trying to change the comments on a Posted invoice using the DMT tool and using the table InvcHead.

Using the DMT tool I am able to change the comments in the “DNComments” field, but when I try and update the “InvoiceComment” field get the following error:

Company GC InvoiceNum = 159391 Column ‘InvoiceComments’ does not belong to table InvcHead.

Epicor
9.05.702A

Thank you in advance

1 Like
2

Is it InvoiceComment or InvoiceComments ?

1 Like
3

Jbooker
What is interesting is the DMT Template tool calls the field “InvoiceComment”
The error calls out “InvoiceComments”
I have tried a combination of updates of changing the field name and have had no luck.

1 Like
4

I’ve not seen a DMT template be wrong but Check the field help on the app to see the exact table.fieldname

1 Like
5

Columns are DNComments and InvoiceComment

DMT Template Builder:

	InvoiceComment	String	x(16000)
	DNComments	String	x(16000)
6

Somewhere in your spreadsheet, a column has a label ‘InvoiceComments’ is what the error is saying. DMT checks the labels in each column against the fields for the Table you are loading data into, if a column label is not a field in the Table, you will get that error. I have seen so many times copying/pasting data into excel during DMT mess up formatting and cause strange errors like this. Wouldn’t be surprised if an extra column exists that has an ‘s’ at the end of ‘InvoiceComment’, it sees it somewhere.