How to map one to many products in Anaplan?
Hello, I have the following problem. I am trying to associate Customer Part Number, which is a unique product code in the customer's store with the SKU that exists in my store. For example, the customer sells a set of furniture, a table and 4 chairs, as one code in his store, and in my store there will be two separate SKU codes for products for the table and for the chair. Hence, when receiving an order from a customer with his code, I have to remap it to two separate codes along with the number of products that the customer's code corresponds to.
I created the first SYS04 SKU CPN Mapping module, where I have two lists: Customer Part Number and SKU and Line Item Quantity. This module is intended to be used to copy the given Customer Part Number to the appropriate number of SKUs that must be counted when loading furniture from a customer order.
The second module is DEM00 CPN Sales, where orders are imported from a customer without converting to SKU quantities. That is, there is a customer order with the original Customer Part Number and its quantity. I use the Customers and Customer Part Number lists for it.
In the third module DEM01 SKU Sales I would like to show sales in terms of furniture that I produce, i.e. my SKU for a given customer. I have Line Item Quantity and lists of SKUs and Customers. What formula do I need to use to convert the values from DEM00 CPN Sales based on the SYS04 SKU CPN Mapping module for the appropriate SKU and Customer Part Number?
