3.5.4.2 Create Distribution Center Capacity Module

Hi,

I am having trouble getting the Total Beginning Inventory to map correctly. I am using the formula: 'INV01 Inventory Ordering'.Beginning Inventory [SUM: 'SYS08 SKU Details'.Supplied By]. I get the following error: "Datatype mapping used for aggregation doesn't match any dimension of the result" I'm not sure how to map this formula without using SYS08 Supplied By (list). If you can help, I'd appreciate it!

Comments

JaredDolich

@rdjeanlouis

Your formula is correct. 'INV01 Inventory Ordering'.Beginning Inventory[SUM: 'SYS08 SKU Details'.Supplied By]

Start by making sure your INV04 module is using s G3 Location:Distribution Center? in the "applies to".

The list in your TARGET must match the line item format in the SOURCE in order to use SUM.

rdjeanlouis

Thanks for the insight

Jzink

Hi @JaredDolich

Why would I use the "SUM function" for the "INV04 Beginning Inventory" line item instead of pulling the beginning inventory info directly from the "DAT01 Beginning Inventory" module?

Thanks for your help

JaredDolich

@Jzink

Awesome callout. In this case we SUM on this line item because we want all the beginning inventories added up by DC since that is our target module dimension. But, as you correctly figured out, we are directly bringing it in, we just need to make sure its in the same dimension as our Target.

Jzink

@JaredDolich Thank you so much for explaining and your quick reply! Does that mean I would also use SUM for the "DC capacity" line item rather than using 'SYS07 Distribution Center Details'.Capacity' as well?

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…