ACCOUNTCLASS 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 ACCOUNTCLASS function returns the account class code of a General Ledger account.



TABLE OF CONTENTS

 

Syntax

ACCOUNTCLASS(Connection, Account)

 

Parameters

The ACCOUNTCLASS function uses the following parameters (see our article on 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

Account

Required

The general ledger account for which the Account Class is to be displayed.

 

 

Example

  =ACCOUNTCLASS("Demo", "40020")

 

Description: Returns the account class of general ledger account 40200.

 

Result: SALES

 

accountclassex.png


Note:


If a non-existent account code is specified, the ACCOUNTCLASS function will display Account 'xxxxx' not found.


accountclass_notfound_1b.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:


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