E1: 45: The Advanced Price Adj With Apply Absolute Value Option Activated Did Not Apply on the Sales Order

(Doc ID 2364929.1)

Last updated on FEBRUARY 23, 2018

Applies to:

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

Symptoms

Adjustment Schedule Price defined with " Apply Absolute Value"  option and Form Level = 1 did not apply correct on the Sales Order.

STEPS TO REPRODUCE
==================
1.Set Unit price = 0 in P4106 (Base Price Revisions) for an item .
2.Set in P4071(Work with Adjustment Types) 2 Adjustments (EGGOVT and EGBASE) as follow :
-Adjustment Level = Line Level Adjustment
-Level Break Type = Amount Level Break
-Adjustment Options = Override Price and Mandatory Adjustment
3.Set in P4071(Work with Adjustment Types) another Adjustments (EGSQ) as follow :
-Adjustment Level = Line Level Adjustment
-Level Break Type = Amount Level Break
-Adjustment Options = Override Price and Apply Absolute Value
4.Set in P4072(Price Adjustment Detail Revisions), the details for the above adjustments :
EGGOVT
-Form Level = -1000000000.0000
-Factor Value Numeric = 0.1
-BC = 5 Add on Amount
EGBASE
-Form Level = -1000000000.0000
-Factor Value Numeric = 58.800
-BC = 5 Add on Amount
EGSQ
-Form Level = 1
-Factor Value Numeric = 54.69
-BC = 5 Add on Amount
-Customer Number = 202020

5.Set in P4070 (Adjustment Schedule) a schedule (ANS) for all adjustments with follow sequence :
10 - EGGOVT
20 - EGBASE
30 - EGSQ
6.Enter a Sales Order P4210 for customer 202020 and apply the Schedule above , on this order .
Enter two lines in the order for the same item : first line with Quantity = 1 EA and second line with Quantity = 10 EA . Note that the Unit price are different between lines even if there is the same item on the lines.
7.Open P4074 (Price History) for the first line of the sales order . Note there are only two adjustments (EGGOVT and EGBASE) applied .
8.Open P4074 (Price History) for the first line of the sales order . Note there are all three adjustments (EGGOVT , EGBASE and EGSQ) applied .
The last adjustment level EGSQ from the schedule , does not consider the amount modified by EGBASE adjustment when the quantity from the order is less then 10 .


EGBASE adjustment has to be applied for all lines where quantity is more than 1 EA or equal with 1 EA .

Cause

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