INV01 Reorder Flag Line Item




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


Thank you 

Best Answer

  • Misbah
    Answer ✓



    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