We are having some negotiated items with customer, which we markup fixed amount based on cost.
Like Item A, FIFO, fixed markup amount $ 5 per case
First Purchase, $20 per case, then we sell $25 per case
second purchase, $30 per case , then we sell $35 per case.
Supposing we are having 100 cases $20 item A and 400 cases $30 cases item A.
The perfect solution we are seeking for: is it possible that, after the 100 cases of $20 be sold out, then the sales price automatically jump up to $35.
If this is not possible right now. Is there a way that can automatically reminder the human that the 100 cases of old inventory be sold out, you have to update the price.
Please advise. Thank you.