SageForum for UK versions of Sage 50- Help and support.

I'm trying to show the exchange rates for Euros and Canadian Dollars on customer invoices.

There is an option to put the Euro exchange rate on but when I preview the report the rate is way out; around 6.61 instead of 1.347344. How do I change this? Can it be set so the report picks up the correct exchange rate each time?

And how do I put an exchange rate on for currencies other than the Euro?

Thanks,

Jay

Use the Field INVOICE.FOREIGN_RATE

not INVOICE.EURO_RATE

and you are sorted.

Tried this and it still doesn't seem to be picking up the correct exchange rate

Also, I want to show the sterling amount on an invoice with Canadian Dollars. Any idea how I do this?

Thanks,
Jay

The sterling amount is INVOICE.INVOICE_GROSS

What exchange rate is it showing and what should it be?

If it that the exchange rate is reversed GBP to EUR rather than EUR to GBP of vice versa you can use the expression 1/INVOICE.FOREIGN_RATE to reverse it

I've sorted it now. Thanks.

Do you know what the expression is to show the exchange rate to more than 2 decimal places?

Just change the properties of the expression to the number of DP you want, Expressions are calculated to lots.