ACCOUNTCONSOLIST function

Created by Harry Lewis, Modified on Thu, 05 Oct 2023 at 05:49 PM by Gabriel Michaud

Applies to

Velixo Classic
Velixo NX
Acumatica, MYOB Advanced, 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
Parameters
Example

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:

  =ACCOUNTCONSOLIST("Demo","10500")

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

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:

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

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