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

I have the same question (0)

All responses (5)

Answers (1)

Adis 6,064 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Raj Borad 1,428 on at

Like (0)

Report

Hi,

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

You can change the way of calculation of Invoice amount.

Was this reply helpful? Yes No
Freud 27 on at

Like (0)

Report

Hi Raj,

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

Thank you.

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Adis 6,064 Super User 2025 Season 2 on at

Like (1)

Report

@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

Was this reply helpful? Yes No