Making Detailed General Ledger Inquiries

Use the G/L Detail Inquiry window to display detailed information for transactions listed in the G/L Inquiry window. For example, in addition to post date, debit, and credit information, you can view source and reference information. If you have the EGRAPH companion product, you can graph your inquiry results.

To make a detailed general ledger inquiry:

  1. Make a basic general ledger inquiry.

To drill into the detail for a posting specific to a branch, select Change View > Date By Branch By Source to change the view.

  1. Select the transaction for which you want to view detailed information and select File>ViewDetail to display the G/L Detail Inquiry window.

The system populates the following fields:

Field

Description

Account

G/L account to which the listed transactions apply.

Branch/Territory

Branch or branches to which the listed transactions apply.

Subledger

An indicator of the existence, if any, of related subledger accounts. If related subledger accounts exist, then ALL displays in this field. If you have established the parameters to allow for subledgers, but none have been created, then the field is blank. If you have not established subledgers, then N/A displays in this field.

Source

Posting source of the transaction.

Reference #

Number assigned to the transactions posted to the selected account for the displayed date, such as J1001380.001.

Post Date

Posting date for the transaction.

Debit

Amount of the transaction, if it is a debit.

Credit

Amount of the transaction, if it is a credit.

  1. From the File menu, select View to display a breakdown of the selected transaction.

Depending on the type of original transaction, different windows display in a view-only mode, for example, the Journal Entry, A/P Entry, or the Purchase Order Entry windows.

From the view-only window that displays, type Alt+ ~  (tilde) to display a list of all the postings that transaction generated in the G/L Postings Viewing window.

You can also right-click the transaction and select Edit to edit the transaction.

All authorization rules apply when entering these transactions in edit mode. If you do not have authorization to view the particular transaction type, you are automatically brought into the ticket in view only mode. If the transaction is in a closed G/L period the user will not have the ability to edit and will be brought into view only mode. If the transaction is a purchase order and has already been paid on a disbursement the user will be put into view only mode.

  1. Save your changes and exit the window.

See Also:

Foreign Exchange Rates Overview

G/L Reports Overview