How to Add a Display Method of a table as a filed in a View

(0) Share

Report

Posted on by Prem

Hi All,

I have created a View with CustTrans as a DataSource and I need to add remainAmountMST() display method of CustTrans Table as field in my view. Can anyone help me on this.

Thanks In advance,

Prem Sai.

I have the same question (0)

All responses (4)

Answers (0)

GirishS 27,827 Moderator on at

Like (0)

Report

How to Add a Display Method of a table as a filed in a View

Hi Prem,

I would suggest you to create a computed column for that method and map it to the field.

Thanks,

Girish S.

Was this reply helpful? Yes No
Martin Dráb 237,681 Most Valuable Professional on at

Like (0)

Report

How to Add a Display Method of a table as a filed in a View

Views are defined in database, while display methods are in the application layer written in X++. The database server know nothing about the application an X++, therefore you can't refer to such methods from T-SQL.

Therefore your current technical design can't be implemented. You'll need to change your approach, e.g. by using a computed column or creating a display method for your view.

Was this reply helpful? Yes No
Prem 10 on at

Like (0)

Report

How to Add a Display Method of a table as a filed in a View

Can anyone give me T-SQL code to create the computed column for remainAmountMST() display method of CustTrans Table.

Was this reply helpful? Yes No
Martin Dráb 237,681 Most Valuable Professional on at

Like (0)

Report
How to Add a Display Method of a table as a filed in a View

Before you can even start designing your SQL code, you must look at the logic in X++. You'll find it in remainAmountMST() method of CustVendTransData class.

It looks like this:

public AmountMST remainAmountMST() { AmountMST remainAmountMST; #ISOCountryRegionCodes boolean countryRegion_RU = SysCountryRegionCode::isLegalEntityInCountryRegion([#isoRU]); if (custVendTrans.TransType == LedgerTransType::ExchAdjustment || (countryRegion_RU && custVendTrans.TransType == LedgerTransType::AdvanceAdjustment_RU)) // </GEERU> { remainAmountMST = custVendTrans.AmountMST - custVendTrans.SettleAmountMST; } else { remainAmountMST = custVendTrans.AmountMST + custVendTrans.ExchAdjustment - custVendTrans.SettleAmountMST; } return remainAmountMST; }

Then consider whether you need all the logic. For example, you can simplify your code a lot if you decide not to support the logic around AdvanceAdjustment_RU.

Then I recommend writing and testing T-SQL, before writing a computed column method generating this SQL code.

A piece of information that will help you is that the mapping between enum elements names and values is in EnumValueTable.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to Add a Display Method of a table as a filed in a View

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

How to Add a Display Method of a table as a filed in a View

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