PROJECTCOMMITTEDQUANTITY function
Applies to
- Velixo NX
- Velixo Classic
- Acumatica, MYOB Acumatica, Cegid
Description
The PROJECTCOMMITTEDQUANTITY function calculates the original committed quantity of one or more projects and tasks.
Syntax
=PROJECTCOMMITTEDQUANTITY(Connection, Project, Task, AccountGroup, CostCode, InventoryItem)
The PROJECTCOMMITTEDQUANTITY function uses the following parameters (see our article on Filtering Velixo functions):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Project | Required | The Project(s) to include |
Task | Optional | The Task(s) to include |
AccountGroup | Optional | The Account Group(s) to include |
CostCode | Optional | The Cost Code(s) to include |
InventoryItem | Optional | The Inventory Item(s) to include |
Example
=PROJECTCOMMITTEDQUANTITY("Demo","20231001", "03", "SUB", "03460", "<N/A>")Description
Calculates the original committed quantity for task 03, for the account group SUB, and cost code 03460 in the 20231001 project.
Result
1