Skip to Content
0

Importing legacy data DTW

Jul 05, 2017 at 12:23 PM

65

avatar image
Former Member

Dear Experts,

We are using SAP HANA Business One 9.2 Pl07 and we have the following question.

We want to migrate legacy data using DTW. Firstly we started by adding the AP Invoices. However, we get the following error while using DTW:

No matching records found (ODBC -2028) No matching records found (ODBC -2028)65171

Please note that when we are trying to manually enter the below Invoice, there is no issue.

I am also enclosing a sample of the .txt files

Thank you in advance

Vassilis

ap-invoice-header.txt

ap-invoice-lines.txt

ap-invoice-batch-numbers-final.txt

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Balaji Selvaraj Jul 06, 2017 at 05:45 AM
0

Hi Vassilis,

Error :No matching records found (ODBC -2028) No matching records found (ODBC -2028)65171

Its due to value missing in DocEntry field of the Header template.

Regards:

Balaji.S

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Belaji,

Thanks for your reply.

We tried adding the DocEntry and we still get the same error.

0

Also you are missing the value tYES or tNO in the field.

HandWritten

Regards:

0
Former Member

Thank you

0