Advance Pricing- Discount Bucket

  Discount Bucket

Different bucket will have cascading effect . Same bucket are additive.

System will apply the 1st bucket on the unit price and then 2nd bucket will be applied and then the 3rd bucket will be applied and then 4th bucket will be applied .The null bucket will be applied on the base price.

Enter the PrecedenceSet the discount percentage

Transaction Process Flow

Create the sales order and save the transaction.

Click on Actions to view the Adjustments. Four modifier lines got applied.

Scroll the adjustment window to check the extended amount

Output

1. Line 10 (228008) will be applied on total unit price(10) as the bucket is set as 1. 1st this get applied on the unit price.

Unit Price * Discount Percentage

=10*10/100  = 1

Derive Extended Amount 

= Unit Price  - Discount Value 

=10-1 = 9 

2. Line 20 (228012) will be applied on 1st line 9 dollar as the bucket is set as 2 . 2nd this get applied on the line 10 derived price . 

Line 10 Extended Price * Discount Percentage

=9*20/100  = 1.8

Derive Extended Amount 

= Line10 Extended Price  - Discount Value 

=9-1.8 = 7.2

3. Line 30 (228010) will be applied on 1st line 9 dollar as these are additive final value derived from the line 20.

Line 30 (228010) will be applied on 1st line 9 dollar as the same bucket is addictive. 3rd this get applied on the line 10 derived price . 

Line 10 Extended Price * Discount Percentage

=9*10/100  = 0.9

Derive Extended Amount 

= Line 20 Extended Price  - Discount Value 

=7.2-0.9 = 6.3    

4. Line 40 (219077) will be applied on line 30

Line 40 (219077) will be applied on 3rd line 6.3 dollar as the bucket is set as 3 . 4th this get applied on the line 30 derived price . 

Line 30 Extended Price * Discount Percentage

=6.3*40/100  = 2.52

Derive Extended Amount 

= Line30 Extended Price  - Discount Value 

=6.3-2.52 = 3.78

Note : Applied based on buckets starting from1 to end . Such as  1,2,3,4.,etcc...If the buckets are same then it will consider the based on higher percentage. If the percentage is same then it will consider based on the precedence.  Based on the above concepts modifier gets applied.