BRANCHLIST function
Applies to
Velixo Classic
Velixo NX
Acumatica, MYOB Acumatica, Cegid XRP Flex
GL Module
Description
The BRANCHLIST function returns the list of branches of one or more company IDs.
Syntax
BRANCHLIST(Connection, Company)
Parameters
The BRANCHLIST function uses the following parameters (see our article on using arrays or cell ranges as parameters):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection, as specified in the Connection Manager |
Company | Optional | The ID of the company. If left empty, the function will return all branches defined in the database |
Example
=BRANCHLIST("Demo", "PRODUCTS")Description: Returns the list of branches within the PRODUCTS company.
Result: PRODWHOLE, PRODRETAIL
Empty ListIf a non-existent company name is specified, the BRANCHLIST function will either display the message Error! No element matches range xxxxxxxxx...  or, if you have configured Velixo reports to return zero values under certain circumstances...  ... your report will display Excel's #N/A error:  |
