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
Solved!去解决方案。
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
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
Regards,
Ankita
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)
Correct ?
Regards,
Ankita
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
Can you please explain me these formulas . I am not very clear
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