Historical Rate
Returns the historical currency conversion rate for the selected parameters.
Parameter | Description |
---|---|
To Currency | The currency to convert to. |
Period Name | The period name as 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. |
Segments | Enter the segment value here. You must enter it as a text value including any leading zeros e.g. enter segment value “10” as “0010” if this segment is configured as four characters with leading zeros in Oracle. A Historical Rate is for a specific account combination, so a value must be entered on all segments, otherwise an Error(SegmentX) message will be returned, with X identifying which segment is invalid. |
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_Historical_Rate(“GBP”,”Jan-02″,”01″,”000″,”1210″,”000″)