DTW - Oinvoices

[Former Member]

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.

[Former Member · Accepted solution]

DocType should be dDocument_Service

DocumentLines should have account given.

Thanks,

Gordon

[Former Member · Accepted solution]

Thank you for the quick and accurate answer. I had taken the account out in an effort to step through errors but once I added it back and change the DocType as indicated everything is great.

Thanks again!