Lawson GXD

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

Syntax

=GXD("Account","Sub Account","Chart Name")

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

Parameters

The following are GXD formula parameters for Lawson ledgers:

Account

Identifies the account value of the account string for which to retrieve the description.

Sub Account

Identifies the sub-account value of the account string for which to retrieve the description.

Chart Name

Identifies the name of the chart of accounts from which to retrieve the description. Entry is optional if the specified account string only exists in one chart of accounts.

Formula Example:

=GXD("40100","0","DCHHEALTHSYS")

Retrieves the segment description for account 40100 and sub-account 0.

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