My Reorder Flag Line Item is not working properly. This is the formula I have, and attached you can see that Week 5 nor Week 6 are not checked when they are supposed to be. Please advice
OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0
Go to Solution.
I think you need to Check Submit Purchase Order Request for Week 1 and Week 2. Which will drive everything until Ending Inventory which in turn is being used in Reorder Flag.
As Such I don't see any issue in the formula, its perfectly alright