Skip to Content
0
Former Member
May 01, 2009 at 08:50 PM

DTW - Oinvoices

230 Views

Having some problems with DTW for Oinvoices. Trying to bring in open AR for new client. Templates are fine if the ItemCode is specified but when trying to bring in Service item getting message:

Data cannot be empty in one of the tables Doc1, Doc3, Doc10. [INV1.LineNum][line:0]Application-defined or object-defined error65171.

Fields are tab-delimited. "-" used in example data for ease of reading:

Sample Data:

OINV:

Record Key - Card Code - DocDate - DocDueDate - DocType

1 - C40000 - 20090430 - 200904030 - S

INV1:

Record Key - LineNum - ItemDescription - Price

1 - 0 - Testing Service Import - 2.00

I've only seen references to the Doc1, Doc3, Doc10 related to serial numbers on the forums so I'm at a loss.

Thanks for any suggestions.