In the accounts receivable report. A invoice issued in GBP. The balance in dollars is showing the same amount as GBP. Any solution for this?

Hi rui1

We would be grateful if you can provide us with a screen shot of the invoice and a screen shot of the accounts receivable report, you can customise > filter the report for this specific customer.

Hi John C,

Here's one example from AR report received by e-mail.

Check Invoice nr 119394, fourth line from bottom. 

Filtering by customer USD and GBP are the same

So this could be a customer setup that is wrong? 

Hey rui1, 

Please confirm the settings of the customer invoiced invoice no. 119394  by going to Sales > Customers > Click into customer > Edit > Payment and Billing and view the currency showing under 'This customer pays me with'.

Thanks

For that customer it does say

" this customer pays me with

GBP British Pound Sterling".

We have one Customer for each currency (One for USD and other for GBP)

This invoice is in GBP and is listed in the customer for GBP invoices which  is setup as GBP for payments.

Hi rui1

If you have a home currency of GBP and you have set up a customer that pays in GBP any invoices will show as they are in the report you are running, the open balance and the open foreign balance will show the same. If this in an error on your behalf and the customer should pay you in USD you will have to make that customer inactive and re-create the customer pays you in USD.

I'm not sure if I understood.

So you're saying that the balance will show me the values in GBP.  But the Foreign Currency  column will be a mix of GBP and USD.

So if I need the AR Foreign balance in USD cannot use your report, because i'm having clients that use GBP currency as payment, is this correct? 

Can you please advise a solution?

Glad to have you back, @rui1,

For accounts set up for Multicurrency, reports will always reflect the home currency regardless of was used on the transactions.

This way it's easier to track how much income is generated from foreign customers using the default medium of exchange. If you want to view a more detailed report showing separate a Debtor accounts for GBP and USD customers, open a Balance Sheets report.

Here's how:

1. Go to the Reports menu and select Balance Sheet.
   
2. Update the Report period and click Run report.
3. On the Debtors section, you'll see a separate line for GBP and USD. Drill-down the report to review each sale.
   

To know more about this feature, please check out these resources:

About Multicurrency.

How Multicurrency works?

If you have other questions or need further clarification, please let me know in the comment. I'll be more than happy to help whenever you need one! Have a good one!