Last updated on SEPTEMBER 11, 2017
Applies to:JD Edwards EnterpriseOne Advanced Pricing - Sales - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.
For sales orders, accrual adjustments with formulas associated to them are not being recalculated based on a change to the Unit Price via a manual adjustment in the Price History (P4074). Accrual adjustments that do not have formulas associated to them correctly get recalculated when a manual adjustment is defined/updated. In this example, the formula is written as (Unit Price – Unit Cost)*0.3.
1. For a purchased item (Stocking Type P), the Sales/Inventory Unit Cost is defined as .5149.
2. No Unit Price is defined for the item in P4106.
3. Create a Manual Adjustment in P4070.
4. Create an Accrual Adjustment in P4070.
5. Create a second Accrual Adjustment in P4070.
6. The Advanced Pricing Schedule defined with the manual adjustment first followed by the two accrual adjustments.
7. In the Adjustment Details (P4072), for the manual adjustment – Note that no Factor Value is populated with a Basis Code defined as '5' - Add on Amount.
8. In the Adjustment Details (P4072) for the first accrual adjustment, the Basis Code is defined as a ‘7’ which requires the definition of a formula.
9. The formula for the first accrual is defined in the Price Formula Revisions (P4076) as (Unit Price – Unit Cost)*0.3.
10. In the Adjustment Details (P4072), the second accrual adjustment is defined with a Basis Code 2 and a Factor Value of -10% which means take 10% off the current net price.
11. Via P4210, create a sales order for the item. Note that there is a Unit Cost defined, but no Unit Price.
12. Take the Price History (P4074) Row exit.
13. Note that both Accrual adjustments are properly calculated. The first accrual is defined as -.1545: (0-.5149)*0.3 based on the formula (Unit Price – Unit Cost)*0.3.
14. Populate the Unit Price field of the manual adjustment and populate a Reason Code. Tab down and note that the first accrual adjustment (the one with the formula) is NOT recalculated. However, the second accrual adjustment (without the formula) is properly calculated. THIS is the reported issue in that the system is not updating the accrual based on the formula.
15. The Sales Order Unit Price is properly update.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms