PROJECTTURNOVERQUANTITY

Overview

The PROJECTTURNOVERQUANTITY function calculates (for one or more financial periods) the turnover quantity of one or more projects and tasks containing Inventory Item information.

Syntax

CODE

=PROJECTTURNOVERQUANTITY(
    ConnectionName,
    Project,
    Task,
    AccountGroup,
    CostCode,
    InventoryItem,
    FromPeriodOrDate,
    ToPeriodOrDate,
    Branch,
    UseMasterFinancialCalendar
)

Arguments

The PROJECTTURNOVERQUANTITY function uses the following arguments (see our article on filtering Velixo functions):

Argument	Required/ Optional	Description
`ConnectionName`	Optional	Provide one of the following values: Connection name as defined in Connection Manager. Velixo range expression defining a set of connection names. An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array. OR Omit the argument to return results for all compatible connections with default aggregation settings.
`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
`FromPeriodOrDate`	Required	Starting financial period in MM-YYYY format OR Specified date (Acumatica 2025R2 or newer)
`ToPeriodOrDate`	Required	Ending financial period in MM-YYYY format OR Specified date (Acumatica 2025R2 or newer)
`Branch`	Optional	The IDs of the Branches to include
`UseMasterFinancial Calendar`	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

=PROJECTTURNOVERQUANTITY(
    "Demo",
    "TMR03",
    ,
    "LABOR",
    ,
    ,
    "01-2017",
    "12-2017"
)

Description

Calculates the total number of hours of Labor for project TMR03 during the year 2017

Result

205

The results of the PROJECTTURNOVERQUANTITY function intentionally exclude data from project transactions which do not include an InventoryID.