Infinium GXD

For Infinium ledgers, the GXD formula is used to retrieve the description of a single account string. In the event multiple accounts are referenced in a single GXD formula, the system returns the description of the first account string found, and adds a warning message to the log, indicating the GXD results returned more than one record.

Syntax

=GXD("Library","Account String")

Note: It is common practice to use cell references within GXD formulas to identify parameters.

Parameters

The following are GXD formula parameters for Infinium ledgers:

Library

Identifies the alternate library from which to retrieve the description. Entry is optional. If left blank, the system uses the default library in Application Configurator, or the library specified during the sign in process.

Account String

Enter one parameter for each segment of the account string for which to retrieve the description. The number of account segments are based on the number specified in the user's Ledger Specifics Settings.

Formula Example:

=GXD(,"001","310","6000","005")

Retrieves the account description for the account string 001-310-6000-005.

See GL Reporting and Create or Maintain GL Formulas for more information.