Description
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
PROJECTTURNOVERQUANTITY(Connection, Project, Task, AccountGroup, CostCode, InventoryItem, FromPeriod, ToPeriod, Branch)
The PROJECTTURNOVERQUANTITY function uses the following parameters (see our article on including multiple parameter values):
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 |
FromPeriod | Required | Starting Financial Period in MM-YYYY format |
ToPeriod | Required | Ending Financial Period in MM-YYYY format |
Branch | Optional | The IDs of the Branches to include |
Example
=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
Applies to
PM Module
The results of the PROJECTTURNOVERQUANTITY function intentionally exclude data from project transactions which do not include an InventoryID. |