PROJECTENDINGAMOUNT

Overview

The PROJECTENDINGAMOUNT function calculates the ending amount of one or more project(s) and task(s) as of a specific period.

Syntax

CODE

=PROJECTENDINGAMOUNT(Connection, Project, Task, AccountGroup, CostCode, InventoryItem, AsOfPeriod, Branch, UseProjectCurrency, UseMasterFinancialCalendar)

Arguments

The PROJECTENDINGAMOUNT function uses the following arguments (see our article on Filtering Velixo functions):

Argument	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 Acumatica 2019 or later; for earlier versions, this argument must be left blank.
`UseProjectCurrency`	Optional	`TRUE`/`FALSE` value indicating if the amount should be returned in the project's currency (default = `FALSE`)
`UseMasterFinancialCalendar`	Optional	Use Acumatica's Master Financial Calendar instead of the financial calendar defined within the specific tenant associated with the connection being accessed (this can be useful for consolidation reports). Possible values: `TRUE` `FALSE` (default)

Example

CODE

=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