PO Price Update
Scenario -
Say I have a batch of Purchase Orders and I have to change the prices but the prices to use varies depending on when the goods were deliver (which is 95% on the need-by-date or promise date).
The prices on the pricelist are set on a weekly basis, set at the beginning of a week for the week.
Since PO can be created 2/3 weeks in advance, this causes problems as the correct price is not on the PO at the time of creation, hence the price have to be updated when the price is known.
For Example – there are PO for week1, week2 and week3. We are in week2 now and the price is set, so we only want to update week2 PO with the price.