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