List Duplicate Value Issues Hub Model
Hello,
In our hub model, we have a sales planning list (L1 Plants) with top level item All Plants. We have other sales planning list (L3 Profit Center) with top level item All Profit Centers
We have mapping list L3 Profit Center- L1 Plant with parent hierarchy as L1 Plants.
We have a new use-case where profit center rolls up to multiple plants. Mapping list will not accept duplicate (Profit center) under different plants.
Ex:
Profit Center- Plant
100505 - Plant A
100506 - Plant B
New Adj
Profit Center- Plant
100505 - Plant A
100505 - Plant B
100506 - Plant B
This use case did not exist when our model was originally built.
Looking for advice/information on how to adjust for this.
Best Answer
-
Hi @Jojo88 ,
Mark mapping list L3 Profit Center- L1 Plant as a numbered list and concatenate codes of Plant (L1 Plants) and Profit center(L3 Profit Center), then you will have unique codes for mapping list L3 Profit Center- L1 Plant with parent hierarchy as L1 Plants.
In this way your issue of duplicate (Profit center) under different plants will be resolved.
~ Jitendra
2
