In my country, the official currency does not use decimal values. In ERPNext, it is possible to configure this by changing the system settings and currency format so that currency fields are displayed without decimal places.
After doing this, the system correctly hides decimal values in most currency fields. However, the underlying GL Entry records still contain decimal values. This creates a serious issue in accounting reports such as the General Ledger, because the displayed debit and credit amounts may not add up correctly after the decimals are hidden.
For example, within the same voucher, or even in the overall report totals, the numbers shown to the user can appear unbalanced because the report displays rounded values while the actual GL Entry values still include decimals.
This causes a major problem for legal and statutory reporting, because we are required to submit exact whole-number accounting figures. The displayed report values cannot be reliably used when the visible debit and credit totals do not match.
I would like to understand:
-
Is this the expected behavior in ERPNext?
-
Why are GL Entries still stored with decimal values when the currency has no decimal precision?
-
Is there a recommended or reliable way to make ERPNext fully support currencies without decimal values?
-
Should GL Entry amounts be rounded according to the currency precision before being saved, or should reports handle this differently?
This seems like an important issue for countries where the official currency does not use decimals. I am surprised this has not been reported more often, so I would appreciate guidance from the community or maintainers on the correct way to handle this.