Making Detailed General Ledger Inquiries

Use the G/L Detail Inquiry screen to display detailed information for transactions listed on the G/L Inquiry screen. 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:

Make a basic general ledger inquiry.

To drill into the detail for a posting specific to a branch, use the View hot key and select Date by Branch by Source.

From the G/L Inquiry screen, use the Detail hot key to display the G/L Detail Inquiry screen.

The system populates the following fields, based on the selected account on the G/L Inquiry screen when you use the Detail hot key:

Field	Description
Account	G/L account to which the listed transactions apply.
Br/Tr	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.
PostDate	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.

Use the View hot key to display a breakdown of the selected transaction. Depending on the type of original transaction, different screens display in a view-only mode, for example, the Journal Entry, A/P Entry, or the Purchase Order Entry screen.

From the view-only screen that displays, use the Alt-~ (tilde) hidden hot key to display a list of all the postings that transaction generated on the G/L Postings Viewing screen.

You can also use the Edit hot key to edit the selected 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.

Press Esc to exit the screen.

More Options for Making Detailed General Ledger Inquiries

The G/L Detail Inquiry screen also offers these options:

Use the Currency Exchange ($) hot key to view the information in a different currency.

Field	Description
Display Currency	Enter the currency in which to display the G/L inquiry information.
Calculate Exchange	Enter the date whose exchange rate you want to use to calculate the values in the new currency.

For more information about this hot key, see Foreign Exchange Rates Overview.

To graph your inquiry results using EIS:

Make a detailed inquiry.
Use the Graph hot key to display the G/L Inquiry Graphing screen.
In the As of Date field, enter the date from which you want to graph data.
In the Time Period field, press F10 and select the period of time for which you want to graph data. For example, quarterly or yearly.
In the Number of Periods field, enter the number of periods to include in the graph.
In the Title for Graph field, enter the title you would like to display with the graph.
In the Type of Graph field, press F10 and select the type of graph you want to create.
Use the Begin hot key to graph the data.