we have a requirement from our marketing department.
We have prices for some material plant wise. Now we want to sell first N number (let us assume first 50 quantity in plant ) should have different pricing and after N quantity ( from 51st quantity ) in that plant should have different one.
(Ex. Let us say i am selling Reynolds Pen in two different sale offices.
Pricing in sale office 1 : for first 50 qty of Reynolds pen : Rs.12/-
from 51st qty of Reynolds pen : Rs.15/-
Pricing in sale office 2 : for first 50 qty of Reynolds pen : Rs.13/-
from 51st qty of Reynolds pen : Rs.16/-
How to achieve the special scenario ?
We cannot use condition update (but it is not going to come plant wise)
Please guide us in achieving this.