Multi Currency for single Customer/Supplier

chrismberi · July 12, 2020, 5:31pm

Not sure if you’ve tried it on V12 but yes you can bill in third, fourth or even firth currency. While you can raise invoices in different currencies, what ERPNext does is to convert into base currency for the ledger. If you’d like to keep track of payments in other currencies besides base, you can create an anccount in chart of accounts in the respective currency.

olamide_shodunke · July 12, 2020, 6:31pm

Am not sure you understand what the poster is asking

Let me explain

Your base currency is USD
You set up the supplier in GBP (with currency GBP and default payable account GBP)

You then try to invoice the customer in JPY

It will not work.
I have instances on v11 to v13 and this is not possible on any of the instances.

You please try it make sure default currency and default accounts payable is in a foreign currency and not the base currency

Regards

Muzzy · July 12, 2020, 7:57pm

Please don’t tag user directly. Leave your query and anyone with knowledge will reply.

Muzzy · July 12, 2020, 8:01pm

@olamide_shodunke it’s possible through JV and custom scripts. Have done in for my brokerage app where trade happens in different currencies and billed as well in these currencies. Ledger is in company base currency though. Currencies conversion needs to be up to date. It’s lot of work to achieve what the original poster is asking.

olamide_shodunke · July 12, 2020, 8:25pm

So in a nutshell, it is not possible out of the box.

mayar · July 13, 2020, 6:28am

I’m using V12
YES i can bill customer/supplier on third, fourth… currency, but my question is about single customer/supplier.
for example:
I billed customer A on AFN next time same customer purchased on USD when i try to bill him on USD I’m getting error:

Accounting Entry for Customer: TEST can only be made in currency: AFN.

I need to bill customer A on different currency rather than the currency i billed him last time.

johnwick · September 17, 2021, 11:48am

Hello,

is it working now maybe?

anyone?

elahe_tahmaseb · September 21, 2021, 6:28pm

I have same problem and I think there is no solution for that.
The issue is big enough to say ERPNEXT does not support multi-currency.

Ysedky · October 4, 2021, 12:46pm

I had this case and the simplest solution was to create two suppliers, say the supplier is XYZ so I created two suppliers “XYZ USD” and set his currency as USD , and “XYZ AED” and set his currency as “AED”. The Company default currency is in “AED” . The drawback of this workaround is that the system will treat them as two separate suppliers each having his own credit/debit and balance. You may need an intermediate account if you want to settle the balance in one currency.

mayar · October 6, 2021, 4:53am

This way the billing issue will be solve but it’s not a standard solution if we need to print or send the customer/supplier SOA because you will have two customer/supplier in your system instead of one

olamide_shodunke · October 6, 2021, 4:56am

In the General Ledger if you chose the two suplliers in the different currencies together, the system.will give you a combined statement. However it will be in your local currency

toceguera · August 1, 2022, 4:26am

It seems that people are mixing suppliers and customers up in this thread. The original poster noted “customer” and that is where we are experiencing issues as well.

We seem to be having the same sitatuation.
We sell online and sync our store with ERPnext.
This took some configuration but it works well 80% of the time.

Some basic info:
Our company base currency is THB
We sell in three different currencies
AUD , GBP, & USD.

USD has been online for 2 years
GPB has been online for 6 months
GPB has been online for 2 weeks

If a customer purchased a year ago they paid in USD
If that same customer comes back now and wants to purchase in GPB the error below is shown

erpnext.exceptions.InvalidCurrency: Accounting Entry for Customer: Returning Customer can only be made in currency: USD

Are you saying that the only way around this is to create a duplicate customer entry and history?

Thanks in advance!

Sanath_Udayawansa2 · November 5, 2022, 5:30am

Multi-currency for same customer is not possible. Even In V14.
So create duplicate customers and use different currencies is the only solution I see.

Any suggestions?

Axel_Gavilan · April 3, 2023, 9:38pm

I cannot belive that ERPNext doesnt support multi currency for a same customer… its ridiculous!
i had to comment this part of the code to be able to invoice with different currency to the same customer…

flexy2ky · June 21, 2023, 6:12pm

Was there any noticeable negative impact to you doing this in terms of accounting?

MrPilot · April 26, 2024, 3:35am

Yes, for some use cases it’s a pain in the neck! E.g. one of our suppliers receives payments in USD while billing in EUR, and our company currency is CHF. I let you guess what that implies to account correctly on our side without this multi-currency functionality.

SureshParvathareddy · October 28, 2024, 9:25am

@Axel_Gavilan , hi in which document did you find this validation code?

josog · January 9, 2025, 9:03pm

Any new?

i have the same problem…
a client in MXN i need create a quotation in USD so, i can’t:
Accounting Entry for Customer: [client] can only be made in currency: MXN

JeansReal · February 28, 2025, 1:41am

Exact same problem here!

zander_leach · April 30, 2025, 5:08pm

I’m also experiencing this same issue and am now considering doing the same, changing the logic here:-

github.com

frappe/erpnext/blob/13a84e7f82e8e0a2c4cfd1f2c150c1e4a72a3cf8/erpnext/controllers/accounts_controller.py#L2244


      
          			party_type, party = self.get_party()
          			if party_type and party:
          				party_account_currency = get_party_account_currency(party_type, party, self.company)
          
          				if (
          					party_account_currency
          					and party_account_currency != self.company_currency
          					and self.currency != party_account_currency
          				):
          					frappe.throw(
          						_("Accounting Entry for {0}: {1} can only be made in currency: {2}").format(
          							party_type, party, party_account_currency
          						),
          						InvalidCurrency,
          					)
          
          				# Note: not validating with gle account because we don't have the account
          				# at quotation / sales order level and we shouldn't stop someone
          				# from creating a sales invoice if sales order is already created
          
          	def validate_party_account_currency(self):

@Axel_Gavilan did you notice any issues after commenting out that code?

I’m wondering about adding an additional conditional to that statement, so that it checks if multi-currency accounting is enabled in the Accounts Settings. If enabled, then don’t throw the error.

I was also considering on just creating a new customer account, but I also don’t like the thought that the GL history for that customer will then be incomplete…

I’ll work on a PR over the next day or two and will link to it from here…