Requires Acumatica 2019 or higher | MYOB Advanced 2019.1 or higher
Description
The PROJECTFORECASTREVISEDAMOUNT function calculates the revised forecasted amount of one or more project(s) and task(s).
Syntax
PROJECTFORECASTREVISEDAMOUNT(Connection, Project, Revision, Task,
AccountGroup, CostCode, InventoryItem, FromPeriod, ToPeriod)
The PROJECTFORECASTREVISEDAMOUNT 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 Forecasted Review 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
=PROJECTFORECASTREVISEDAMOUNT("Demo","BUDGETBYM","2","01",
"MATERIAL",, "AACOMPUT01","03-2019","03-2019")
Description
Calculates the revised forecasted amount for revision number 2 of the forecast of in the BUDGETBYM project (filtered on task=01, account group=MATERIAL, inventory item=AACOMPUT01, and the third financial period of 2019).
Result
400.00
Applies to
PM Module
Product Versions
Acumatica 2019
MYOB Advanced 2019.1