BRANCHLIST function
Created by Harry Lewis, Modified on Tue, 16 Jul at 9:33 AM by Gabriel Michaud
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.
TABLE OF CONTENTS
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:  |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article