SI.PROJECTESTIMATEQUANTITY

Modified on Thu, 14 Sep 2023 at 02:46 AM

Applies to:

Velixo NX
Sage Intacct

The SI.PROJECTESTIMATEQUANTITY returns the quantity set for one or more estimates configured for a specified project/projects, optionally filtered by Task ID, CostType ID, and/or Item ID.

Syntax

SI.PROJECTESTIMATEQUANTITY(Connection, Project, EstimateId, TaskId, CostTypeId, ItemId)

Parameters

The SI. PROJECTESTIMATEQUANTITY function uses the following parameters:

Parameter	Required/Optional	Description
Connection	Required	The name of the connection as configured in the Connection Manager
Project	Required	The ID of one or more projects* containing the estimate wanted
EstimateId	Optional	The ID of one or more estimates* for which the quantity value is wanted (if left blank = primary estimate considered)
TaskId	Optional	The ID of one or more tasks* to be used to filter the results (if left blank, estimates for all tasks will be included)
CostTypeId	Optional	The ID of one or more Cost Types* to be used to filter the results (if left blank, estimates for all Cost Types will be included)
ItemId	Optional	The ID of one or more Items* to be used to filter the results (if left blank, estimates for all Items will be included)

* see Filtering Techniques for Velixo Functions

Examples

Example 1

=SI.PROJECTESTIMATEQUANTITY("Sage", "20-005",,"G01-040")

Description

Returns quantity for primary estimate for task number G01-040 in project 20-005

Result

(cell references have been used for some parameters in this example)

Example 2

=SI.PROJECTESTIMATEQUANTITY("Sage", "20-005","100",C5#)

Description

Returns the quantity for estimate 100 for all tasks displayed by the function in cell C5 for project 20-005

Result