Multi Currency exchange rate Issue in Accounting

pavan · January 29, 2019, 6:33am

Hi , i have started using multi currency accounting recently. I have generated few journal entries with multi currency accounting, after i submit the voucher the balance sheet figures of USD account are not showing same as in the voucher, i have multi checked the journal entry, the figures in journal entry are correct but the balance sheets numbers are different. Can anyone know how to solve this problem ?

rk_root · February 12, 2019, 12:08pm

Same problem for us, USD account ledger is fetching the current exchange rate for all previous entries and showing wrong balance in reports.

pavan · February 12, 2019, 1:31pm

i have contacted the support team and it seems they are also unable to help me out for now. How did you solve this with your accounts ?

rk_root · February 12, 2019, 1:46pm

It is fixed now, yet to merge in master.

github.com/frappe/erpnext

fix: show values in account/party currency based in actual entry, no conversion

frappe:hotfix ← nabinhait:general-ledger-fix

opened 11:14AM - 12 Feb 19 UTC

nabinhait

+2 -2

Previously, the system was always converting values from base currency to accoun…t currency if it's a balance sheet account. But it creates problem for sending "Statement of Accounts" to customer / supplier. In this case, it should be based on actual value in invoice ( based on debit_in_account_currency) and no conversions.

erpwork · September 22, 2019, 1:10am

How to fix this issue at ERPNEXT V11+. Because I have this problem at v11.1.62 version?

Abhinav_Jain · November 18, 2020, 9:47am

We are on version 12 and still facing the same issue. Could you please update whether it was fixed for you?

ERPNext: v12.13.0 (version-12)
Frappe Framework: v12.11.0 (version-12)

Thanks