My Oracle Support Banner

E1: 45: Price Update (R42950) doesn’t update Price History (F4074) for Accrual Adjustments calculated from Cost (Basis Code 3) with Copied Sales Orders (Doc ID 3062556.1)

Last updated on DECEMBER 10, 2024

Applies to:

JD Edwards EnterpriseOne Advanced Pricing - Sales - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Price Update (R42950) is not updating Price History (F4074) for Accrual Adjustments that are calculated from Cost (Basis Code 3) for Copied Sales Orders where Price Override Flag = 1 and where Accrual Adjustment Definition (P4071) has “Apply on Override Price” checkbox checked.

Steps to Duplicate:

Note: No actual customer data or personal data is displayed in the steps below:
  1. Setup a new Inventory Item (P4101/P41026/P4105 and P4106)
    1. No Inventory initially (P41202)
    2. In Item Cost (P4105) set Weighted Average Cost (02) as Sales/Inventory Cost with initial cost of 0.00.
    3. Item Base Price (P4106) is 18.99 EA.
  2. First Price Adjustment Definition (P4071) is a line level Price Discount, print on Document (Control Code 2)
  3. First Price Adjustment Detail (P4072) subtracts a 100% discount from the base price, causing the price to be zero.
  4. Second Price Adjustment Definition (P4071) is an Accrued to G/L Adjustment (Control Code 4)
    1. Apply on Override Price Checkbox is checked
  5. Second Adjustment Price Adjustment Detail (P4072) is set as follows:
    1. Factor Value Numeric = 100
    2. Basis Code = 3 (Percent of Cost)
    3. Cost Method = 02 (Weighted Average Cost)
  6. Create a Price Adjustment Schedule (P4070) with both adjustments.
  7. Populate the Price Adjustment Schedule on the Customer Billing Instruction (P03013).
  8. Setup a version of SO Entry (P4210)
    1. Set Commitment Tab Option 1 (Activate Availability Checking) to Blank (Bypass Availability Checking)
  9. Create a Sales Order for a Quantity of 1.
    1. Price comes in as zero
    2. Cost comes in as zero
    3. Row Exit to Price History
  10. Price History (P4074) shows base price and two price adjustments.
    1. Base Price = +18.99
    2. Free Sample adjustment = -18.99
    3. Accrual Adjustment = 0.00
  11. Copy the Sales Order twice to create two new sales orders.
    1. Price Override Flag = 1 on the two copied sales orders.
    2. All three orders have quantity = 1, price = 0.00 and cost = 0.00
  12. Create and Receive a purchase order for 3 units at 1.0925 EA.
  13. Check Item Cost (P4105)
    1. Weighted Average Cost (02) = 1.0925
  14. Create a version of Price/Cost Update (R42950) to Update Cost on Sales Order
    1. Process Tab Option #1 (Cost) = 1 (Update Cost)
  15. Run the Cost Update Version (R42950) against all three orders. Unit cost is updated to 1.0925.
  16. Check Sales Detail (F4211) file in databrowser and verify cost was updated on all three lines
  17. Create a version of Price/Cost Update (R42950) to Update Price on Sales Order
    1. Price Process Tab Option #1 (Cost) = 1 (Update Price)
  18. Price was updated on the order that was not copied but was not updated on the orders that were copied.
  19. Check Price History File (F4074) in databrowser on the three orders:
    1. Accrual Adjustment was updated to 1.0925, same as cost, on the order that WAS NOT copied (price override flag = blank)
    2. Accrual Adjustment was NOT updated and remained 0.000, on the order that WAS copied (price override flag = 1)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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