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

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