frappe / erpnext

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

Can’t reconcile multi-currency invoice with multi-currency payment #15174

Open dboobisMF opened 5 years ago

dboobisMF commented 5 years ago

We are unable to use the payment reconciliation tool to match a multi-currency invoice with a multi-currency payment where the company currency balances do not match.

Ideally there would a the option to create a difference entry on this page (or the system would do so automatically using the default exchange account).

Similarly when trying to apply advance payments to an invoice, if the company currency balance does not match the same error is presented.

Discussion can be found here

nmshameem commented 5 years ago

I am also facing somewhat same issue . While generating general ledger report for accounts other than base currency , it seems that the system reverse calculates the debit/credit amount from base currency with the latest exchange rate instead of historical exchange rates. The same issue is also there in payment allocation against invoices. Please see the attached screen shot currency issue-erpnext

federicocalvo commented 5 years ago

Hi @jaichavan , these issues have been going on for quite some time.

They are very important issue that directly there is no alternative exit, so more than to leave to validate it should be directed to the person of Frappe in charge of the accountancy.

As you can get that label because 3 users are confirming the problem, and is a serious problem that we do not understand as there is no impact on discuss.

frederictobien commented 2 years ago

I face the same issue with my payment reconcilation I am using V13.18.0 image