FRRATE Function

Learn more

Financial Reporter Functions

FR Menu Commands

This function returns the exchange rate, as a multiplier, for converting amounts from source to functional currency. If the exchange rate is defined as a divisor, Sage 300 provides its reciprocal.

Syntax

FRRATE(functional currency, source currency, rate type, rate date, option)

Arguments

Argument Description
functional currency Functional (home) currency code
source currency Source currency code
rate type Rate type code
rate date (Optional)

If the period end date is not specified, Financial Reporter will use:

  • The period end date defined in the report specification
  • The session date, if the report is not generated from a report specification

The date is specified as DATE(YYYY,MM,DD). Note that the DATE() spreadsheet function returns the serial number of the date.
option (Optional)

This argument is only required for handling exchange rates for euro-member currencies that use the Euro Conversion Rates table, such as francs or schillings.

Use one of the following parameters to choose which part of the currency exchange rate (from euro-member currency to non-euro-member currency) you want the function to provide:

  • RF returns the floating portion value of the exchange rate—the portion not fixed between the euro and non-euro-member currencies. RF returns a "1" if the currencies are euro-member, and the year is greater or equal to 1999.

  • RC returns the composite exchange rate—the effective rate between a non-euro currency and a euro-member currency. This is the default if no value is specified.

  • For non-euro currencies, RC will look up the rate in the Currency Rate table.
  • If the source and functional currencies are both euro-member currencies, RC will return the rate from the Euro Conversion Rates table.
  • If the functional currency is the euro, and the source is not a euro-member currency, RC will return the effective exchange rate between the two currencies.

Examples

Some of the following example use the spreadsheet function DATEVALUE. This function converts a textual representation of a date (such as the date string returned by FRFISCA) to a serial number, which FRRATE accepts.

Statement

Return Value

=FRRATE("USD","CAD","AV")

.75

=FRRATE("USD","CAD","SP",
DATE(2009,10,31))

.75

=FRRATE("USD","CAD","SP",
DATEVALUE(FRFISCAL("Start")))

.75

=FRRATE("ATS","EUR","AV", DATEVALUE(FRFISCAL("Start")),"RC")

13.760300

=FRRATE("USD","ATS","AV", DATEVALUE(FRFISCAL("Start")),"RF")

Note: This function returns the floating exchange component between the Austrian schilling and the US dollar. In this case, this is the euro to US dollar exchange rate.

.88274