Level 2 INV01 Begging inventory and Confirmed PO line item

Hi All,


Please help me with the formula for Beginning Inventory 


My formula is - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory


I don't know why I am getting everything negative in Beginning Inventory 



Also let me know If i am correct in using the correct formula for Confirmed PO Delivery

OFFSET(PO submitted, -Shipping Time Weeks, 0)







  • @ankitaga2000 


    Your Formulae looks perfect. However I see Reorder Flag checked every week which must be throwing your numbers off. And I also see Shipping Time Weeks populated as 0. For Shipping Method as "Road" it needs to show "2" in Shipping Time Weeks


    Hope that helps


  • @Misbah 

    I have corrected my Shipping time Weeks line item. But why my reorder flag is checked for all. I am not able to understand .Also the beginning inventory ?


    The formula for REdorder flag -- IF OFFSET(Ending Inventory, Shipping Time Weeks, 0) <= 0 THEN TRUE ELSE FALSE




  • @ankitaga2000 


    Formula looks ok to me not as per best practice though - You don't need to write IF else statement here


    OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0


    Now to your query: Can you please share how your DAT Beginning Inventory module looks like, I mean are the numbers populated correctly

    Also can you check if your SYS Time Module is working fine. Snapshot here would help

  • I am attaching the screen shots for DAT01 and SYS01 modules. Please verify as they are populated correctly.





  • @ankitaga2000 


    Not First Week of Timescale looks wrong. First Week should be Unchecked. 


    Verify the formula: It should be like this


    NOT (OFFSET(1, -1, 0) = 0)

  • Wait . I am confused. @Misbah 

    This is formula for First Week of scale ===     NOT (OFFSET(1, -1, 0) = 0)


    Correct ?




  • Nope. 

    This is for the line item which is titled as NOT FIRST WEEK OF TIMESCALE


    OFFSET(1,-1,0) = 0 This will be for First week of timescale

    NOT(OFFSET(1,-1,0) = 0 will be for Not First Week of timescale

  • Can you please explain me these formulas . I am not very clear

  • @ankitaga2000 


    Solved: Level 2 Sprint 3 INV01 - Not 1st week of Timescale... - Anaplan Community


    See this post - I have explained it here how this formula works

  • Thank you