SI.PROJECTESTIMATEQUANTITY

Created by Harry Lewis, Modified on Tue, 16 Apr 2024 at 06: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 TypeOptionalThe workflow types to be included in the results.

Allowed values:
  • (for Original)
  • (for Revision)
  • (for Forecast)
  • (for Approved change)
  • (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


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article