Finance | Project Operations, Human Resources, ...

Form fields calculation

(2) Share

Report

Posted on by D365FO DEV

388

Hi, on my customized form, i have 2 tabs, quotation line and quotation lines details, i want the sum of the field Unit price to show on the total amount. also note that each field is in different data source. how this can be done ? where and which method should be overrided?

All responses (4)

Answers (0)

D365FO DEV 388 on at

Like (0)

Report

Form fields calculation

Hi @Mohamed,

One issue is that i need to auto refresh the page, so the total amount gets updated.

i created a display method on the table, then attached this method on the field total amount on the form level under data method.

calculation is correct but the total amount is not getting updated if i do not refresh the page.

why?
Suggested answer

Mohamed Amine Mahmoudi 9,861 Super User 2024 Season 2 on at

Like (0)

Report
Form fields calculation

Hi @D365FO ERP Developer,

You must use a Display Method to calculate the total amount based on unit price.

e.g.

public display Name TotalAmount() { Table table; select sum(UnitPrice) from table where ... return table.UnitPrice; }

Best regards,

Mohamed
D365FO DEV 388 on at

Like (0)

Report

Form fields calculation

hi Layan,

thanks for your reply.

the total amount field is of type Real.

also theres no init method to override neither on the table nor form level.

theres the init value method.
Suggested answer

Layan Jwei 7,369 Super User 2024 Season 2 on at

Like (0)

Report

D365FO Form fields calculation

Hi D365FO developer,

What is the type of total amount, is it display method or field?

If it's a normal field:

When you first open the form, you would like to see the sum of unit price, so you need to override the init method and calculate the sum for unit price lines

You also would like the total amount to be amended whenever someone changes the unit price, so you need to override the modified method of unit price to recalculate the total amount

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future