E1: 45: Enhanced Basket Adjustments Should Provide an Option to Round Order Lines Quantity Down Before Accumulation (Doc ID 2935141.1)

Last updated on APRIL 27, 2023

Applies to:

Symptoms

Currently accumulation of quantities of Pallets for Enhanced Basket Adjustments is based on rounded up basket calculations

Enhanced Basket Adjustments should allow the accumulation of quantities of Pallets on rounded down values.

Sales Order Example

1. Basket Master (P4550) accumulates sales order lines for Item Group ‘PALLET’ by PL UOM
2. Adjustment Detail (P4072) has a From Level Quantity of 5 PL.
3. Example Sales Order has 4 items ordered in PL that belong to the basket reprice group.
   1. Item 1, 2,000 EA, 2.60416667 PL, Round Down to 2 PL
   2. Item 2, 504 EA, 0.875 PL, Round Down to 0 PL
   3. Item 3, 2,000 EA, 2.42424242 PL, Round Down to 2 PL
   4. Item 4, 200 EA, 0.52083333 PL, Round Down to 0 PL
   5. Sum of Pallets Unrounded = 6.42424242 PL, Rounded Down 4 PL
4. Currently Basket calculations are unrounded for each item and sum of pallets is rounded up or down
   1. Unrounded sum of 6.42424242 PL would be rounded down to 6 PL and would apply the Adjustment
   2. Client wants the system to use the rounded down PL value for each item
   3. Rounded down value would be 4 PL which would not qualify for the adjustment.
5. They want an option in Advanced Basket to specify rounding option, ideally with rounding rule to be applied.
6. For simple baskets where accumulation UOM is specified in Special Handling of UDC 40/PI there should be other option to specify rounding option.

The way system works now, more credit is given for full pallets than what was actually consumed in the order and so it costs them extra money in discounts because they only want to discount a pallet when an item uses a full pallet.

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.