SI.PROJECTESTIMATEQUANTITY

Created by Harry Lewis, Modified on Fri, 6 Sep at 12:20 PM by Harry Lewis

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.

TABLE OF CONTENTS

Syntax
Parameters
Examples
- Example 1 - filtered by project (job) and a single task
- Example 2 - filtered by estimate, project, and multiple tasks

Syntax

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

Parameters

The SI.PROJECTESTIMATEQUANTITY function uses the following parameters (please see the article on Filtering Techniques for Velixo Functions for how to include multiple values in a parameter):

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.
Include Child Dimension Balances	Optional	True or False (Default) Determines if (for dimensions which have child dimensions) the balances of child dimensions are included in the calculation of the total balance. This parameter only affects balances if: the Location argument is defined and/or other dimensions are specified in the Dimensions or UserDefinedDimensions parameters. This parameter performs similarly to the Include subdimensions checkbox in Sage Intacct's stock reports such as Account Balances:

Examples

Example 1 - filtered by project (job) and a single task

=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 - filtered by estimate, project, and multiple tasks

=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