Velixo recommends the use of Microsoft 365 for this feature. Experimentally, Excel 2010 or higher can be used. See the Prerequisites for additional information. |
Description
The EXPANDPROJECTRANGE function returns all project codes within the specified range
Syntax
EXPANDPROJECTRANGE(Connection, Range, IncludeInactive)
The EXPANDPROJECTRANGE function uses the following parameters (see our article on Filtering Velixo functions):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Range | Optional | The range of project codes to include in the results |
IncludeInactive | Optional | TRUE/FALSE (default is TRUE) indicating whether or not to include projects with Acumatica's inactive project codes (In Planning, Canceled, Suspended, Pending Approval, Pending Upgrade) |
Example
=EXPANDPROJECTRANGE("demo","*;-INTERNAL??")
Description
Returns the project codes for all Active projects except our INTERNAL projects.
Result
Applies to
PM Module