TransPeriodic
Translates a currency using the periodic method. This function can be used in Translation rules.
Syntax
HS.TransPeriodic("DestPOV","SourcePOV","Rate1","Rate2")
Table 11-52 Syntax for TransPeriodic Function
Parameter | Description |
---|---|
DestPOV |
The destination point of view. The destination can be a combination of Account, Custom1-4, and ICP members. For each not specified dimension, the system writes to all valid members of the dimension. For each specified dimension, the system writes into the specified member only. |
SourcePOV |
The source point of view. The source can be a combination of dimensions. If the Account, Custom1, Custom 2, Custom 3, Custom 4, and ICP dimensions are not specified, the system uses the same member as the Destination member. If the Scenario, Year, Period, and Entity dimensions are not specified, the system uses the current members. If the Value is not specified, the system uses the EntityCurrTotal member. If the source is blank, the system uses the destination as the source. |
Rate1-2 |
The exchange rate. The exchange rate can be a constant, an exchange rate account, or a specific cell. Rate accounts are input for entity and for None entity. For information about the default translation process, see Default Translation. |
Return Value
None
Example
This example uses the exchange rate in the Rate1 account to translate the Sales account using the periodic method:
HS.TransPeriodic("A#Sales", "A#LastYearSales", "A#Rate1", "")