PROJECTBEGINNINGQUANTITY function
Applies to:
- PM Module
- Acumatica, MYOB Acumatica, Cegid XRP Flex
Description
The PROJECTBEGINNINGQUANTITY function calculates (for a specific financial period) the beginning quantity of one or more project(s) and task(s) containing Inventory Item information.
Syntax
PROJECTBEGINNINGQUANTITY(Connection, Project, Task, AccountGroup, CostCode, InventoryItem, AsOfPeriod, Branch, UseMasterFinancialCalendar)
Parameters
The PROJECTBEGINNINGQUANTITY function has the following parameters (See our article on Filtering Velixo functions).
Parameter | Required/Optional | Description |
Connection | Required | 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 Code Code(s) to include |
InventoryItem | Optional | The Inventory Item(s) to include |
AsOfPeriod | Required | Financial period in the format MM-YYYY |
Branch | Optional | The Branch(es) to include Requires Acumatica or MYOB Acumatica 2019 or later; in earlier versions, this parameter must be left blank |
| 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
=PROJECTBEGINNINGQUANTITY("Demo", "TMR03", , "LABOR",, ,"01-2017")
Description:
Calculates the number of hours of Labor for project TMR03 as of the start of January 2017.
Result
240
The results of the PROJECTBEGINNINGQUANTITY function intentionally exclude data from project transactions which do not include an InventoryID. |