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 including multiple parameter values):
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 March of 2019 ad filtered on task 01, account group MATERIAL and inventory item AACOMPUT01
Result
1.00
Applies to
PM Module