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!
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.