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)
Regards,
Ankita
Comments
-
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
0 -
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
0 -
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
0 -
I am attaching the screen shots for DAT01 and SYS01 modules. Please verify as they are populated correctly.
0 -
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)
1 -
Wait . I am confused. @Misbah
This is formula for First Week of scale === NOT (OFFSET(1, -1, 0) = 0)
Correct ?
Regards,
Ankita
0 -
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
1 -
Can you please explain me these formulas . I am not very clear
0 -
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
1 -
Thank you0