Return invoice wrong total

[perotom]

Information about bug

I created a normal invoice:

And then tried to create a return invoice but the total amount is different:

Looks like the difference comes from this one green marked item. Maybe rounding error?

Module

selling

Version

ERPNext: v15.20.3
Frappe Framework: v15.22.0

Installation method

easy-install

Relevant log output / Stack trace / Full Error Message.

No response

[Nihantra-Patel]

Everything is working fine. No problems were encountered in the latest version 15.

scrnli_06_06_2024_16-31-06.mp4

[perotom]

If you use quantity 1, it works but if you use for example quantity 10 with price 82.50€ and 15% discount, you will get a wrong total. This issue is still there.

[Nihantra-Patel]

Tested, worked properly.

scrnli_06_06_2024_17-21-03.mp4

[perotom]

Please use the price values I used. It is a rounding issue. The following is happening:
Item A: 82,50€ - 15% = 70,125€
On the sales invoice, it is rounded up:
70,125 = 70,13€ * 10 = 701,30€
and on the return invoice it is rounded down:
70,125 = 70,12€ * 10 = 701,20€
resulting in a wrong total value. Seems like the rounding mode is not consistent across sales and return invoices.

[Nihantra-Patel]

Please check with latest version and provide the video.

[perotom]

I changed the rounding mode from bankers to commercial and now it works. Thank you.