Multi Currency: Debit to Different Currency Accounts

Dear Community,

I did the following test cases in order, on v8.

Case 1
Company Currency | Customer Billing Currency | Invoice | Receivable Account Currency
USD | USD | USD | Debtor - USD

Case 2
Company Currency | Customer Billing Currency | Invoice | Receivable Account Currency
USD | USD | CNY | Debtor - CNY

I didn’t set any receivable account in Customer Master.

I was denied submission for Case 2,
Error: Accounting Entry for Customer: USD Customer can only be made in currency: USD

If I set the Debtor Account to be the same as Case 1, then I am able to submit.

Shouldn’t the system be able to debit to different receivable currency accounts?

Thanks!

For a customer, if posting already exist in USD, then same should be followed throughout. Or you should consider creating new Customer and set required Receivable Account (CNY) in the Customer master.

Hi @umair,

I understand the workaround but I am unsure if creating a new customer is feasible if there are many customers.

Just want to ask for your(and the community) opinion.

If we were to make changes to the core code to suit the following requirement

  • 1 customer to different billing currency and as such, debtors accounts.
  • AR / AP reports which consolidate 1 customer various debtor accounts

Do you think there are any concerns with other DocType such as Journal Entries, Payment Entry etc.?

If we were to put on a bounty for this, how much is the expected cost? Bearing in mind, the suppliers would have to have the same concept too.

Thanks.

Well this have been around for a long while,

@mulyadi-agtechsg What have you achieved with the situation?