Hi all,
W
e have a serious issue with one of our customers and he is facing a lot of problems because of this. It happens regularly (minimum twice a week).We found some duplicated inventory transactions in the posted tables. This duplication is not happing in the header level. It's just happing in the detail level. For example: If I have one transaction number 123 containing three items X, Y, Z, we found this transaction posted in the header with one record (i.e. 123) and six lines in the details (i.e. X, X, Y, Y, Z, Z). And for some transactions we found the header in the save and post table at the same time. The duplicate records were created in the detail table(IV30300) with non-existing TrxSorce on the header table(IV30200). The IV Detail table will accept duplicate entries as it doesn’t have any type of foreign keys relationship constraints. The below query gave us the list of all the duplicate IV transfers entries (that may be happened due to an interruption during the process of IV BATCH POSTING):
- SELECT * FROM IV30300 WHERE DOCTYPE=3 AND TRXSORCE NOT IN (SELECT TRXSORCE FROM IV30200 WHERE IVDOCTYP=3)
We would appreciate any hint how to solve the past duplicated records and to prevent this in future.
Thx.
Kind Regards,
Rachid
*This post is locked for comments
I have the same question (0)
