Movex 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 Movex ledgers:

Syntax

=GXL("Budget Number","Budget Revision","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 Movex ledgers:

Budget Number

Identifies the budget number. If left blank, actual data is retrieved.

Budget Revision

Identifies the budget revision. A budget revision is required if a budget number is specified.

Key 3

Optionally, identifies statistical data, alternate library, balance key, Budget Manager name or revision, and/or exchange rate. Enter the necessary literal and a value as defined below. If more than one variable needs to be defined, separate the variables with a semi-colon ( ; ).

"STAT=Y" indicates the retrieval of statistical balances.
"LIBRARY=NNNN" where NNNN is the name of the alternate library.
"BALANCE KEY=XX" where XX is the balance key.
"BUDGET:NNNN:XX" where NNNN is the budget name, and XX is the budget revision.
"EXCHRATE=NNNN" where NNNN is the exchange rate.

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

Enter one parameter for each segment of the account string (for example, Company, Division, and Dimension1-7). 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(,,"STAT=N";"BALANCE KEY=8","2004","PER","4","210","AAA","51*","*","*","*")

Retrieves the monetary activity for period 4 of 2004, for accounts starting with 51, using balance key 8.

Formula Example: Using a Range

=GXL(,,"STAT=N";"BALANCE KEY=8","2004","PER","4","210","AAA","5100.5500")

Retrieves the monetary activity for period 4 of 2004, for accounts 5100 through 5500, using balance key 8.

Formula Example: Retrieving Budget Data:

=GXL("1","1","BALANCE KEY=8","2004","PER","4","210","AAA","5710","*","*","*")

Retrieves the budget balance for period 4 of 2004, for an account mask using balance key 8, for Budget Number 1 and Budget Revision 1.

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