Showing results for 
Search instead for 
Did you mean: 

DTW for Sales order Error

0 Kudos

So I am uploading a DTW for Sales Order



and on my test Database it works fine but when I move it to the actual database I am get

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

What could be the issue?

Accepted Solutions (0)

Answers (2)

Answers (2)

Active Contributor

Hi Dean,

it could be all or nothing.

What are u trying, adding new or update already existing?

Remove all unnecessary columns in Header txt

When updating existing check

-Documents/Lines are still open

-BP is valid

-You'll need LineNum in your lines txt

Try to start with less columns and look if it works then. After that try to add column by column

regards Lothar

Active Contributor
0 Kudos

It seems either, items or BP does not exist in the live database and the copy of test database is old, please create a new test database and retry there.