Hi Damon,
Well..
There are 3 options you can do:
1. If the Discount you put 10, 20, 30 are based on the quantity, you might try use only 1 Price List with each Price List Item will have 1 discount list with 3 discount item based on your percentage and how many quantity (in range)
2. If your discount is not based on the quantity, then you can create 4 price lists (your approach is correct)
1. 10 Percent Price List
2. 20 Percent Price List
3. 30 Percent Price List
4. Standard Price List
Which you need to define each Price List Item and Price. And each Price Lists Item should have at least 1 discount to define the discount.
But, do not forget your Price List Item for those 4 Price Lists should have SAME Price, because if not, you will have double discount, see the example after the third one.
3. Similar to option 2, but you create 4 Price Lists with different Price List but without attach any discount.
So, this is kind of manual calculation for the Price List.
*This is the Price List example for number 2
(4 Price Lists with same Price with discount list)
Price List Product Price Discount List
-------------------------------------------------------------
Standard Printer ABC 10000 NO
10% Printer ABC 10000 10%
20% Printer ABC 10000 20%
30% Printer ABC 10000 30%
*This is the Price List example for number 2
(4 Price Lists with different Price, manual calculated Price aft discount)
Price List Product Price Discount List
-------------------------------------------------------------
Standard Printer ABC 10000 NO
10% Printer ABC 9000 NO
20% Printer ABC 8000 NO
30% Printer ABC 7000 NO
So, basically for the sample 2 and 3 it will only kind of "borrow the name" of
1. 10 Percent Price List
2. 20 Percent Price List
3. 30 Percent Price List
4. Standard Price List
Hence, your approach is I think is number 2 and it is a great idea, just remember if you choose number 2, make sure you don't give double discount.
If the discount you are referring is based on the quantity, I'd still prefer to recommend you use approach #1, save space, save records created, low-cost maintenance because as per you say if your boss want to change the discount just go to the Discount List.
I hope this helps you.
If my answer helped you please you help to verify it.
Thank you.
