SI.EXPANDTAXDETAILSRANGE

Overview

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

Syntax

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

Arguments

The SI. EXPANDTAXDETAILSRANGE function uses the following arguments:

Argument	Required/ Optional	Description
`ConnectionName`	Optional	Provide one of the following values: Connection name as defined in Connection Manager. Velixo range expression defining a set of connection names. An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array. OR Omit the argument to return results for all compatible connections with default aggregation settings.
`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:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/o_zhJVt8vAo538y_Zy3roDbvBln22rQfgQ.png

Example 1

=SI.EXPANDTAXDETAILSRANGE(
    "Sage"
)

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

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/FQr4YtsSjtXhxJFJziVK9Sq8mAN0i8pPWw.png

Example 2

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

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

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/2W0D7hiZRBleZS-K3xc7YEVRsOomGjUDeA.png

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

Example 3

=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

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/BkeVBNW1UNuWMr1ifEyf6uHYPLK9Te5ipA.png