G/L Journal Inquiry

Program/Screen: GLJRNI/GLJRNIC1

Description:

Use this program to review matched or unmatched transactions for one G/L account or for a range of accounts for a specific date range.  This is also the program that launches when you select Bank Account Journal from the Bank Transactions menu.

 

Click a link to advance to that section of the topic.

 

 

Navigation

Access this screen by entering a date range and one G/L account or a range of G/L accounts on the G/L Journal Inquiry - Launch screen and pressing Enter.  If you accessed this program from the Bank Account Journal option, the only G/L accounts you can enter on the Launch screen are ones that have been set up as bank accounts in Bank Account Maintenance.

 

Unique G/L Journal Inquiry Screens

G/L Journal Inquiry - Launch

G/L Journal Inquiry

G/L Journal Inquiry - Analysis Code Update

G/L Journal Transaction Display

 

Additional Program Screens

Invoice Inquiry

 

Options

Option

Description

1

Update Analysis Codes.  Enter 1 in the Option field to advance to the G/L Journal Transaction Detail - Analysis Code Update screen to modify the analysis codes for the selected transaction.

2

Display Invoice.  Enter 2 in the Option field to advance to the Invoice Inquiry program.

5

Display Journal.  Enter 5 in the Option field to advance to the G/L Journal Transaction Display program.

 

Fields

From Date

Enter or accept the starting date for the G/L transactions you want to review.

 

To Date

Enter or accept the ending date for the G/L transactions you want to review.

 

From Account

Enter or accept the starting G/L account number for the transactions you want to review.  Leave this field and the To Account field blank to review the transactions for all G/L accounts in the date range.

 

Example:  You can also enter just certain segments of the account number in conjunction with those same segments in the To Account to review all transactions in a range of accounts.  For example, you could enter 001240 in the first segment and 0010 in the third segment; and then in the To Account field, also enter 001240 in the first segment and 0025 in the third segment to review a list of transactions for all G/L accounts starting with 001240 that have natural class accounts starting with 0010 and ending with 0025.

 

If you accessed this program from the Bank Account Journal option, you cannot change the account number.

 

To Account

Enter or accept the ending G/L account number for the transactions you want to review.  Leave this field and the From Account field blank to review the transactions for all G/L accounts in the date range.

 

If you accessed this program from the Bank Account Journal option, you cannot change the account number.

 

Analysis Codes

Enter up to six analysis codeUser-defined code assigned to G/L accounts and used for analysis and reporting purposes.s by which to focus the list of G/L transactions.

 

Invoice Number

If applicable, enter the number of the invoice for which you want to review G/L transactions.

 

Type

Enter a code such as EX for Expenses to filter the list for that account type only.

 

Back to top

Movement Number

Displays the number assigned by the system to every transaction that affects the general ledger.

 

Journal Reference

Displays the journal reference assigned to the transaction.  The journal reference is a concatenation of the transaction's journal code and a system-assigned journal number.

 

Date

Displays the transaction's date.

 

Account Number

Displays the G/L account number for which you are reviewing transactions.

 

Account Description

Displays a brief description of the G/L account.

 

Debit

If applicable, the field displays the debit amount for the transaction.

 

Credit

If applicable, the field displays the credit amount for the transaction.

 

Lettrage Number

When you toggle the display using F8 to review all transactions or matched transactions, this field displays the system-assigned lettrage/matching number for the transaction.

 

Description

Displays a brief description of the transaction.

 

Function Keys

Function Key

Description

F1

Help.  Place your cursor in a field and press F1 to access online help for that field.  Place your cursor outside of any field, and press F1 to access online help at the program level.

F3

Exit.  Exit the page or program.

F4

Search.  Place your cursor in a searchable field and press F4 to access a lookup window or more advanced search screen.

F6

Sort.  Sort the list by date and account number or by date only.

F8

Toggle.  Toggle the list to display all transactions, only matched/lettraged transactions, or only unmatched transactions for the criteria specified.

F12

Cancel/Previous.  Exit the program or move back a screen.

F17 (Shift + F5)

Top.  Return directly to the top of the transaction list.

F18 (Shift + F6)

Bottom.  Advance directly to the bottom of the transaction list.

 

Related Programs

G/L Inquiry

Analysis Code Maintenance

 

Special Topics

Coming in a future release.

 

 

Back to top