Skip to main content

Foreign Currency

  • FOREIGNCURRENCY(column,parm)
columnA column number OR column name in the SQL query results which contain a monetary value and where the result will be
parm 1A valid currency code in single quotes ie: 'USD' already setup in roomMaster

The ForeignCurrency extension will convert the folio balance to EURO using the roomMaster Foreign Currency figures.

SELECT LASTNAME,FIRSTNAME,NUMBER,BALANCE FROM FOLIODT

  FOREIGNCURRENCY(4,'AUD')

 SETREPORTFOOTER 'Balances shown in AUD'

This example shows the balances in both the local and the Euro currencies.

SELECT LASTNAME,FIRSTNAME,NUMBER,BALANCE as 'USD Amount', BALANCE as 'AUD Amount' FROM FOLIODT

  FOREIGNCURRENCY(5,'AUD')