Bug at Report when using multi currency

santhida · March 11, 2020, 3:32pm

Company Currency is MMK

Supplier Currency is SGD

Purchase Invoice

Account Payable Report, added Total Columns
Amount shown correctly but Currency was not shown correctly, it shown based currency

jaichavan · March 11, 2020, 6:26pm

Not able to replicate this, which version of 12 again?

santhida · March 12, 2020, 3:36am

Thanks
I’m using ERPNext: v12.5.2 (version-12) (self hosted on vps)

santhida · March 12, 2020, 11:04am

at ERPNext Cloud same issue happening

can someone help, thanks?
Purchase Invoice

Account Payable Report

olamide_shodunke · March 12, 2020, 11:29am

How was the Supplier created ?

Did you choose the right Currency AND the right Accounts payable ?

Most users forget to choose the right Accounts payable for the currency

Regards

santhida · March 12, 2020, 12:29pm

Billing Currency at Supplier is SGD

exchange rate

olamide_shodunke · March 12, 2020, 1:49pm

Like I said please check the Accounts payable ledger you chose for the Supplier

By default the system will choose the default local currency creditors account if nothing is chosen.

You have to create a foreign currency creditors account for each currency you transact in. You should then attach this to the foreign currency supplier when it is created and before a transaction is done on that Suppliers account.

Hope this solves the issue