Evaluate Block Pricing Tiers Across All Lines
Allow Oracle Pricing to consider the quantity from all order lines in your sales order when it prices according to a block of units in a tiered pricing rule.
Before Update 25A, a tiered pricing rule only considered the quantity on each order line. If you added a new line that had the same item or if you split a line, then Pricing would calculate the block separately for each new line even though the item on the new line was the same as the item on the old line. Starting in Update 25A, if you opt into this feature, then Pricing will add up the quantity across all lines for the same item when it calculates the block for each tier.
If you set up tiers for blocks that have increment values before Update 25A, and if you set the Aggregation Method to On Document when you set up your tier rule, and if you opt into this feature, then you might see results that are different than you're used to seeing. We recommend that you enable this feature in a test environment and examine the results before you enable it in your production environment. For background, see Add Tiers to Pricing Rules.
Assume you set up this rule for the AS54888 Desktop Computer item on the classic Manage Discount Lists page in the Pricing Administration work area:
|
Minimum Quantity |
Maximum Quantity |
Application Method |
Increment Value |
Adjustment Type |
Adjustment Amount |
|
0 |
10 |
As Block |
5 |
Discount Amount |
10 USD |
|
10 |
- |
As Block |
10 |
Discount Amount |
20 USD |
You set the Partial Block Action attribute to Include Partial Block.
Here's the same set up on the redesigned Discount Lists page:
|
Minimum Quantity |
Maximum Quantity |
Calculate |
Lumpsum Group Quantity |
Adjustment Type |
Adjustment Amount |
|
0 |
10 |
Lumpsum |
5 |
Discount Amount |
10 USD |
|
10 |
- |
Lumpsum |
10 |
Discount Amount |
20 USD |
You set the Remainder Quantities in Lumpsum attribute to Yes.
Assume you enable this feature, and then create a sales order with these lines:
|
Line |
Item |
Quantity |
|
1 |
AS54888 Desktop Computer |
65 |
|
2 |
AS54888 Desktop Computer |
5 |
The tiered adjustment is for $20 for each block, in increments of 10. There are 7 blocks to evaluate because the sales order's total quantity is 70. The total adjustment across both lines is $140.
- Line 1 has a quantity of 65, which is in the second tier, so it gets a $2 adjustment for each unit.
- Line 2 has a quantity of 5, which is in the second tier, so it gets a $2 adjustment for each unit.
If you don't enable the feature, Pricing will determine the correct tier to apply according to the quantity across both lines on the order, but it will calculate the adjustment for the unit price according to the quantity on each line, not the total across lines. It won't calculate the extended amount for the tier adjustment correctly. The total quantity for:
- Line 1 is 65, which is in the second tier, so it gets a $2 adjustment for each unit.
- Line 2 is 5, which is in the second tier, so it gets a $.29 adjustment for each unit.
Get more accurate results when you use block pricing.
Steps to Enable
You don't need to do anything to enable this feature.
Key Resources
Access Requirements
Users who are assigned a configured job role that contains these privileges can access this feature:
- Price Sales Transactions (QP_PRICE_SALES_TRANSACTIONS)
This privilege was available prior to this update.