Journal Entry Inquiry

Menu Path: General Ledger $Images\bluerarw.gif$ Inquiries $Images\bluerarw.gif$ Journal Entry Inquiry

Purpose

View journal entry information.

Overview

Use Journal Entry Inquiry to display posted and/or unposted journal entries. You can display a single journal entry, or a range of journal entries. You can also select a period and year for which to display journal entries, or display journal entries for all periods and years.

Displaying Journal Entries

To display journal entries:

If your company uses consolidation ledgers, verify the ledger ID for which you want to display journal entries is entered in the Ledger ID field.
Click the Lookup button at the right of the Journal Entry Origin field, and select the journal entry origin.
If you want to display a range of journal entries, enter the range in the From and To fields. If you want to display a single journal entry, enter the journal entry number in the From field.
Select filter options for the displayed journal entries.
Select whether you want to display posted, unposted, or both posted and unposted journal entries.
Click the Show Data button in the ribbon. The journal entries, that meet the selected criteria display on the Results tab.
To view more detailed information, select a journal entry, and then click the Transaction Detail, Profitability, Line Items, or Journal Entry Detail buttons in the ribbon.

Ribbon Home Tab Buttons

Button	Description
Exit	Click this button to close the Journal Entry Inquiry window.
Show Data	Click this button to display journal entry information, based on the criteria selected.
Transaction Detail	Click this button to display journal entry account or transaction detail information in A/P Payments for Journal Entry, A/P Vouchers for Journal Entry, A/R Invoices for Journal Entry, A/R Transaction Detail for Journal Entry, Foreign Currency Transactions for Journal Entry, I/C G/L Transactions for Journal Entry, or Journal Detail for Entry.
Profitability	Click this button to display Journal Entry Profitability Details, which allows you to view profitability information for a selected journal entry. This button is only available if the Results tab is displayed.
Line Items	Click this button to display Journal Entry Trailers, which allows you to view journal entry line items for the selected journal entry.
Journal Entry Detail	Click this button to display Journal Entry Detail, which allows you to view journal entry information.

Select Tab Fields and Buttons

Field or Button	Description
Journal Entry Origin	Click the Lookup button to select the origin of the journal entry(s) you want to display.
Ledger ID	Enter a ledger ID for which to display journal entries, or click the Lookup button to select a ledger ID. Note This field is only available if at least one consolidation ledger is set up.
From (Journal Entry)	Enter the first journal entry number in a range of journal entries to display, or click the Lookup button to select a journal entry number.
To (Journal Entry)	Enter the last journal entry number in a range of journal entries to display, or click the Lookup button to select a journal entry number.
All (Periods)	Select this check box to display journal information for all posting periods. This check box is cleared by default.
Period	Click the Lookup button to select a posting period for which to display journal information. This Lookup button is only enabled if you clear the All check box.
Year	Click the Lookup button to select a posting year for which to display journal information. This Lookup button is only enabled if you clear the All check box. The year can only be changed if you have the proper security.
All Currencies	Select this check box to display journal entries for all currencies. This check box is selected by default.
From (Currency)	Enter a currency for which to display journal entries, or click the Lookup button to select a currency. If you want to display journal entries for a range of currencies, enter the first currency in the range. This field is only enabled if you clear the All Currencies check box.
To (Currency)	Enter the last currency in a range of currencies for which to display journal entries, or click the Lookup button to select a currency. If you want to display journal entries for a single currency, you can leave this field blank. This field is only enabled if you clear the All Currencies check box.
Amount >=	Enter an amount to display only journal entries that are greater than or equal to this amount.
Source BEGINS with	Enter characters to display only journal entries with sources that begin with these characters.
Entered by BEGINS with	Enter characters to display only journal entries entered by user ID's that begin with these characters.
All (Transaction Dates)	Select this check box to display journal entries for all transaction dates. This check box is selected by default.
Transaction Date >=	Enter a date to display only journal entries with transaction dates on or after this date, or click the drop-down arrow to select a date. This field is only enabled if you clear the All check box to the left of it.
Display Options	Select the journal entries to view. Select one of the following: Posted - Display only posted journal entries. Unposted - Display only unposted journal entries. All - Display posted and unposted journal entries.

Results Tab Fields and Buttons

Field or Button

Description

Results

This grid displays journal information based on the criteria selected on the Select tab. The grid includes the following columns:

Origin
Journal #
Period
Year
Entered Amount
Entered Currency
GL Amount
Source
Batch #
Transaction Date
Remark
Entered By

Double-click a journal entry to display Journal Entry Trailers, which allows you to view journal entry line items.