How to make Data entity's field from a method with parameter

(0) Share

Report

Posted on by ShaqAX

709

Hello guys,

Need some help for creating a data entity, it is for export to BYOD and related to table ProjInvoiceJour.

So I notice in ProjInvoiceJour table there is no field InvoiceAmountMST and I need this field to be exported as well to my BYOD. I have created the data entity but now its field only contain the table original field. Notice in the method of ProjInoviceJour there is one method for calculate AmountMST but it is requires a parameter which is the InvoiceAmount. ->

How to use this method to make my data entity has a field with the result of that calculation, I know the parameter will be retrieved from InvoiceAmount field in ProjInvoiceJour, but I don't know how to make it as a display field in data entity.

Thanks

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Martin Dráb 237,882 Most Valuable Professional on at

Like (0)

Report

If you have no idea how to do it, it's time to look into documentation: Computed columns and virtual fields in data entities.

If you want to use CurrencyExchageHelper, you need a virtual field. If you wanted to use a computed column, you'd have to rewrite the logic to T-SQL (which doesn't look like a good idea in this case).

I'm assuming that you have InvoiceAmount in your entity, and this field will be the input for the calculation.

Was this reply helpful? Yes No
ShaqAX 709 on at

Like (0)

Report

Hi Martin,

Thanks for the advice. I create this method. should be sufficient as I tested.

public static server str InvoiceAmountMST()

{

str InvoiceAmountField = SysComputedColumn::returnField(

tablestr(XYZProjInvoiceHeaderEntity),

identifierStr(ProjInvoiceJour), fieldStr(ProjInvoiceJour,InvoiceAmount));

str ExchangeRateField = SysComputedColumn::returnField(

tablestr(XYZProjInvoiceHeaderEntity),

identifierStr(ProjInvoiceJour), fieldStr(ProjInvoiceJour, ExchRate));

return strFmt('%1 * isnull(%2,100)/100', InvoiceAmountField, ExchangeRateField);

}

Regards,

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,882 Most Valuable Professional on at

Like (1)

Report
It looks good, if you don't need all the other logic of CurrencyExchangeHelper::mstAmount().

Just please always use Insert > Insert Code (in the rich-formatting view) to paste source code:

public static str invoiceAmountMST() { str invoiceAmountField = SysComputedColumn::returnField( tableStr(XYZProjInvoiceHeaderEntity), identifierStr(ProjInvoiceJour), fieldStr(ProjInvoiceJour,InvoiceAmount)); str exchangeRateField = SysComputedColumn::returnField( tableStr(XYZProjInvoiceHeaderEntity), identifierStr(ProjInvoiceJour), fieldStr(ProjInvoiceJour, ExchRate)); return strFmt('%1 * isnull(%2,100)/100', invoiceAmountField, exchangeRateField); }

By the way, I threw away the server keyword, because it doesn't have any effect in F&O. There is no X running on client anymore.

Was this reply helpful? Yes No
Marwa El Sawah 5 on at

Like (0)

Report

Hello,

How did you find ProjInvoiceJour at the data entity creation wizard? I couldn't find it.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to make Data entity's field from a method with parameter

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 make Data entity's field from a method with parameter

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