Good Morning
We have a requirement to Invoice for the price on the Shipped At date for a customer.
Scenario 1 (Today is the 17th July)
We fulfill orders on behalf of this client, a customer of the client places an order for delivery on some future date (eg 17th August). The clients price book has an entry for a new price Start Date of the 1st August - how do we ensure that that price is used when the order is placed (it appears to use the current price)?
Scenario 2
We fulfill orders on behalf of this client, a customer of the client places an order for delivery on some future date (eg 17th August). The clients price book gets revised on the 1st August and has a new price with a Start Date of the 2st August - how do we ensure we use the new price when we ship the order?
Solution would appear to be a flag on an invoice run or at shipping that fetches the correct price from the price book? But no idea how to get there or if it even exists.
Note: there could be hundreds of orders, so a manual solution, whilst helpful in figuring out an automatic solution, wouldn't be viable
Thanks in advance
