Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 66

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

pastedimage1668713211554v1.png

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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 225

#2
Martin Dráb Profile Picture

Martin Dráb 174 Most Valuable Professional

#3
Adis Profile Picture

Adis 132 Super User 2025 Season 1

Overall leaderboard

Product updates

Dynamics 365 release plans