3.5.4.2 Create Distribution Center Capacity Module

NGSALEM

I have completed the below task and added the formulas however, i am not sure about the numbers for the 

"Total Beginning Inventory" it seems that i have negative numbers as a result the Percentage Full numbers is not right:

Thus, i had to check again the formulas in INV01 Inventory Ordering and the SYS08:

Could you please support me here or just provide a hint?

 

• Module Name: INV04 Distribution Center Capacity 
• Dimensions: s G3 Location: Distribution Centers? list, Time (month)
• Category: Inventory 
• Functional Area: Inventory 

 

Line Item Format Purpose

Total Beginning Inventory	Number	Display total Beginning Inventory by Distribution Center for each month
Distribution Center Capacity	Number	Display Distribution Center Inventory Capacity
Percentage Full	Percentage	Display the Distribution Center’s current percentage full – amount of inventory compared to the available capacity

NGSALEM

Thank you very much Jared! i did not think at all about the Time Hierarchy. Thank you very much for your support!!

As for the INV01 i checked the formula it looks okay. Then i checked the DAT01 Beginning Inventory and i checked it against the provided file (Beginning+ Inventory.csv) and i can see the same total.