Designer GL 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 Designer GL ledger. A user's ability to execute a GXL for a Designer GL ledger using a stored procedure is determined by the user's Application Configurator settings.

Note: The Designer GL definition for APlus is used in the examples below.

Syntax

=GXL("Key 1","Key 2","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 Designer GL ledgers:

Key 1

The value entered for the Key 1 parameter varies based on the requirements for the selected Designer GL (for example, APlusKey 1= Library).

Key 2

The value entered for the Key 2 parameter varies based on the requirements for the selected Designer GL. (for example, APlusKey 2= Balance Type).

Key 3

Identifies the Designer GL definition.

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-nn

Enter one parameter for each segment of the account string. The number of account segments vary based on the account structure for the selected ledger. May be a single value, mask, range, value list, segment list, hierarchy value, or @ field (see Account Segment Syntax for more information).

Note: For ASI Designer GLs only, if the actual account segment value is * in the GL database, use # in the GXL formula instead of * for the account segment value.

Formula Example: Using a Range

=GXL("APLUS","ACTUAL","CUSTOMGL="APLUS";","2007","PER","8","1","0000","0","8050","5010","310.350")

Retrieves the actual activity for period 8 of 2007, for a range of account codes 310 through 350.

Formula Example: Using a Mask

=GXL("APLUS","ACTUAL","CUSTOMGL="APLUS";","2007","PER","8","1","0000","0","8*","5010","310")

Retrieves the actual activity for period 8 of 2007, with a mask for every department beginning with 8.

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