CU*BASE Query: Q-Journal Hist - GL# (GLHIST)

This Query is used to view information contained in the CU*BASE “GLHIST” file. This file stores all General Ledger transaction activity.

Specifications

File(s) used by this Query: GLHIST

Access: Tool 421: Journal History by GL# (GLHIST)

Records will be sorted and grouped by G/L account number, with each group sorted in order by J/E date. 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
Effective Post Date
Journal Entry ID
Journal Entry ID #
Branch Number
GL Account Number
Debit Amount
Credit Amount
Net Posted Amount
Journal Entry Description
Post Flag
Year-End Close Indicator

Sample Conditions

The following table lists a few sample conditions which can be used in the Journal Hist - GL# Query.

Description	Field	Test	Value
Show all journal entries posted to the month of June, 1996.	JEDT	RANGE	960601 960701
Show all journal entries with “FA” as the J/E ID.	JEID	EQ	'FA'