This isn’t as much a question , as it is just a chance to vent. And hopefully someone else will find it useful before finding it the hard way.
When creating new PO Details, if a line fails, the remaining POLine’s created won’t match the input data.
For example, if the following was the input data for DMT
PONum POLine Description TranType
1000 1 Widget A PUR-UKN
1000 2 Widget B PUR-UKN
1000 3 Widget C PUR-UKN
1000 4 Widget D PUR-UKN
At the time the PO 1000 was created, Widget C was a part on the fly, but has since been made a stocked part. So Line 3 will fail.
DMT keeps processing and Line 4 becomes Line 3. Querying the db after DMT is done shows:
PONum POLine Description TranType
1000 1 Widget A PUR-UKN
1000 2 Widget B PUR-UKN
1000 3 Widget D PUR-UKN
Fixing Line 3 and attempting to upload the following doesn’t do what you’d think
PONum POLine Description TranType
1000 3 Widget C PUR-STK
1000 4 Widget D PUR-UKN
DMT, will give an error as it won’t change line 3. It will continue and create line 4
The only solution appears to be deleting all the lines for the PO (or at least back to the first “wrong one”), and then adding the missing lines back in. If any errors occur, you’l probably have to delete all lines for the PO and start again.