This article describes the formula syntax and usage of the PROJECTBEGINNINGQUANTITY function.
Description
Calculates the beginning quantity of one or more project(s) and task(s) as of a specific period.
Syntax
PROJECTBEGINNINGQUANTITY(Connection, Project, Task, AccountGroup, CostCode, InventoryItem, AsOfPeriod, Branch)
The PROJECTBEGINNINGQUANTITY function syntax has the following arguments:
- Connection Required. Name of the connection as configured in the connection manager.
- Project The project(s) to include. Multiple projects can be included by separating them with a semicolon (;), by using a range (START:END) format or excluded by prefixing with minus (-).
- Task The task(s) to include. Multiple tasks can be included by separating them with a semicolon (;) or by using a range (START:END) format.
- AccountGroup The account group(s) to include. Multiple account groups can be included by separating them with a semicolon (;), by using a range (START:END) format or excluded by prefixing with minus (-).
- CostCode The cost code(s) to include. Multiple cost codes can be included by separating them with a semicolon (;), by using a range (START:END) format or excluded by prefixing with minus (-).
- InventoryItem The inventory item(s) to include. Multiple inventory items can be included by separating them with a semicolon (;), by using a range (START:END) format or excluded by prefixing with minus (-).
- AsOfPeriod Financial period in MM-YYYY format.
- Branch The branch(es) to include. Multiple branches can be included by separating them with a semi-column (;), by using a range (START:END) format or excluded by prefixing with minus (-). If left blank, all branches will be included. Note: Requires Velixo Reports version 4.3 or later and Acumatica or MYOB Advanced 2019 or later; in earlier versions, this argument must be left blank.
Example
Formula | Description | Result |
=PROJECTBEGINNINGQUANTITY("Demo", "TMR03", , "LABOR",, ,"01-2017") | Calculates the number of hours of labor for project TMR03 as of the start of January 2017. | 240 |
Applies to
PM Module
Comments
0 comments
Please sign in to leave a comment.