Level 2 Sprint 3 3.5.4.2 Create Distribution Center Capacity Module

Hi! I am having issues with the formula for Total Beginning Inventory in INV04 Distribution Center Capacity.

The formula I have used is 'INV01 Inventory Ordering'.Beginning Inventory[SUM: 'SYS08 SKU Details'.Distribution Center] but it only returns zeros instead of the correct amounts. Any idea why would this happen please? Attached some screenshots.

I just can't figure out why it's not working. Thank you!

Capture1_103412.JPG

Capture2_103412.JPG

Capture3_103412.JPG

Capture4_103412.JPG

Comments

EgeK

Hi @evacarusu ,

I think this might be the case because your Time Summary for 'INV01 Inventory Ordering'.Beginning Inventory is set to 'None'.

Maybe double check INV01 in blueprint mode to see the Summary setting for the Beginning Inventory line item?

Try using WEEKVALUE() since your source module is in weeks and your target module is in months.

https://help.anaplan.com/61d25d47-13da-4ec0-8659-2e845b3b4a09-WEEKVALUE

Hope this helps!

evacarusu

Hi @EgeK ,

Thanks for looking into this.

The summary type for Begining Inventory in INV01 - I set this to None as required in the training instructions. I changed this now for testing purposes to "Closing Balance" but this still doesn't seem to solve the issue in INV04.

Regarding the WEEKVALUE() function. My source model is at week level but the target is at month level. Shouldn't this then be automatically aggregated by Anaplan without me using weekvalue?

Thank you!

EgeK

Hi @evacarusu

If you were told to set it to None that should be fine. I think it only automatically sums periods as you've said when the summary method is selected to the appropriate setting.

I apologise, you're right WEEKVALUE() is not what you need, I was meant to say try MONTHVALUE()?

https://help.anaplan.com/8b54b167-4cfc-488c-9f7f-32baac1e1fe7-MONTHVALUE

Hope this helps!

evacarusu

Hi @EgeK ,

Thank you. According to Time aggregations I shouldn't need any time aggregation functions. I don't know, it might be a bug or something, I'll try to build the module again from scratch. Thanks!

Time_aggregation_103433.JPG

evacarusu

Ok, so I just built it from scratch, same formula, same summary method for the source model (None) and this time it worked...still no idea why I got zeros in the first place. But glad it works. Thanks!

EgeK

Eyyy well done, that's great to hear!! I'm glad it worked in the end 🙂

ChrisAHeathcote

@evacarusu

Your source module INV01 has not value for month as you have set the summary to none.

Change this to closing balance for time.

I can not see any other problem with your formula.

The mapping is correct as you are summing into the distribution centre using a mapping table dimensioned by SKU and line item formatted by Distribution centre.

The only odd thing is the summary setting.

Good luck,

evacarusu

Thank you @ChrisAHeathcote ! Yes, Summary method None + Time: Closing Balance worked.

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…