CU*BASE Query: Q-GL Balance File (GLBALA)

This Query is used to view information contained in the CU*BASE “GLBALA” file. This file stores month-end balances for every General Ledger account.

Specifications

File(s) used by this Query: GLBALA

Access: Tool #384: GL Balance File (GLBALA)

Records will be sorted and grouped by G/L account number, with each group sorted in order by posted year and month. After each group, the system will show a total and count for all entries within that group, with grand totals at the bottom of the report.

The following fields will be displayed in this Query:

  • Corporate ID

  • GL Account Number

  • Post Year, Post Month

  • Branch Number

  • Net Change

  • End of Period Balance

  • Post Type Indicator (Regular/Budget/Year-End Close)

Sample Conditions

The following table lists a few sample conditions which can be used in the GL Balance File Query.

Description

 

Field

Test

Value

Show balances only for G/L account number 901.00.

GLACCT

EQ

901.00

Show June 1996 balances for all accounts.

 

AND

POSTYR

POSTMO

EQ

EQ

96

06

 

Clickherefor complete instructions on navigating around the “Display Report” screen or using the available buttons.