Lawson GXL

Use the GXL formula to retrieve account balances for a specific format/reporting period. The following is an overview for the GXL formula for Lawson ledgers:

Syntax

=GXL("Balance Type","Budget #","Key3","Year","Format","Period","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 GXL formulas to identify parameters.

Parameters

The following are GXL formula parameters for Lawson ledgers:

Balance Type

Identifies the balance type. Valid types are:

• A (Actual Dollars)
• B (Budget Dollars)
• AU (Actual Units)
• BU (Budget Units)
• ADBP (Average Daily Balance Period)
• ADBQ (Average Daily Balance Quarter)
• ADBY (Average Daily Balance Year)

Budget #

Identifies the budget number. This value is only required if Balance Type is either B or BU.

Key 3

Not used. Enter 0.

Year

Year identifier.

Format

Format options are:

• PER: the activity of the selected period.
• QTR: the activity for the periods provided in the selected quarter number.
• DQTR: the activity for the periods provided in the selected daily quarter number.
• YTD: the activity for periods 1 through the designated period number, excluding the opening balance.
• LTD: the activity for periods 1 through the designated period number, including the opening balance.
• RANGE: the activity for the range of specified periods.

Period

Corresponds to period, quarter number, or range of periods (for example, 1.5 for periods 1 through 5) for the specified format.

Account Segment 1-5

Enter one parameter for each segment in the account string (for example, Company, Account Unit, Account, Sub-Account, and Chart of Accounts). May be a single value, mask, range, value list, segment list, hierarchy value, or @ field (see Account Segment Syntax for more information).

Formula Example: Using Masks

=GXL("A",,"0","2005","PER","12","10","6044*","3*","*","*")

Retrieves the actual activity for period 12 of 2005, for company 10, account units starting with 6044, and all accounts starting with 3.

Formula Example: Using a Range

=GXL("A",,"0","2005","PER","12","10","5500*","30100.32999","*","*")

Retrieves the actual activity for period 12 of 2005 for company 10, account units starting with 5500, and all accounts in the range of 30100 through 32999.

See Control Panel, GL Reporting, Create or Maintain GL Formulas, and GXL Formula for Account Values for more information.