PROJECTBUDGETQUANTITY function
Applies to:
- Velixo NX
- Velixo Classic
- PM Module
- Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Acumatica
Description
The PROJECTBUDGETQUANTITY function calculates the original budgeted quantity of one or more projects and tasks.
Syntax
PROJECTBUDGETQUANTITY(Connection, Project, Task, AccountGroup, CostCode, InventoryItem)
The PROJECTBUDGETQUANTITY 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
=PROJECTBUDGETQUANTITY("Demo","Planning","",,,"" )Description
Calculates the original budgeted quantity of the Planning project and its associated tasks.
Result
95