Try ERPNext Buy Support Partners Foundation

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.