Description
The PROJECTBEGINNINGQUANTITY function 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 has the following parameters (See our article on including multiple parameter values).
| 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
|
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
Applies to
PM Module
Comments
0 comments
Article is closed for comments.