Level 2 INV01 Begging inventory and Confirmed PO line item

[ankitaga2000]

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)

Regards,

Ankita

[Misbah]

@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

[ankitaga2000]

@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

Regards,

Ankita

[Misbah]

@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

[ankitaga2000]

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

@Misbah

[Misbah]

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

[ankitaga2000]

Wait . I am confused.@Misbah

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

Correct ?

Regards,

Ankita

[Misbah]

Nope.

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

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

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

[ankitaga2000]

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

[Misbah · Accepted solution]

@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