E1: 42: Sales Update (R42800) Writes G/L Units Multiple Times To G/L Revenue Account for DMAAI 4230 and 4270 (Doc ID 2853820.1)

Last updated on JUNE 07, 2022

Applies to:

Symptoms

E1 9.2, Sales
Sales Update (R42800)
Tools Release 9.2

Sales Update (R42800) is writing G/L Units multiple times to the G/L Revenue Account when the G/L revenue account is used for both DMAAI 4230 (Revenue) and DMAAI 4270 (Price Adjustments).

Oracle Support reproduced the issue using demo data following the steps below:

1. In Branch Plant Constants (P41001) for Branch Plant 30 the “Write Units to Journal Entries” (Y/N) checkbox is checked.
2. Item Branch Record (P41026) for Item 2001 in Branch 30 has IN30 as its G/L Class Code.
3. DMAAI 4230 (Revenue) is set to use G/L Class Code of IN30 and Object Account of 5015 in Company 0000
   1. Account to be updated for revenue is 30.5015 (G/L revenue account)
4. Create three price Adjustment Definitions (P4071)
   1. Price Adjustment ADJW1 has G/L Class Code of REV1
   2. Price Adjustment ADJW2 has G/L Class Code of REV0
   3. Price Adjustment ADJW3 has G/L Class Code of REV1
5. Create a Price Adjustment Schedule (P4070) with three adjustments in the following order: ADJW1, ADJW2 and ADJW3.
6. Create three Price Adjustment Detail Records (P4072):
   1. ADJW1 has Basis Code 5, Factor Value -1.000
   2. ADJW2 has Basis Code 5, Factor Value -2.000
   3. ADJW3 has Basis Code 5, Factor Value -1.000
7. Setup DMAAI 4270 (Price Adjustments)
1. G/L Class Code REV0 uses Object Account 5170. Account to be updated for Price Adjustment is 30.5170 (non-revenue discount account).
2. G/L Class Code REV1 uses Object Account of 5015. Account to be updated for Price Adjustment is 30.5015 (G/L revenue account).
8. Create the Sales Order Header First. Adjustment Schedule should be on the Order Header
9. On Order Detail Enter 10 EA item 2001. Price comes in as 296.00
10. Price History (P4074) on Line 1.000 shows all three adjustments were applied.
11. Process the Order through Ship Confirm (P4205) and Invoice Print (R42565).
12. Setup a Version of Sales Update (R42800) as follows:
1. Summarization Tab Option #1 (Summarize AR) = 1 (Summarize AR by Invoice)
2. Other Summarization Options are Blank
13. Run Sales Update (R42800) then examine entries created for Revenue Account 30.5015
1. Three Journal Entries (F0911) were created for the Revenue Account 30.5015
2. First Journal Entry for 30.5015 had -10 Units Populated for a total of 10 units sold.
3. Second Journal Entry for 30.5015 had +10 Units Populated resulting in units sold of Zero (incorrect)
4. Third Journal Entry for 30.5015 had Zero Units Populated (correct)
5. Only the first Journal Entries for Account 30.5015 should have been populated because only 10 Units were sold.

Cause

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