Pages

Saturday, 4 May 2024

Advance Pricing -Discount - Recurring

 Modifier Type : Discount -Recurring Type

If we give discount as recurring then unit price will be calculated based on the extended price total value

If we give recurring the discount can be given only in Lumpsum.  Lumpsum is mandatory for recurring Discount or Surcharge.

Ex : Consider Lumpsum value is 10  for range  5 qty to 999999 . It means for every 5 qty the lumpsum value will get into effect.

If you give 5 qty in the sales order the unit price will be calculated as below.

Qty * unit price = Extended price  :  5*10=50 

Extended price - lumpsum value = 50-10=40  

So extended price = 40 / qty  =40 /5 = 8 is the unit price derived.Select the Volume Type as "Item Quantity" and Break Type as "Recurring". Enter the quantity from and to range.Provide the lumpsum value as 10

Transaction Process Flow

Create the sales order.

Enter the quantity and initial unit price will be defaulted from the price list.
Once you save the sales order modifier gets applied to the sales order and price get changed as 8.Calculation is explained at the top how the unit selling price is derived.
Click on view adjustments. To find the modifier discount applied to the order.

Example 2 : 

Another example if the sale order qty is 15

The unit price is derived as below

Qty * unit price = Extended price  :  15*10=150 

Extended price - Lumpsum value = 150-30=120 (Have mentioned 30 because 5 comes 3times for 15 qty , as the lumpsum value is 10 for each 5 qty for 15 qty it will be 30 )

So extended price = 120/ 15 (qty) =8 is the unit price derived

Now initially without applying modifier  the price will show the original unit price

Once you save the screen modifier will be applied 

Go to actions and view the adjustments

Again if I give the qty as 15 lets see what will happen. It shows as lumpsum value is applied as 30.Calculation explained above how it was derived.





No comments:

Post a Comment