*** How to bill minimum and maximum amounts based on price breaks ***

Hi,

Our client wants to use pricing tiers to bill the customers based on qty.

However, if the derived amount exceeds the maximum amount, maximum amount should be billed. Similarly if the derived amount falls below the minimum amount,  minimum amount should be billed.

Example :

Price break type : Range

Minimum amount : $100

Maximum amount $600

0-100 : 100$ Lumpsum

100-200 : 90 cents per txn

200-500 : 80 cents per txn

If the qty is 80, then 100$ should be billed since the minimum amount is $100.

If the qty is 500,billing amount is calculated as below, billed amount in this case should be maximum amount i.e $600 and not the derived amount $750