E1: 45: Subsequent Adjustments Not Calculating on New Base Price Flag Adjustment

(Doc ID 2095904.1)

Last updated on MARCH 09, 2018

Applies to:

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


EnterpriseOne 9.1
With an advanced pricing definition that includes the first advanced pricing adjustment defined with the New Base Price Flag checked, the system appears to be validating against the item's Unit Price (F4106) instead of the adjustment that defines the new Unit Price for subsequent adjustments. Subsequently, for subsequent adjustments, the system is validating the From Level Amount (as defined in the Schedule Detail - P4074) from the P4106/F4106 instead of the adjustment defined with the New Base Price Flag Checked. In the Price History (P4074), of a sample order, we can see the Unit Price calculation of the New Base Price Flag adjustment. The system is calculating the next adjustment based on the F4106 Unit Price instead of the amount From Levels defined in P4072.

Steps to Duplicate:

1. In P4072. create two adjustments. For the first adjustment, add an adjustment to a schedule in P4070. Ensure to check the New Base Price flag. The second adjustment is defined as a percentage of new base price.


2. Create an adjustment detail in P4071 that can be defined in different ways. For this example, the Basis Code is defined as 5 (add on Amount) with a Factor Value Numeric of $100.0000.


3. For the second adjustment, in the Adjustment Schedule Detail (P4071), define three different From Levels and with a different Factor Value Numeric for each.The Basis Code is defined as '0' - % of New Base Price.     


4. Define a Unit Price for the Item that is being used to demonstrate the reported issue. In this example, the Unit Price is $51.0000.


5. Add a new sales order for the item in question. The Unit Price is $500.0000.


6. The Price History (P4074) indicates that the % of New Base Price is defined based on the Base Price, not the New Base Price Flag adjustment. The Price should be based on $100 instead of $51. The Factor Value Numeric of the second adjustment should be $500 instead of $400. 


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