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 

ankitaga2000_0-1616125569102.png

 

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

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

 

 

 

Regards,

Ankita

Comments

  • @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

  • @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 ?

    ankitaga2000_0-1616151630890.png

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

     

    Regards,

    Ankita

  • @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.

    @Misbah 

    ankitaga2000_0-1616167671224.png

    ankitaga2000_1-1616167683665.png

     

  • @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 ?

     

    Regards,

    Ankita

  • 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