Skip to main content
rui1
Oct 29, 2019 9:39 AM UTC
Question

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?

Original commenter did not share additional details

8 replies

payment after leaving
Oct 29, 2019 10:48 AM UTC

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.

rui1Author
Oct 29, 2019 11:39 AM UTC

Hi John C,

 

DateTransaction TypeNo.Due DateAmountOpen BalanceForeign Open BalanceCurrency
23/11/2018Invoice11856423/12/20189294438,61566,31USD
30/01/2019Invoice11890401/03/2019988,75988,751250USD
10/05/2019Invoice11953310/05/2019407,67407,67532USD
15/04/2019Invoice11934215/05/2019151,66151,66200USD
24/04/2019Invoice11939524/05/20192426,562426,563200USD
29/04/2019Invoice11939429/05/20191607,51607,51607,5GBP
08/05/2019Invoice11949607/06/20193065,23065,24000USD
12/06/2019Invoice11969312/06/20191046,7571,190USD
14/06/2019Invoice11970414/06/2019145,7623,730USD

 

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

07/06/2019Invoice119679 07/07/2019252,50252,50252,50GBP
16/10/2019Credit NoteCR120426 16/10/2019-252,50-252,50-252,50GBP
16/10/2019Invoice120427 15/11/2019204,94204,94255,82USD

 

So this could be a customer setup that is wrong? 

 

GeorgiaC
Oct 29, 2019 12:30 PM UTC

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

Anonymous
Oct 29, 2019 7:57 PM UTC
Likely the exchange rate for this invoices was accidentally set to 1.00.
Edit the invoice and correct it.
Terms & ConditionsAccessibility statement