Description
The PROJECTBEGINNINGAMOUNT function calculates the beginning amount of one or more project(s) and task(s) as of a specific period.
Syntax
PROJECTBEGINNINGAMOUNT(Connection, Project, Task, AccountGroup,
CostCode, InventoryItem, AsOfPeriod, Branch, UseProjectCurrency)
The PROJECTBEGINNINGAMOUNT 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; in 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
=PROJECTBEGINNINGAMOUNT("Demo", "TMR03", , "LABOR",,, "12-2018",
FALSE)Description
Calculates the beginning cost of labor for project TMR03 as of the start of December 2018 and returns the value in the default currency.
Result
17040
Applies to
PM Module