News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX forum Field Calculations in ...

Microsoft Dynamics AX forum

Answered

Field Calculations in form

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi All,

I have a customised form, need to calculate some fields in that form. where can i do coding for this calculation?

How can i complete my requirement? Please suggest me!

Categories:

Development / Customization / SDK

All responses Img

All responses (4)

Answers Img

Answers (3)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Field Calculations in form

Hi Devid,

Try this code!
public void modifiedField(FieldId _fieldId)
{
   YourTable yourTable;

   super(_fieldId);

    switch (_fieldId)
        {
            case fieldNum(YourTable, opening balance):
            case fieldNum(YourTable, closing balance):

            this.Actual balance = this.opening balance - this.closing balance

            Break;

       }

}

Thanks

Suresh
Community Member Microsoft Employee on at

Like (0)

Report

RE: Field Calculations in form

Hi Tatiana Garcia Ramos and Suresh potlakayala

Thanks for your response, I'm expecting Actual balance = opening balance - closing balance.

Can you please suggest any code for this?
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Field Calculations in form

Hi Devid,

You can do this calculation in multiple ways!

1.In table you can do this by using ModifiedField method.

but it will effect on everywhere which you used that calculation.

2.In form design> wherever you want do that calculation you need to do coding in that field.

in that field > modified field > do code here!

this type of calculations will be done in form level, this is the best practice

Please refer my blog, it may usefull for you.

http://axsuresh.blogspot.in/2016/03/table1.html

Thanks

Suresh
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Field Calculations in form

the best way to do it, is creating a new display or return method in the table.

Add a string control in the form and call the method in the table, otherwise your calculation will always show in all the records in the grid the same value.

Try this, and if you have more question I will help.

Helpful resources

News and Announcements

New Dynamics 365 Community Call! (ERP Edition)

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,115 Super User 2024 Season 2

#2

Martin Dráb 227,971 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans