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