Period End Rate

Returns the period end rate for the selected currency, actual flag, period and Ledger.

Parameter	Description
To Currency	The currency to convert to.
Actual Flag	A – Actual, B – Budget, E – Encumbrance.
Period Name	The period names configured in Oracle. This parameter must be entered in exactly the same format as the period names in Oracle. For example if your period names are configured as follows “Jan-07” in Oracle and you enter “Jan-2007” or “January-07” or “jan-07” for this parameter, GL Wand will not return any data, and will instead return an Error (Period) message.
Ledger	Optionally enter a Ledger Id to bind the formula to a specific Ledger. If this parameter is omitted, the Ledger currently selected in the Ledger dropdown list will be used.

Example: =GLW_Period_End_Rate(“GBP”,”A”,”Jan-02″)