How to use "No. of life remaining" of lot as the benchmark for advanced pricing adjustment?
The user wants to define the discount based on the remaining days of the item.
Example:
Discount strategy:
- No. of life remaining<=180 days, 30% off base price
- No. of life remaining>180 days,20% off base price
Item A, Lot/Serial No. 001,base price:$ 100,No. of life remaining:240 days; price=$100*(1-20%)=$80
Item B,Lot/Serial No.002,base price: $ 100,No. of life remaining: 160 days;price=$100*(1-30%)=$70;
How do I set it up?