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

Applies to

PM Module