E1: 42: Sales Update (R42800) Writes a Different G/L Date in Sales Order History (F42119) and Accounts Receivable Ledger (F03B11) /Account Ledger (F0911) for Orders with Multiple Shipment Date Values (ADDJ) (Doc ID 2539721.1)

Last updated on OCTOBER 04, 2021

Applies to:

Symptoms

When processing options of R42800 are set to use the Actual Ship Date as AR Invoice date and G/L date and there are multiple ship dates in the sales order, by design R42800 should invoke the errors G/L Date Cannot Vary and Invoice Date Cannot Vary.  These errors should be displayed regardless of the summarization processing option values and regardless of whether or not the invoice number was assigned prior to sales update.

Sales Update (R42800) does not error but instead completes the process to create one invoice. The F03B11/F0911 Invoice Date and G/L Dates are unified by a single date. The G/L Date in the F42119 varies according to the Actual Ship Date value on each sales order line. As a result, the G/L Date and Invoice Date values are different between F42119 and F03B11/F0911.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.