SI.EXPANDTAXDETAILSRANGE

Overview

The SI.EXPANDTAXDETAILSRANGE function returns the list of Detail ID field values from the Tax details form in Sage Intacct.

Syntax

CODE

=SI.EXPANDTAXDETAILSRANGE(ConnectionName, TaxSolutionID, Range, IncludeInactive)

Arguments

The SI. EXPANDTAXDETAILSRANGE function uses the following arguments:

Argument	Required/ Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`TaxSolutionID`	Optional	The Tax Solution ID value to be considered in retrieving the results. If left empty value, all Tax Solutions are used.
`Range`	Optional	A filter of one or more Detail IDs to include/exclude from the results. See Filtering Techniques for Velixo Functions.
`IncludeInactive`	Optional	`TRUE` (default) or `FALSE` Determines whether or not Details IDs which are marked as inactive within Sage Intacct are included in the results This argument is available in version 2023.8.45 and higher

Example

Assuming the following configuration within Sage Intacct:

Example 1

CODE

=SI.EXPANDTAXDETAILSRANGE("Sage")

Description
Returns the alphabetized list of all Detail ID values defined in Sage Intacct:

Result

Example 2

CODE

=SI.EXPANDTAXDETAILSRANGE("Sage",,,FALSE)

Description
Returns an alphabetized list of all active Tax Detail IDs defined in Sage Intacct:

Result

The inactive Tax Detail ID "1C Wine..." is not included in the results

Example 3

CODE

=SI.EXPANDTAXDETAILSRANGE("Sage", "United Kingdom - VAT", "UK?")

Description
Returns an alphabetized list of those Tax Detail IDs (of the United Kingdom - VAT tax solution) which begin with the letters "UK".

Result