Dynamics Community Forum Thread Details

Custom data entity with multiple Table/Group/All relations on ItemId

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.

Quick Links