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 EXPANDBRANCHRANGE function returns all branch codes within the specified range
Syntax
EXPANDBRANCHRANGE(Connection, Range, IncludeInactive)The EXPANDBRANCHRANGE function uses the following parameters (see our article on including multiple parameter values):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Range | Optional | The range of branch codes to include in the results |
IncludeInactive | Optional | TRUE/FALSE indicating whether or not to include inactive branch codes (default is FALSE) |
Example
=EXPANDBRANCHRANGE("Demo", "*;-PRODWHOLE")Description
Returns all Active branch codes EXCEPT PRODWHOLE.
Result
Applies to
GL Module