Multicurrency Journal Entry: Debit must equal Credit

lasalesi · May 27, 2019, 6:27am

Dear colleagues,

I have a strange sympton on an ERPNext: v10.1.13:

Despite the fact that the system shows total debit and total credit to be equal, the error message pops up. What is wrong? Thanks!

lasalesi · May 27, 2019, 8:44am

Update on this: the error message is missleading. The root cause was that the EUR amount was entered, but the currency exchange rate had changed in the meantime. The debtors account was then checked against the open amount, which at that point had a different company currency amount.

Entering the “old” valuation (same EUR, company currency from SINV) has resolved the issue.

Harry · February 22, 2024, 8:57am

I encounter the same issue booking entries from last year with ERPN 15. How exactly did you solve this case?

Montego-arch · February 22, 2024, 4:57pm

Your total debit must be equal to total credit, your case shows there is a difference of 427.27 difference, it won’t save if they are not the same

Harry · February 22, 2024, 5:25pm

Yeah right. Why is the difference there and how can it be resolved? Date of posting is checked. The bank statement (below) is pretty clear and i somehow have to get it into the system. It reads:

credit CHF 44.361,63 from main account
debit CHF 211,93 to transaction fee
debit EUR 46.188,97 to customer account

The math is right:

(44361,63 CHF - 211,93 CHF) * 1,04619 = 46188,97 EUR

Montego-arch · February 23, 2024, 8:06am

your credit is not equal to your debit according to your screenshot

Harry · February 24, 2024, 9:29am

Yes, ERPNext is calculating a wrong Debit.

Debit = Fr 44.788,90
Credt = Fr 44.361,63

Actual Debit is

Debit = Fr 44.361,63
Credt = Fr 44.361,63

How can this be solved?

Harry · February 25, 2024, 4:57pm

It gets even wilder. Every time I recreate the case it calculates a different difference. What kind of gimmick is this? Sadly for the last days I was unable to find a solution.

pronext · May 2, 2024, 8:09am

ERROR STILL IS THERE, the payroll entries are not working correctly because of this also.

ERPNext: v15.11.0

ERPNext Germany: v15.1.1

Frappe Framework: v15.12.0

Frappe HR: v15.10.0

Payments: v0.0.1

Harry · May 21, 2024, 6:05pm

By clicking the gear icon on the top right we can include the exchange rate. But it is not working well enough. The accuracy is too low and only the exchange rate of the target account can be modified.

Peek 2024-05-21 19-53

pronext · September 18, 2024, 9:48am

STILL THE SAME PROBLEM ON VERSIONS:

ERPNext: v15.35.1
Frappe Framework: v15.40.6
Frappe HR: v15.28.3
Payments: v0.0.1

unbelievable that something like this cannot be fixed by simply integrating a Rouding Differences account in the process by default.

adam26d · November 21, 2024, 11:23am

There’s an unresolved but closed issue for this problem.

A workaround is to use single currency precision like so:

I’ve reopened the issue and suggested a solution to round-up amounts less than 0.01. Please upvote the issue on github linked below:

github.com/frappe/erpnext

Currency Precision Issue in Journal Entry giving: Total Debit must be equal to Total Credit. The difference is -0.0000001

opened 12:07PM - 21 Nov 24 UTC

dawoodjee

bug

### Information about bug **This issue has been tracked for 3 years now** - On… the forum [here](https://discuss.frappe.io/t/total-debit-must-be-equal-to-total-credit-the-difference-is-0-009999999999990905/95779) and [here](https://discuss.frappe.io/t/multicurrency-journal-entry-debit-must-equal-credit/49301) in Version-15 AFAIK - There's also this [related github issue which was closed without resolution](https://github.com/frappe/erpnext/issues/36698) in Version-14 ### **Expected behaviour:** Journal Entry should be able to ignore the debit credit difference if its under the standard or set currency precision. ### **Actual Behaviour** Getting Exception Message: Total Debit must be equal to Total Credit. The difference is -0.000000XXXX ### **Workaround** The only workaround is reducing **Currency Precision** to 1 decimal place in **System Settings** ### **Suggested Solution** I believe we can resolve the issue by ignoring small discrepancies less than 0.01 by rounding-up one of the amounts so that there's no difference We can change ``` def set_total_debit_credit(self): self.total_debit, self.total_credit, self.difference = 0, 0, 0 for d in self.get("accounts"): if d.debit and d.credit: frappe.throw(_("You cannot credit and debit same account at the same time")) self.total_debit = flt(self.total_debit) + flt(d.debit, d.precision("debit")) self.total_credit = flt(self.total_credit) + flt(d.credit, d.precision("credit")) self.difference = flt(self.total_debit, self.precision("total_debit")) - flt( self.total_credit, self.precision("total_credit") ) ``` To ``` def set_total_debit_credit(self): self.total_debit, self.total_credit, self.difference = 0, 0, 0 # Calculate total debit and credit for d in self.get("accounts"): if d.debit and d.credit: frappe.throw(_("You cannot credit and debit the same account at the same time")) self.total_debit += flt(d.debit, d.precision("debit")) self.total_credit += flt(d.credit, d.precision("credit")) # Compute the difference with rounding self.difference = flt( flt(self.total_debit, self.precision("total_debit")) - flt(self.total_credit, self.precision("total_credit")), self.precision("difference") ) # Adjust for small discrepancies if abs(self.difference) <= 0.01: if self.total_debit > self.total_credit: self.total_credit = flt(self.total_debit, self.precision("total_credit")) else: self.total_debit = flt(self.total_credit, self.precision("total_debit")) self.difference = 0 # Ensure no discrepancy remains ``` ### Module accounts ### Version ERPNext: v15.39.3 (version-15) Frappe Framework: v15.45.1 (version-15) ### Installation method None ### Relevant log output / Stack trace / Full Error Message. ```shell File "apps/frappe/frappe/model/document.py", line 291, in insert 11:12:05 web.1 | self.run_before_save_methods() 11:12:05 web.1 | File "apps/frappe/frappe/model/document.py", line 1091, in run_before_save_methods 11:12:05 web.1 | self.run_method("validate") 11:12:05 web.1 | File "apps/frappe/frappe/model/document.py", line 962, in run_method 11:12:05 web.1 | out = Document.hook(fn)(self, *args, **kwargs) 11:12:05 web.1 | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 11:12:05 web.1 | File "apps/frappe/frappe/model/document.py", line 1322, in composer 11:12:05 web.1 | return composed(self, method, *args, **kwargs) 11:12:05 web.1 | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 11:12:05 web.1 | File "apps/frappe/frappe/model/document.py", line 1304, in runner 11:12:05 web.1 | add_to_return_value(self, fn(self, *args, **kwargs)) 11:12:05 web.1 | ^^^^^^^^^^^^^^^^^^^^^^^^^ 11:12:05 web.1 | File "apps/frappe/frappe/model/document.py", line 959, in fn 11:12:05 web.1 | return method_object(*args, **kwargs) 11:12:05 web.1 | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 11:12:05 web.1 | File "apps/erpnext/erpnext/accounts/doctype/journal_entry/journal_entry.py", line 132, in validate 11:12:05 web.1 | self.validate_total_debit_and_credit() 11:12:05 web.1 | File "apps/erpnext/erpnext/accounts/doctype/journal_entry/journal_entry.py", line 868, in validate_total_debit_and_credit 11:12:05 web.1 | frappe.throw( 11:12:05 web.1 | File "apps/frappe/frappe/__init__.py", line 655, in throw 11:12:05 web.1 | msgprint( 11:12:05 web.1 | File "apps/frappe/frappe/__init__.py", line 620, in msgprint 11:12:05 web.1 | _raise_exception() 11:12:05 web.1 | File "apps/frappe/frappe/__init__.py", line 571, in _raise_exception 11:12:05 web.1 | raise exc 11:12:05 web.1 | frappe.exceptions.ValidationError: Total Debit must be equal to Total Credit. The difference is -0.0000001 ```