How to add table display method values in the data entity

(0) Share

Report

Posted on by Adam123

534

Hi Guys,

General ledger -> journal entries -> general journal

In general tab

field name -> GST amount

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)

All responses (3)

Answers (3)

Sort by

Verified answer

André Arnaud de Cal... 305,182 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

huijij 19,813 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Hossein.K 6,650 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No