Error in sales update due to invoice already present in A/R and G/L
Hi All,
A user has raised an issue with sales update report execution of line#5 of a sales order.
The error messages in work center is below
Subject : Error: Record Invalid
CAUSE . . . . The record being processed either already exists for an 'ADD'
function or does not exist for an 'INQUIRY', 'CHANGE' or
'DELETE' function.
RESOLUTION. . If you are attempting to inquire, change or delete a record you
previously added, there may be data base problems in your
production library. You should notify your data processing
department.
The invoice number generated in all 5 lines of the sales order is the same and invoice date is 22-May-2019. However , only line#5 is at status 580-620 rest all the lines are at 620-999 with G/L date = 22-May-2019.