Credit Only Return Order Has Incorrect Freight Charge When Original Order is Copied At Original Selling Price
(Doc ID 2201506.1)
Last updated on JULY 09, 2018
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
Find that copying a sales order at original price results in a credit only return order
that has a different unrounded quantity for line charge (Qty: 13.185 with Charge: -74.9147967)
than what is shown for the original order's line charge (Qty: 13.2 with Charge: 75.00)
Expects that the charge quantity and charge (amount) will be the same for both orders since copied with
pricing option 'At Original Selling Price'
These debug statements "BEGIN GET_ORDERQTY_VALUES: line_qty"
are within PACKAGE BODY QP_PREQ_PUB AS QPXPPREB.pls
Customer has version 120.27.12010000.31
Hence fix is already present on Customer's instance from <Bug 12670913> - RETURN FREIGHT CHARGE ROUNDING INCORRECTLY
The issue can be reproduced at will with the following steps:
1) Set profile options:
OM:Unit Price Precision Type EXTENDED Site
QP: Unit Price Precision Type EXTENDED Site
QP: Selling Price Rounding Options Individual: Selling Price = round(listprice) + round(adjustments): Rounds the selling price and adjustments Site
QP: Price Rounding FACTOR Site
2) Custom Pricing Attribute, Pallet Charge Attribute, Setup
SEGMENT_CODE = XX_PALLET_CHARGE
SEGMENT_MAPPING_COLUMN = PRICING_ATTRIBUTE22
USER_VALUE_STRING = xxson_qp_pricing_pkg.get_number_of_pallets(OE_ORDER_PUB.G_LINE.LINE_ID)
Above package is to calculate the number of Pallet (LPN)
After ship confirmed Number of LPN shipped will get count and the charges apply based on the formula.
3) Setup Formula:
Name: PALLET CHARGE
Step 1: Pricing Attribute, Pallet Charge Attribute
Step 2: Modifier Value (in this case = 7.5)
4) Freight Charge Modifier Setup
List_line_id = 2197443
Automatic line level LUMPSUM 7.5 with formula from step #3 above.
5) UOM conversion THO to Ea
Base Unit: Each
1000 THO = 1 Ea
6) Price List
Shows multi currency conversion list = Generated Currency For EUR 60...
Base Round To = -5
Price list line is setup with UOM = THO
7) Currency Precision & Extended Precision.
currency code = EUR
Precision = 2
Extended Precision = 5
7) Enter original order
a. Responsibility: Order Management Super User (or equivalent)
b. Navigate to: Orders, Returns > Sales Orders
NOTE: the item is entered with UOM = Ea...therefore pricing quantity will NOT equal ordered quantity since price list line is in UOM THO (1000 THO = 1 Ea).
8) Actions > Copy with pricing option = At Original Selling Price to a return order
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