SUBACCOUNTNAME Function

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

Applies to:

TABLE OF CONTENTS

Description

The SUBACCOUNTNAME function returns the name of the specified GL subaccount.

SUBACCOUNTNAME(Connection, Account)

The SUBACCOUNTNAME function uses the following parameters (see our articl 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
Subaccount	Required	The general ledger subaccount for which the name is to be returned

   =SUBACCOUNTNAME("Demo", "000CON")

Description: Returns the name of subaccount #000CON.

Result: Consulting

If a non-existent subaccount is specified, the SUBACCOUNTNAME function will display the message Subaccount 'xxxxx' not found...