Data Warehouse GXD

For Data Warehouse ledgers, the GXD formula is used to retrieve the description of a single account string.

Syntax

=GXD("Account Segment 1","Account Segment 2","Account Segment 3","Account Segment 4","Account Segment 5"...)

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

Parameters

The following are GXD formula parameters for Data Warehouse ledgers:

Account String

Enter one parameter for each segment of the account string for which to retrieve the description. The number of account segments vary based on the account structure for the selected Data Warehouse profile.

Formula Example

=GXD("ABC","115","00","01")

Retrieves the account description for the account string ABC-115-00-01.

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