cancel
Showing results for 
Search instead for 
Did you mean: 

DTW for Sales order Error

former_member833912
Discoverer
0 Kudos

So I am uploading a DTW for Sales Order

ordr-010-test.txt

ordr-rows-tbl-test.txt

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)

LoHa
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

Abdul
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.