Can Modifier in Advanced Pricing be set up to meet various product/customer combination scenarios?
The scenarios as below:
The customer shall get discount for number of products. There are some overlapping among the products and customers, such as:
There are 40 products (Number 1 - 40), 5 customers (A, B, C, D, E):
Case 1: Customer A has the 20% discount for any of 40 products
Case 2: Customer B has the 20% discount for product 1 - 10
Case 3. Customer C has the 20% discount for product 5 - 20
Case 4. Customer D has the 20% discount for products 20 - 30
Case 5. Customer E has the 20% discount for products 25 - 40
I created a Modifier: Type - Discount List, At Modifiers Summary section, Level - Line, Modifier Type - Discount, Pricing Phase - List Line Adjustment, Product Attribute - Product, Product Attribute Value - all the products (repeat 40 times).