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