Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

TaxFX

Use this command to perform the tax foreign exchange calculation. The TaxFX command replaces the TaxFX_Calc procedure and greatly improves performance.

The following attributes are part of the tax foreign exchange calculation:

  • AZTAXFXOVERRIDE
  • ZGPNATIVECURRENCY
  • AZTAXCTAELEMENT
  • AZTAXCTASOURCEELEMENT
  • ZFXSOURCECURRENCIES
  • ZFXTRANSLATIONS

For more information on setting attributes for Longview Tax, see the Longview Tax Administrator’s Guide.

Syntax:

Calculate TAXFX Currencies ctaElements SourceDataArea RateSourceDataArea RateMethodDataArea RateOverrideDataArea

where:

  • Currencies is a range variable, consisting of a list of target currency symbols.
  • ctaElements is a range variable, consisting of a list of cumulative translation adjustment (CTA) element symbols.
  • SourceDataArea is the name of the DataArea containing the source data for the calculation.
  • RateSourceDataArea is the name of the DataArea containing the rate source data.
  • RateMethodDataArea is the name of the DataArea containing the rate method data.
  • RateOverrideDataArea is the name of the DataArea containing the rate override data.

The following code is an example of how to set up the range variables for translationCurrencies and ctaElements

Example:

Create variable currencies as Range

Create variable translationCurrencies as Range

Create variable elements as Range

Create variable ctaElements as Range

Set variable currencies = createlist("Symbols", "DATABASE", "CURRENCY", "CURRENCIES###")

Set variable translationCurrencies = ""

Create variable translation as String

For Each currency in currencies

Set variable translation = [[ SYMBOL, ZFXTranslations, $currency$ ]]

If "$translation$" NE ""

Set variable translationCurrencies = $translationCurrencies$ + $currency$

End If

Next

Set variable elements = createlist("Symbols", "DATABASE", "ELEMENTS", "TRNELE###")

Set variable ctaElements = ""

Create variable cta as String

For Each element in elements

Set variable cta = [[ SYMBOL, AZTaxCTAElement, $element$ ]]

If "$cta$" EQ "TRUE"

Set variable ctaElements = $ctaElements$ + $element$

End If

Next

Note: The range variable lists can also be filtered using the FilterList function. For example, Set Variable rCTAAccts = FilterList( rElements, "[[Symbol,AZTaxCTAElement,THIS]] == 'TRUE'" ).

Syntax example:

Calculate TAXFX translationCurrencies ctaElements daSource daRateSource daRateMethod daRateOverride

See also
Published:

TaxFX

Use this command to perform the tax foreign exchange calculation. The TaxFX command replaces the TaxFX_Calc procedure and greatly improves performance.

The following attributes are part of the tax foreign exchange calculation:

  • AZTAXFXOVERRIDE
  • ZGPNATIVECURRENCY
  • AZTAXCTAELEMENT
  • AZTAXCTASOURCEELEMENT
  • ZFXSOURCECURRENCIES
  • ZFXTRANSLATIONS

For more information on setting attributes for Longview Tax, see the Longview Tax Administrator’s Guide.

Syntax:

Calculate TAXFX Currencies ctaElements SourceDataArea RateSourceDataArea RateMethodDataArea RateOverrideDataArea

where:

  • Currencies is a range variable, consisting of a list of target currency symbols.
  • ctaElements is a range variable, consisting of a list of cumulative translation adjustment (CTA) element symbols.
  • SourceDataArea is the name of the DataArea containing the source data for the calculation.
  • RateSourceDataArea is the name of the DataArea containing the rate source data.
  • RateMethodDataArea is the name of the DataArea containing the rate method data.
  • RateOverrideDataArea is the name of the DataArea containing the rate override data.

The following code is an example of how to set up the range variables for translationCurrencies and ctaElements

Example:

Create variable currencies as Range

Create variable translationCurrencies as Range

Create variable elements as Range

Create variable ctaElements as Range

Set variable currencies = createlist("Symbols", "DATABASE", "CURRENCY", "CURRENCIES###")

Set variable translationCurrencies = ""

Create variable translation as String

For Each currency in currencies

Set variable translation = [[ SYMBOL, ZFXTranslations, $currency$ ]]

If "$translation$" NE ""

Set variable translationCurrencies = $translationCurrencies$ + $currency$

End If

Next

Set variable elements = createlist("Symbols", "DATABASE", "ELEMENTS", "TRNELE###")

Set variable ctaElements = ""

Create variable cta as String

For Each element in elements

Set variable cta = [[ SYMBOL, AZTaxCTAElement, $element$ ]]

If "$cta$" EQ "TRUE"

Set variable ctaElements = $ctaElements$ + $element$

End If

Next

Note: The range variable lists can also be filtered using the FilterList function. For example, Set Variable rCTAAccts = FilterList( rElements, "[[Symbol,AZTaxCTAElement,THIS]] == 'TRUE'" ).

Syntax example:

Calculate TAXFX translationCurrencies ctaElements daSource daRateSource daRateMethod daRateOverride

See also
For an optimal Community experience, Please view on Desktop