3.5.4.2 Create Distribution Center Capacity Module

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_0-1659283001833_143675.png

NGSALEM_1-1659283119937_143675.png

NGSALEM_3-1659283323099_143675.png

NGSALEM_2-1659283272024_143675.png

Comments

JaredDolich

@NGSALEM

You're super close. Just need a few adjustments

Your summary methods should be more aligned with the time hierarchy. inventory uses a beginning or ending balance - see image below
Your percentage full calculation you took too literally. Think about how a percentage would apply here. Image below.
Your beginning inventory values should be checked in INV01. Make sure you've loaded the right data.

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.

Quick Links

Recent release news

June 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our June 2025 official release notes. The information below offers supplemental information to that post. Security and administration New 'Application Owner' security role Tenant administrations can assign the Application Owner role to users in their tenant.…
Register for our July 30 platform release webinar!
Anaplan's next quarterly platform release webinar will be held July 30, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of new…