Skip to Content
0
Former Member
Apr 17, 2009 at 07:22 PM

DTW Error: Invalid Document Number (OINC.DocNum)

1057 Views

We are using SBO 2007 A and the DTW to import service invoices from a legacy invoice system. With a release change of the legacy system the sequence of fields changed a bit, and now DTW throws a strange error when trying to import invoice documents and document lines.

The sample document file reads:

RecordKey DocNum HandWritten DocDate CardCode DocCurrency DocTotal JournalMemo DocDueDate DocRate DocType CardName

RecordKey DocNum HandWritten DocDate CardCode DocCurrency DocTotal JournalMemo DocDueDate DocRate DocType CardName

1 290001 tYES 05012009 15035 EUR 2292.50 812024 2292,50 Testcompany S.R.L. 26012009 1.000 S Testcompany S.R.L.

The sample document lines file reads:

RecordKey Currency Price LineTotal PriceAfterVAT Dscription AccountCode TaxPercentagePerRow

RecordKey Currency Price LineTotal PriceAfterVAT Dscription AccountCode TaxPercentagePerRow

1 EUR 767.00 767.00 767.00 Summe für 6021 0% 6021 0.0

When import into oInvoices the DocNum is recognized properly and matched to DocNum. However, when running the import, there is an error report with the key "DocEntry" and the reason "Invalid document number Application-defined or object-defined error65171

Screen shots of the import process are Step 1 Step 2 Step 3 Step 4

I spent several hours reading, but can't get behind why the DocNum is not accepted.

Does anyon have an idea what is wrong here?

Thanks,

Jörg