PROJECTTURNOVERQUANTITY function
Applies to:
- PM Module
- ERP: Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Acumatica
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, UseMasterFinancialCalendar)
Parameters
The PROJECTTURNOVERQUANTITY 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 |
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 |
| 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:
|
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
The results of the PROJECTTURNOVERQUANTITY function intentionally exclude data from project transactions which do not include an InventoryID. |