web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to add table displ...
Finance | Project Operations, Human Resources, ...
Answered

How to add table display method values in the data entity

(0) ShareShare
ReportReport
Posted on by Adam123 534

Hi Guys,

General ledger -> journal entries -> general journal

In general tab

field name -> GST amount

pastedimage1623344708733v1.png

This field in the form getting the value from the table display method (Table - Ledger journal trans , method - TaxAmountJournal)

GST Amount- (Table - Ledger journal trans , method - TaxAmountJournal)

My requirement:

When I click "General journal line entry "  the excel template will be opened consist of entity fields (entity - LedgerJournalHeaderEntity) and there I should get the GST amount field in the excel.

since it is in the format of table display method I can't able to add the method in the entity.

How to add the table display method in the entity?. 

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Jenifer,

    You can use computed columns or virtual fields. It is explained in the documentation what you can do with T-SQL or x++ methods. 

    Computed columns and virtual fields in data entities

    WIth the virtual field you can call x++ coding and call the same method as the display method. Note that it will slow down the performance of the data entity.

  • Verified answer
    huijij Profile Picture
    huijij 19,811 on at

    Hi Jenifer,

    As André mentioned,with the virtual field you can add table display method values in the data entity:

    docs.microsoft.com/.../data-entity-computed-columns-virtual-fields

    regards

  • Verified answer
    Hossein.K Profile Picture
    Hossein.K 6,648 on at

    Hi jenifer,

    A data entity can have additional unmapped fields beyond those that are directly mapped to fields of the data sources. There are mechanisms for generating values for unmapped fields:

    - Custom X++ code

    - SQL executed by Microsoft SQL Server

    The two types of unmapped fields are computed and virtual. Unmapped fields always support read actions, but the feature specification might not require any development effort to support write actions.

    Computed columns and virtual fields in data entities

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans