PROJECTFORECASTREVISEDAMOUNT function
Applies to
- Velixo NX
- Velixo Classic
- Acumatica, MYOB Acumatica, Cegid
Description
The PROJECTFORECASTREVISEDAMOUNT function calculates the revised forecasted amount of one or more project(s) and task(s).
Syntax
PROJECTFORECASTREVISEDAMOUNT(Connection, Project, Revision, Task, AccountGroup, CostCode, InventoryItem, FromPeriod, ToPeriod)
Parameters
The PROJECTFORECASTREVISEDAMOUNT 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 |
Revision | Required | The Forecasted Review 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 |
FromPeriod | Required | Beginning Financial Period in MM-YYYY format |
ToPeriod | Required | Ending Financial Period in MM-YYYY format |
Example
=PROJECTFORECASTREVISEDAMOUNT("Demo","BUDGETBYM","2","01", "MATERIAL",, "AACOMPUT01","03-2019","03-2019")
Description
Calculates the revised forecasted amount for revision number 2 of the forecast of in the BUDGETBYM project (filtered on task=01, account group=MATERIAL, inventory item=AACOMPUT01, and the third financial period of 2019).
Result
400.00