PROJECTPENDINGINVOICEAMOUNT

Overview

The PROJECTPENDINGINVOICEAMOUNT function calculates the pending invoice amount of one or more project(s) and task(s).

Syntax

CODE

=PROJECTPENDINGINVOICEAMOUNT(Connection, Project, Task, AccountGroup, CostCode, InventoryItem, UseProjectCurrency)

Arguments

The PROJECTPENDINGINVOICEAMOUNT 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
`UseProjectCurrency`	Optional	`TRUE`/`FALSE` value indicating if the amount should be returned in the project's currency (default = `FALSE`)

Example

CODE

=PROJECTPENDINGINVOICEAMOUNT("Demo","FLDEVELOP1", "L01", "SUB", "09200", "<N/A>", FALSE)

Description

Calculates the pending invoice amount of task L01 in the FLDEVELOP1 project (filtered by the specified AccountGroup, CostCode, and InventoryItem) and returns that value in the default currency.

Result

0