BPCS GXD

For BPCS ledgers, the GXD formula is used to retrieve the description of a single account string. For BPCS 6.02 ledgers, an option in the user's Ledger Specific Settings determines the account segment used to retrieve the account description.

Syntax: Version 4.05

=GXD("Account String")

Syntax: Version 6+

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

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

Parameters

The following are GXD formula parameters for BPCS 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 ledger.

Ledger (Version 6+)

Identifies the CEA ledger.

Formula Example: Version 4.05

=GXD("30-000-31112")

Retrieves the account description for the account string 30-000-31112.

Formula Example: Version 6+

=GXD("50-000-31112","JRH")

Retrieves the account description for the account string 50-000-31112 from the JRH ledger.

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