Finance | Project Operations, Human Resources, ...

Form fields calculation

(1) Share

Report

Posted on by D365FO DEV

406

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?

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Layan Jwei 8,271 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,809 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No