Finance | Project Operations, Human Resources, ...

Custom field like to map in base data entity

(0) Share

Report

Posted on by Community member

Hi team,

I have added a new date field in my CUSTOM table.

That field I like to map with Inventory adjustment Journal header and line entity.

Kindly let me know

1.how I can find the correct entity name for Inventory adjustment journal?

2.let me know the steps to map custom field in base (stnd.) Data entity. For example- inventory adjustment journal header line entity.

Pls. Give me more shed on this.

Thanks!

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Custom field like to map in base data entity

Hi, You can find the data entity from UI in Form. Find the form for inventory adjustment journal, click on Microsoft office button next to attachments button and check the data entity name.

We can't modify standard data entities so to add custom field, you need to create data entity extension and its staging table extension. Add field in data entity extension and staging table extension.

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Custom field like to map in base data entity

I noticed you mentioned custom table, can you add your custom table as datasource in data entity extension.

Was this reply helpful? Yes No
Community member 16 on at

Like (0)

Report

Custom field like to map in base data entity

No Mohit, I haven't yet add my custom table in data entity extension.

I have already mentioned that let me know the process to map custom field to map with base data entity.

Kindly elaborate the steps pls.

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Custom field like to map in base data entity

if there is table relation between your custom table and data entity form datasource table then it's same as joining datasource in form via table relations otherwise you can explore virtual field or computed field as well.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Custom field like to map in base data entity

Hi,

You can use Inventory adjustment header and lines V2 entity.

For adding custom table to datasource you need to find the relation between table in entity datasource - If exists add directly otherwise create relation in custom table.

Refer to the below blog for adding new field to custom entity via extension.

https://shyamkannadasan.blogspot.com/2017/10/data-entity-extension-in-d365-ax.html?m=1

Thanks,

Girish S.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Custom field like to map in base data entity

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Custom field like to map in base data entity

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates