Requires Acumatica 2019 or higher | MYOB Advanced 2019.1 or higher
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)
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
Applies to
PM Module