SI.EXPANDTAXDETAILSRANGE

Created by Damien Zwillinger, Modified on Mon, 20 Nov, 2023 at 6:16 PM by Harry Lewis

Applies to:

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

TABLE OF CONTENTS

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

Assuming the following configuration within Sage Intacct:

=SI.EXPANDTAXDETAILSRANGE("Sage")

Description

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

Result

=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)

=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