I'm getting this error eventhough the record does not exist in the table. I'm also displaying each record before the 820-STORE and I don't see any duplicates. Any ideas?

The record may exist in a related table. What is it? INvoice, asset record??

What program are your running?

You could use the lawson debugger as well to set up a break point after the 820 and use the query function to see what the field values were brought in when it errors.

It's the EMTATRANS table. I'm running TA170

Found it. The duplicate record is another record different from what was displayed in the ladb.log. Strange.

I have run into problems in the past where the error shows only the "primary key" as the error, but it actually duplicating on a different / secondary index.