Hi,
I have customized the CostSheetCalculationFactor table which has already these fields:
- ItemCode
--> TableGroupAll enum
- ItemRelation
--> string field containing either an InventTable.ItemId (if ItemCode = Table) or an InventGroup.GroupId (if ItemCode = Group)
I have added following custom fields to the table
- AdditionalCostItemCode
--> TableGroupAll enum
- AdditionalCostItemRelation
--> string field containing either an InventTable.ItemId or an ITMCostTypeGroup.CostTypeGroupId (ITMCostTypeGroup.ITMCostTypeGroupId is part of the Inbound Transportation Management model)
I have also duplicated the "CostSheetNodeCalculationFactorV2" data entity, which I want to customize to fill my custom fields mentioned above.
The problem I am having now is that there are (standard D365) computed columns for the ItemNumber and ProductGroupId which are being retrieved through the table map EcoResTableGroupAllProductRelationExpansionMapping.
I'm assuming these are necessary to fill the ItemCode and ItemRelation values in the CostSheetCalculationFactor table ?
I'm also assuming I will have to add similar customizations in order to retrieve ItemId/ITMCostTypeGroupId values for my custom fields ?
But I cannot add another EcoResTableGroupAllProductRelationExpansionMapping to the data entity to set up proper relations for my custom fields.
What I would like to achieve is something like this
Is this possible ?
How should I proceed ? Do I have to duplicate the table map EcoResTableGroupAllProductRelation and add the duplicate to my custom data entity ?
Or is there another approach ?
Thanks for your input.