Velixo NX Release notes 2023 Archive

SI.EXPANDPROJECTESTIMATERANGE

Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 5:49 PM by Gabriel Michaud

Applies to:

Velixo NX
Sage Intacct

The SI.EXPANDPROJECTESTIMATERANGE function returns an array containing one or more Sage Intacct Project Estimate IDs (based on the specified projects and range).

TABLE OF CONTENTS

Syntax
Examples

Syntax

SI.EXPANDPROJECTESTIMATERANGE(ConnectionName, ProjectRange, EstimateIdRange, Status)

The SI. EXPANDPROJECTESTIMATE RANGE function uses the following parameters:

Parameter	Required/ Optional	Description
ConnectionName	Required	The name of the connection as configured in the Connection Manager
ProjectRange	Optional	A range filter specifying the Project IDs to be used to determine the Estimate IDs to be displayed. See Filtering Velixo Functions.
EstimateIdRange	Optional	A range filter specifying the IDs of the Estimates to be displayed. See Filtering Velixo Functions.
Status	Optional	An indicator of which status(es) of project to include in the results. "A" - active "I" - inactive "F" - finalized A combination may be used. The default is "AIF" to include all projects. (available in version 2023.8 and higher)

Examples

Assuming the following configuration within Sage Intacct:

Example 1

=SI.EXPANDPROJECTETIMATERANGE("Sage","20-001")

Description

Returns all Estimate IDs used in the 20-001 project.

Results

(the ProjectRange parameter has been represented by a cell reference)

Example 2

=SI.EXPANDPROJECTESTIMATERANGE("Sage","HAWK???")

Description

Returns all Estimate IDs for projects whose ID begins with HAWK

Results

Example 3

=SI.EXPANDPROJECTESTIMATERANGE("Sage","20-001;20-004")

Description

Returns all Estimate IDs used in the two specified projects.

Results

Example 4

Assuming the following configuration within Sage Intacct:

=SI.EXPANDPROJECTESTIMATERANGE("Sage",,"FI")

Description

Returns all Estimate IDs with a status of either Finalized or Inactive

Results