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)
Go to Solution.
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
View solution in original post
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
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
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.
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)
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