E1: 45: Sales Update (R42800) Does Not Create G/L Entries for a Control Code 4 Accrual Adjustment (Doc ID 3012359.1)

Last updated on SEPTEMBER 30, 2024

Applies to:

Symptoms

Sales Update (R42800) is not creating Journal Entries (F0911) for an Accrual Adjustment even though the Accrual Adjustment was created during Sales Order Entry (P42101) and appears in the Price History (P4074) on the Sales Order.

Steps to Reproduce: 

1. Setup a new Item (P4101/P41026) with No Base Price (P4106).
2. Create a Price Adjustment Definition (P4071) for an adjustment to serve as List Price. Check the Override Price (Y/N) checkbox so that the adjustment will be used to override the base price.
3. Create a Price Adjustment Detail (P4072) record as follows:
   1. Factor Value Numeric = 390.00
   2. Basis code = 3 (% of Cost)
   3. Cost Meth = 07
4. Create a second Price Adjustment Definition (P4071) for an adjustment to serve as Accrual to G/L Amount. Use Control Code 4 and G/L Offset IN20.
5. Using Price Adjustment Detail Revisions (P4072) add the detail record as follows:
   1. Factor Value Numeric = -3.000
   2. Basis Code = 2 (% of Current Price)
6. Create a third Price Adjustment Definition (P4071) for a Manual Add/Change adjustment as follows:
   1. Adjustment Control Code 1 (Do Not Print on Document)
   2. Override Price checkbox is checked so that this price will serve as the Base Price
   3. Manual Add/Change checkbox is checked so that the price could be manually changed in Price History.
7. Using Price Adjustment Detail Revisions (P4072) add the detail record as follows:
   1. Factor Value Numeric = 100.00
   2. Basis Code = 2 (% of Current Price)
8. Now create a Price Adjustment Schedule (P4070) with the three adjustments populated in the sequence they were created.
9. Add the Adjustment Schedule to the Customer Billing Instructions (P03013).
10. Create a new Sales Order for the Customer and Item.
    1. Price defaults in as 390% of Cost
    2. Select line and click Price History Button
11. Accrual Adjustment is applied to second grid line in Price History (P4074) screen, but does not affect price to customer. Save the order.
12. Setup DMAAI 4270 as follows:
    1. Company 00001
    2. Order Type SO
    3. G/L Cass Code IN20
    4. Object Account 7020 Test Account for AAI 4270
13. Setup DMAAI 4280 as follows:
    1. Company 00001
    2. Order Type SO
    3. G/L Cass Code IN20
    4. Object Account 7777 Test Account for AAI 4280
14. Process Sales Order through Sales Update (R42800)
    1. Journal Entries were not created for accrual adjustments setup in DMAAI 4270 and 4280

Cause

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