Skip to main content

Converting Pricing to Foreign Currency

How to use the Foreign Currency feature to show the Item Pricing in Reports to a foreign currency

A
Written by Ashok P
Updated over a month ago

You can use the Foreign Currency conversion feature in the Project Editor to convert all pricing in a report to a different currency. This allows you to generate reports for multiple currencies easily.

foreign currency button.jpg

This feature is only available when running reports from within the Project Editor.

1/ Click the Foreign Currency button in the Reports tab to open the Reports Foreign Currency Options form.

foreign currency form.jpg

2/ Use the dropdown menu to select a country (current format), then enter the exchange rate.

3/ If you click the Currency Converter link, a currency converter from Google Finance will launch in a browser.

check rates.jpg

4/ Click Yes to use the conversion rate from Google Finance.

When you generate reports, the pricing will be converted to the chosen currency with the relevant currency symbol.

File:SIX_Guide/008_Reports/003_Running_Reports/Foreign_Currency/report_results.jpg

This feature does not change the pricing for any of the Price Types in your catalog; it is solely for reporting.

The export to PDF function within the Report Viewer has a known issue in Active Reports 7 that will convert all numerals in the report to the alphabet of the chosen country.

Print the report in PDF format instead of using the export function to get around this. There are many free PDF printers available online.

Did this answer your question?