JD Edwards GXD
For JD Edwards ledgers, the GXD formula is used to retrieve the description of a single account string, or company or business unit segment.
Syntax
=GXD("Configuration","Value","Description Type")
Note: It is common practice to use cell references within GXD formulas to identify parameters.
Parameters
The following are GXD formula parameters for JD Edwards ledgers:
Configuration
Identifies the host configuration from which to retrieve the description. May specify either the full configuration name or only the number.
Value
-
AC(Account String): identifies the account string. -
CO(Company): identifies the company. -
BU(Business Unit): identifies the business unit.
Description Type
Identifies the segment type for which to retrieve a description. Valid values are:
-
AC(Account String) -
CO(Company) -
BU(Business Unit)
Formula Example: Retrieve an Account String Description
=GXD("1","00001-1-1110-FIB","AC")
Retrieves the account description of the account string 00001-1-1110-FIB.
Formula Example: Retrieve a Company Description
=GXD("1","00001","CO")
Retrieves the description of company 00001.
Formula Example: Retrieve a Business Unit Description
=GXD("1","1","BU")
Retrieves the description of business unit 1.
See GL Reporting and Create or Maintain GL Formulas for more information.