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 List

If a non-existent company name is specified, the BRANCHLIST function will either display the message Error! No element matches range xxxxxxxxx...


branchlist_empty_a2.png

or, if you have configured Velixo reports to return zero values under certain circumstances...


Options_return_zero.png

... your report will display Excel's #N/A error:


branchlist_empty_b2.png


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article