This function calculates the relative exchange rate between a parent and child, returning a value as a multiplier. The value will be calculated based on the TriangulationCurrency parameter passed to the function.
If the TriangulationCurrency parameter is a valid currency label, the cross rate will be based on this currency.
If the TriangulationCurrency parameter is blank ( " " ), the function first searches for a valid direct rate, and if none is found will then use Triangulation against the application currency.
The following tables show the methods of searching for the data and the order in which the search is made. The order is represented by a number in parentheses, for example (1). In each case, the search is made first in the child entity and, if no data is found, then from the “[None]” entity.
In the following table, either the currency of the child or of the parent is the same as the Triangulation currency, or if Triangulation is blank, the application currency.
In the following table, Triangulation has been specified and is not the same as either the child or parent currencies.
In the following table, Triangulation has not been specified and the application currency is different from both the child and parent currencies.