frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
21.87k stars 7.33k forks source link

Multi Currency Invoice Total calculation has an incorrect decimal value #29200

Closed tantoinet closed 2 years ago

tantoinet commented 2 years ago

Information about bug

Company's default accounts are GBP, with floating precision of 4, and currency precision 2. An invoice of a total 1560 EUR, with exchange rate set to 0.858762000, the calculated GBP total amount is 1339.65. But using the Microsoft Windows calculator, the value shown is:

Where did ERPNext 1339.65 value come from? this looks like a bug

If the full exchange rate is used, the expected value to see in ERPNext is 1339.67. If the system config of 4 decimals precision is used to round the exchange rate to 0.8588, the expected value is 1,339.73

Module

selling

Version

ERPNext: v12.28.0 (version-12) + 13.18 Frappe Framework: v12.25.0 (version-12)

Installation method

docker

Relevant log output / Stack trace / Full Error Message.

No response

stale[bot] commented 2 years ago

This issue has been automatically marked as inactive because it has not had recent activity and it wasn't validated by maintainer team. It will be closed within a week if no further activity occurs.