SI.EXPANDTAXDETAILSRANGE
Applies to:
- Velixo NX
- Sage Intacct
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)
The SI. EXPANDTAXDETAILSRANGE function uses the following parameters:
Parameter | Required/ Optional | Description |
Connection Name | 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 blank, 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 parameter is available in version 2023.8.45 and higher |
Example
Assuming the following configuration within Sage Intacct:
Example 1
=SI.EXPANDTAXDETAILSRANGE("Sage")Description
Returns the alphabetized list of all Detail ID values defined in Sage Intacct:
Result
Example 2
=SI.EXPANDTAXDETAILSRANGE("Sage",,,FALSE)Description
Returns and alphabetized list of all active Tax Detail IDs defined in Sage Intacct:
Result
(note that 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
