Sum of the invoice lines <> total for a project invoice proposal

(1) Share

Report

Posted on by Freud

Hello Experts

I would need you advise please:

When doing an invoice proposal, the sum of the invoice lines is different than the result of hour x rate.

Example:

So I would assume is 2 solutions here:

- change the way invoice amount is calculated: do the calculation at the end (in this example 35,40 x 65,5).

- change the rounded from 2 to 4 decimals?

Thank you very much

Have a nice day

All responses (5)

Answers (1)

Adis 4,167 Super User 2025 Season 1 on at

Like (1)

Report

Sum of the invoice lines <> total for a project invoice proposal

@Alireza Eshaghzadeh,

I was wondering if the round-off works like you explained it. Do you know any documentation on that, maybe there is a blog or so? My other solution would be to check with a developer internally.

Thanks, Adis
Verified answer

Alireza Eshaghzadeh 13,685 Super User 2025 Season 1 on at

Like (1)

Report

Sum of the invoice lines <> total for a project invoice proposal

Hi Freud,

This can be a solution to use the same mapping for totals that it show the sum of the total field while you should just take this into consideration that if it doesn't indicate invoice total in D365FO, you need to use invoice total as the main reference or add a new feild as Round-Off to indicate diff between D365FO invoice total and the calculated total.
Freud 27 on at

Like (0)

Report

Sum of the invoice lines <> total for a project invoice proposal

Hi Raj,

how do you change the way of calculation of Invoice amount?

Thank you.
Raj Borad 1,132 on at

Like (0)

Report

Sum of the invoice lines <> total for a project invoice proposal

Hi,

Usually, 4 decimal rounds for the amount is not suggestable.

You can change the way of calculation of Invoice amount.
Adis 4,167 Super User 2025 Season 1 on at

Like (0)

Report

Sum of the invoice lines <> total for a project invoice proposal

Hey,

I have the same scenario, however, I wouldnt say its an issue at all. D365FO rounds with more than 2 decimals (I think 6 actually), however, you always just see 2.

So, in your proposal, the total amount should be 2 318,70. The point is, if you send it to the customer, he will most likely calculate 35,40 x 65,5 and wonder why the invoice says 2318,72 instead of his result of 2318,72.

In my opinion, nothing should be changed as the result is correct, how the customer calculates is tempting, but still wrong.

Our case is even worse, as on the invoice, we group by hour rate, means on our invoice you would just see 65,5 x 35,40 without knowing that the 35,40 consists of 4 lines. We do send an hourlist, where the customer can check the exact lines though.

Kind regards, Adis