SI.PROJECTESTIMATEQUANTITY

Created by Harry Lewis, Modified on Tue, 16 Apr at 6:55 PM by Damien Zwillinger

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, WorkflowType)

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, the Primary estimate is used.
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)
Workflow Type	Optional	The workflow types to be included in the results. Allowed values: O (for Original) R (for Revision) F (for Forecast) A (for Approved change) P (for Pending change) T (for Other) Values can be combined. For example if "APT" is used, then values for Approved change, Pending change and Other Workflow types will be returned.

* 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