PROJECTREVISEDBUDGETAMOUNT function
Applies to
- Velixo NX
- Velixo Classic
- Acumatica, MYOB Acumatica, Cegid
Description
The PROJECTREVISEDBUDGETAMOUNT function calculates the revised budgeted amount of one or more project(s) and task(s).
Syntax
PROJECTREVISEDBUDGETAMOUNT(Connection, Project, Task, AccountGroup, CostCode, InventoryItem, UseProjectCurrency)
Parameters
The PROJECTREVISEDBUDGETAMOUNT 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 |
UseProjectCurrency | Optional | TRUE/FALSE value indicating if the amount should be returned in the project's currency (default = FALSE) |
Example
=PROJECTREVISEDBUDGETAMOUNT("Demo","FIXEDP01","",,,"", TRUE)
Description
Calculates the revised budgeted amount of the FIXEDP01 projects and task(s) and return the value in the project's defined currency.
Result
16000