Hi everyone,
We maintain the sales price of a FIFO inventory item as "cost + fixed markup". Today this is done by a Business Event that runs on a daily schedule and sets:
Sales Price = current item cost + 5
The customer is not happy with this because it is not real time. Here is the scenario we hit yesterday: within the same business day, the older/cheaper cost layer was sold out first, and immediately after that we sold a large quantity that had to be issued from a much more expensive cost layer. Because the price update only runs once a day, we kept selling at the old low price even though the cost we were actually issuing had already jumped — so we lost margin on every unit sold after the layer switch.
What we are looking for: a way to recalculate and update the sales price immediately when the current (old) cost layer is fully consumed, instead of waiting for the next scheduled run.
Constraints / context:
- The item is FIFO only — lot/serial control is NOT enabled, so we cannot use lot-specific pricing or lot-level triggers.
- The current mechanism is a scheduled Business Event (daily frequency) that reads the cost and rewrites the sales price.