Description
The PROJECTENDINGAMOUNT function calculates the ending amount of one or more project(s) and task(s) as of a specific period.
Syntax
PROJECTENDINGAMOUNT(Connection, Project, Task, AccountGroup, CostCode,
InventoryItem, AsOfPeriod, Branch, UseProjectCurrency)
Parameters
The PROJECTENDINGAMOUNT 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 |
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 |
AsOfPeriod | Required | The financial period in MM-YYYY format |
Branch | Optional | The Branch(es) in include. Requires Acumatica or MYOB Advanced 2019 or later; for earlier versions, this parameter must be left blank. |
UseProjectCurrency | Optional | TRUE/FALSE value indicating if the amount should be returned in the project's currency (default = FALSE) |
Example
=PROJECTENDINGAMOUNT("Demo", "TMR03", , "LABOR",,, "12-2018", TRUE)
Description
Calculates the ending cost of labor for project TMR03 as of the start of December 2018 and returns the value in the project's defined currency.
Result
17040
Applies to
PM Module