Level 2 sprint 3 Build Distribution Summary Dashboard

kunal_311
Frequent Contributor

Level 2 sprint 3 Build Distribution Summary Dashboard

In the activity following instructions were given, where I am confused with the highlighted one

kunal_311_0-1597232144254.png

1) Applying a filter to DAT01 Beginning Inv -  I am confused as in how to show which Product SKU is stored at which distribution center, what i thought was in the line item Nutzo bar EN SKU & New york as distribution center should be equal. is that not correct?

kunal_311_1-1597232350325.png

2) SYS 07 & 08 want to show label of selected DC & Product. but I am confused about how to acheive that. As i am not seeing any option in DB to enable that

 

kunal_311_2-1597232513361.png

 

 

 

 

14 REPLIES 14
augustus.perera
Contributor

Hi Swapnil

 

Thank you for direction, I tried below...

 

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN 'INV01 Inventory Ordering'.Ending Inventory[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS08 SKU Details'.Distribution Center'] ELSE 'DAT01 Beginning Inventory'.Beginning Inventory gave an error msg like below.

 

Augustus_2-1601854676448.png

 

 

However I need to bring...Monthly Ending Inventory (in other words Monthly Beginning inventory Feb 20, sku1 + sku2 + sku 3 to calculate the fill rate for Feb 20, based on the location capacity, refer target module screenshot)

 

with previous function I get the total All product i.e 115,941 total duplicated to each sku, any method to extend the formula? 

my attempts.

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN PREVIOUS('INV01 Inventory Ordering'.Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

 

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN 'INV01 Inventory Ordering'.Beginning [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS08 SKU Details'.Distribution Center'] Inventory ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

 

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN 'INV01 Inventory Ordering'.Beginning [SUM: 'SYS08 SKU Details'.Product, SUM: 'SYS08 SKU Details'.Distribution Center'] Inventory ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

 

Augustus_0-1601854326825.png

 

Augustus_1-1601854568486.png

 

 

swapnil_J
Frequent Contributor

You have already created the formula for Beginning Inventory line item in INV01 module.

You don't need to rewrite that formula in T.B  Inventory line item INV04 module.

try with this : 

INV01.BEGINNING INVETORY[SUM: ......]

augustus.perera
Contributor

Hi Swapnil

 

Appreciate the direction, Thank you.

 

 

mmanocha
New Contributor

@kunal_311 Please help me how to figure this out. I am stuck at the point of Distribution center - Product SKU Grid.

Thanks in Advance

ryan_kohn
Certified Master Anaplanner

FYI @mmanocha @kunal_311 I have moved this post to the Academy & Training forum.