EXPANDCOMPANYRANGE function

Created by Harry Lewis, Modified on Tue, 16 Jul at 9:33 AM by Gabriel Michaud

Applies to

  • Velixo Classic 6.0.376 or higher
  • ERP:  Acumatica, CEGIC, Haufe x360, JAMIS Prime, MYOB Acumatica


 

Description


The EXPANDCOMPANYRANGE function returns all company codes within the specified range

 


Velixo recommends the use of Microsoft 365 for this feature. Experimentally, Excel 2010 or higher may be used. See the Prerequisites for additional information.

 


TABLE OF CONTENTS



Syntax

EXPANDCOMPANYRANGE(Connection, Range)

 

Parameters


The EXPANDCOMPANYRANGE 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 company codes to include in the results

 

Examples

Example 1

 

=EXPANDCOMPANYRANGE("Demo")

 

Description

Returns an Excel dynamic array containing all company codes in the tenant defined in the specified connection.

 

Result

exp_company.png

Example 2

 

=EXPANDCOMPANYRANGE("Demo";"*;-PRODUCTS")

 

Description

Returns all company codes except PRODUCTS.

 

Result

exp_company2.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