Making Basic General Ledger Inquiries

Use the G/L Inquiry window to display a summary of the posting for any general ledger account. This window displays line items from oldest to newest and in the system's default currency.

To make a basic general ledger inquiry:

  1. From the G/L menu, select G/L Inquiry to display the G/L Inquiry window.

  2. In the Account field, enter or select the general ledger account whose activity you want to view.

  1. In the Branch/Territory field, enter or select the branch or territory whose account you want to view.

  2. In the Subledger field, enter the subledger of the account whose activity you want to view and press Enter.

If the account you selected in the Account field does not contain subledgers, this field is disabled. Leave this field blank to view the activity for all subledgers in the account.

  1. Do one of the following:

Account Type

Procedure

Balance Sheet account

In the Start Date field and the End Date field, enter the first date and the last date in the range you want to view, respectively. For example, if you want to view general ledger information for January 2004, type 01/01/04 in the Start Date field and 01/31/04 in the End Date field.

If you do not enter a date in the Start Date field, the balance displayed when you click Update is the total balance for the account since its inception. Enter a start date and an end date to establish a range for which to display the balance. Leave the Start Date field blank to display a true historical account balance.

Income Statement account

In the Fiscal Year field, enter the fiscal year to display the system displays the postings for the first day of the fiscal year until the last posting in that fiscal year.

  1. Click Update to display the following information about the account:

Field

Description

Source

The origination of the transactions represented by each line item, for example, purchasing or payables.

Post Date

The date the specified source posted activity to the account.

Debit

The amount of debit activity associated with the source.

Credit

The amount of credit activity associated with the source.

Balance

The running total of the activity posted to the account.

More Options For Making a Basic General Ledger Inquiry

The G/L Inquiry window also offers these options to process or view different information about a transaction:

To...

Select this menu option...

print the General Ledger Report

File > Print

The General Ledger window displays.

make a detailed General Ledger Inquiry

File > View Detail

The G/L Inquiry Detail window displays.

display a graph of the transaction information. This option only works if you have the Eclipse EGRAPH companion product.

Options > Graph

The Graph Options window displays.

compare the percentage of difference between transaction amounts for two dates

Options > G/L Comparison

The G/L Inquiry Comparison window displays.

view related subledger accounts

Options > Show SubLedgers

Displays the subledger information in the G/L Inquiry window.

inquire about subledger account activity

Options > Subledger Inquiry

The G/L SubLedger Inquiry window displays

view general ledger information by branch, sorted by source

Change View > Date by Branch by Source

See Also:

Foreign Exchange Rates Overview

G/L Reports Overview