My Oracle Support Banner

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

Last updated on OCTOBER 12, 2020

Applies to:

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

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:

 

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

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
Changes
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.