Level 2 Model Building, Sprint 3, INV01 Inventory Ordering
May be you can help me to figure out why some of my numbers didn't match...
And what is wrong with the formulas? May be I'm getting wrong the instructions and do not understand something... I appreciate any help. Thank you.
Thats how numbers are supposed to be
and not the same:
1) Beginning Inventory for Jan 20
- Example - there is a summary for the month
- Me: Having the last week number
My formula is:
IF NOT 'SYS01 Time Settings By Week'.'1st Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
and by the description of the formula I'm kind of got it correctly? What part is wrong here?
This line item needs to display the value from the Beginning Inventory line item in DAT01 Beginning Inventory module for the first week of the year and the Ending Inventory from the previous week.
The syntax of the formula should be written: If it is not the first week of the year, then use the previous value of Ending Inventory, otherwise use the Beginning Inventory from DAT01 Beginning Inventory module.
2) Reorder flag I have true only at week 7 FY20
while in the example it's in the week 5
my formula for it
OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0
3) SHipping Time Weeks
I have 0, while in the example is 2
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product]
4) Ending Inventory I guess has the same problem as beginning Inventory: showing last number (for the last week).
Beginning Inventory - Forecast Demand + Confirm Purchase Order Receipt
And I'm attaching my Blueprint View just in case