E1: 45: Sales Order Price Cost Update (R42950) Does Not Price Split Lines Using Original Quantity (Doc ID 2684119.1)

Last updated on DECEMBER 20, 2021

Applies to:

Symptoms

Display/Calculation Tab Option #3 (Price Based On Original Quantity) processing option in the Sales Order Batch Price/Cost Update (R42950) is being ignored. As a result, when the line is split based on the order quantity being fulfilled from multiple locations/lots, the price is being recalulated by the Sales Order Batch Price/Cost Update (R42950) based on the quantity on the split line rather than the original quantity on the line before it was split.

Screen prints below illustrate setup that reproduces this issue:

The Item is setup at Sales Price Level 1 (Item Only).

The Item is a Dual Unit of Measure Item.

The tiered price adjustment is setup as follows:

• With the from quantity of 1 CA, a Basis Code 5 adjustment of $1,000,000 is added to the order and customer will pay $1,000,059.04 per unit (Base Price + 1 Million)
• With the from quantity of 72 CA, a Basis Code 5 adjustment of Zero is added to the order and customer will pay $59.04 per unit (Base Price + Zero)

After the lines are split by commitments, but before running Sales Order Batch Price/Cost Update (R42950) each line has less than the 72 CA minimum quantity, but the total of the three lines is 72 CA and the price is $59.04 on each line which is the price for 72 CA.

After running Sales Order Batch Price/Cost Update (R42950) the PDF Report shows on all three lines the price changed from 59.04 to 1,000,059.04.

Price History for line 1.002 shows the Adjustment of 1,000,000.00 was added to the base price and the “Based on Value” (BSDVAL) was changed from 72 CA to 12 CA which is the Quantity on Line  1.002.

Changes

Cause

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