PROJECTTURNOVERQUANTITY function

Created by Harry Lewis, Modified on Mon, 15 Apr 2024 at 02:17 PM by Harry Lewis

Applies to:

PM Module
ERP: Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Advanced

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.

TABLE OF CONTENTS

Syntax
Parameters
Example

Syntax

PROJECTTURNOVERQUANTITY(Connection, Project, Task, AccountGroup, CostCode,  InventoryItem, FromPeriodOrDate, ToPeriodOrDate, 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
FromPeriodOrDate	Required	Starting Financial Period in MM-YYYY format or a date in a valid Excel format*
ToPeriodOrDate	Required	Ending Financial Period in MM-YYYY format or a date in a valid Excel 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: True False (default)

* use of dates with this function in Velixo Classic requires version 7.1 or higher

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.