ERPNext.com Frappe Cloud Support Partners Foundation Frappe School

Multi Currency for single Customer/Supplier

Hello
I want to bill a single customer/supplier in two different currencies but getting error, Is this possible to use multi-currency for single customer/supplier? if not what is the solution

Assuming you have setup your base currency, you only need to enable the other currencies under currency list. Upon creating invoice for a customer/supplier, you can choose the required currency on the transaction. The system will require a conversion rate if you’d not setup exchange rates.

This is not accurate

You cannot bill a customer/supplier in a currency different from the base currency or the currency of the customer/supplier.

For example if your company base currency is USD and the customer/supplier currency is GBP, you can only transact with this customer/supplier in either USD or GBP. You cannot raise an invoice in a third currency.

This is the way ERPNext is configured for now

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.

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

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

1 Like

@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.

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

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.

Hello,

is it working now maybe?

anyone?

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.

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.

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

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

1 Like