INV01 Reorder Flag Line Item

neg177
neg177
in Modeling

Hi,

 

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 

Tagged:

Best Answer

  • Misbah
    Misbah
    Answer ✓

    @neg177 

     

    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

    Misbah

Categories