Velixo NX Release notes 2023 Archive

SI.EXPANDTAXSOLUTIONRANGE

Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 9:27 PM by Damien Zwillinger

Applies to:

Velixo NX
Sage Intacct

The SI.EXPANDTAXSOLUTIONRANGE function returns the list of Tax solution name field values from the Tax solutions form (Taxes > Setup tab > Tax solutions) in Sage Intacct, which have a defined Tax engine of "VAT or GST".

TABLE OF CONTENTS

Syntax
Examples

Syntax

SI.EXPANDTAXSOLUTIONRANGE(Connection, Range, Status)

The SI. EXPANDTAXSOLUTIONRANGE function uses the following parameters:

Parameter	Required/Optional	Description
Connection	Required	The name of the connection as configured in the Connection Manager
Range	Optional	The range of tax solution names to include in the results. See our article on including multiple parameter values
Status	Optional	Determines whether or not Tax Solution Names which are marked as inactive within Sage Intacct are included in the results True (default) - Include Tax Solutions Names which are set to Inactive False - Do not include Tax Solution Names which are set to Inactive This parameter is available in version 2023.8.45 and higher

Examples

Assuming the following configuration within Sage Intacct:

Example 1

=SI.EXPANDTAXSOLUTIONRANGE("Sage")

Description

Returns the name of all Tax solutions defined in Sage Intacct where the Tax engine field is set to "VAT or GST".

Result

Note:

The No Tax solution has been omitted because its Tax engine field is set to None.

The US Advanced Tax solution has been omitted because its Tax engine field is set to Advanced Tax.

Example 2

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

Description

Returns the name of all active Tax solutions defined in Sage Intacct where the Tax engine field is set to "VAT or GST".

Result

(note that the inactive Tax Solution Name "Australia - GST" is not included in the results)

Additional Examples