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