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)

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 semi-column (;), 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 semicolumn (;), by using a range (START:END) format, or excluded by prefixing with minus (-).
• AccountGroup The account group(s) to include. Multiple account groups can be included by separating them with a semi-column (;), 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 semi-column (;), 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 semi-column (;), by using a range (START:END) format, or excluded by prefixing with minus (-).
• AsOfPeriod Financial period in MM-YYYY format.

Example

Applies to

PM Module