ACCOUNTCONSOLIST 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 ACCOUNTCONSOLIST function returns the list of GL account codes (if any) matching the specified consolidation account(s).



TABLE OF CONTENTS


 

Syntax

  ACCOUNTCONSOLIST(Connection, ConsolidationAccount)

 

Parameters

This ACCOUNTCONSOLIST function uses the following parameters (see our articles on Filtering Velixo Functions and using Excel arrays or cell ranges as parameters):

 

Parameter

Required/Optional

Description

Connection

Required

The name of the connection, as specified in the Connection Manager

ConsolidationAccount

Required

The consolidation general ledger account(s) to include.

 

Example

Let's assume this Chart of Accounts configuration within Acumatica:

 

Consolist_1.png
  =ACCOUNTCONSOLIST("Demo","10500")

 

Description: This function returns the semicolon-delimited list of accounts which have a consolidation account code of 10500

 

Consolist_2.png

 

Empty Lists


If no Consolidation List exists for the specified account(s), the ACCOUNTCONSOLIST will either display the message Error! Consolidation Account 'xxxxx' not found:


Consolist_notfound_a.png

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


Options_return_zero.png

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


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