INV01 SPRINT 3 ISSUE
HI Team,
I have few issues with the formula, its right or wrong? i have noticed 3 issues in my model
1. For Beginning inventory my formula is
IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
here in week 2 of beginning inventory, it's displaying the same beginning inventory as week 1
2. Reorder flag my formula
OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0
it's not changing for week 6 because beginning inventory is the same for all weeks
3. shipping weeks my formula
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product]
It's showing on 1 in place it should show 2 for roads
can anyone help me where am going wrong! and is my formula right or wrong?
Answers
-
1. For Beginning inventory
IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory.
The formula written is close but needs a little tweak in the first part :- Instead of 1st forecast year you need to use "Not 1st week of Timescale" as data has to be identified and fetched through a conditional statement based on weeks .
2. Reorder flag my formula
OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0
Seems Right.
3. shipping weeks
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product]
Shipping Time weeks is calculated based on the products and the type of Shipping method used for the respective products. The formula is close, add shipping methods to find the right shipping time.
~ABhi
0 -
Thank you @abhi1017 i got solutions am in next step
0
