Hi,
I understand how Products, Price lists and Discount Lists work generally, but I still cant figure out the best way to setup a Product Catalog reflecting the following:
The customer wants to buy a certain number of items of a product.
- When buying 1 to 10000 items, the price per item is X Euro . Let's call the number of items in this price range A.
- When buying 10001 to 100000 items, the first 10000 items still cost X Euro per item, but the items from 10001 and upwards (but less than 100001) cost 30% less, i.e. price per item is 0.7*X. Let's call the number of items in the mid price range B.
- When buying 100001 or more the item price for the number of items above 100000 is 0.5*X. Let's call the number of items in this low price range C.
The formula for the Total price is then =(X*A) + (0.7*X*B) + (0.5*X*C)
I don't want a general discount volume percentage to be applied because I don't want it to be cheaper to buy 10001 items than 10000.
Ideally, I want the Sales Responsible to only have to input the Total amount of items, and then the price will be correctly calculated.
How to best solve this?
