Distribution - JDE1 (MOSC)

MOSC Banner

Error in sales update due to invoice already present in A/R and G/L

edited Jul 22, 2019 5:00AM in Distribution - JDE1 (MOSC) 7 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center