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
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:
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:
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
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000107663/original/YraAmFyl6KwnkcmeKo09MJ_6FVHDfsI3UA.png?1693446789)
(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
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000107664/original/cSRBgTXZL1CnhjArDuRJo_F4vk-Pw_To1Q.png?1693446789)
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article