Making Basic General Ledger Inquiries

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

To make a basic general ledger inquiry:

From the G/L menu, select G/L Inquiry to display the G/L Inquiry screen.
In the Account field, do one of the following and then press Enter to select the general ledger account whose activity you want to view:

Press F10 and select from a list of accounts.
Enter a partial account name.

In the Br/Tr/All field, enter the branch, branches, or territories whose account you want to view and press Enter. One of the following occurs:

If you select...	the system displays...
a Balance Sheet account	the postings using the current date in the End Dt field. If you do not enter a date in the Start Dt field, the balance displayed 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 Dt field blank to display a true historical account balance.
an Income Statement account	a prompt to enter the fiscal year for which you want information. After you enter the year, the system displays the postings for the first day of the fiscal year until the last posting in that fiscal year.

Note: If you use either the Account hot key to access the Account field, or the Branch hot key to access the Br/Tr/All field, you can press the Tab key, the Shift-Tab key combination, or the Arrow keys to move the cursor to other fields in the header area of the G/L Inquiry screen. After changing the header information, press Enter to display the account information.

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

Leave this field blank to view the activity for all subledgers in the account. If the account does not have subledgers defined, N/A displays in this field and it is not available.

The following information displays:

Field	Description
Br	The branch to which the posting applies. This field is available if you are viewing the postings by Date by Branch by Source. Use the View hot key to view the branch. If you select Date by Branch by Source, you can drill into the detail of a posting for the branch using the Detail hot key.
Source	The origination of the transactions represented by each line item, for example, purchasing or payables.
PostDate	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.

Use any of the following hot keys to process or view different information about a transaction:

Hot Key	Function
Currency Exchange ($)	Displays information in a currency different than the company's base currency and the date whose exchange rate you want to use to calculate the values in the new currency.
Prt	Prints a General Ledger Report.
Detail	Displays the G/L Detail Inquiry screen. For more information about this screen, see Making Detailed General Ledger Inquiries.
Account	Moves the cursor to the Account field where you can change the account name without having to exit the screen.
Dates	Based on the account type you are viewing, this hot key does the following: If the account is a balance sheet, the Dates hot key moves the cursor to the End Dt field, where you can change the current date for the information displayed. From there, press the Up Arrow key to move the cursor to the Start Dt field, where you can enter a starting date and view invoices for a specific date range. If you do not enter a date in the Start Dt field, the balance displayed 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 Dt field blank to display a true historical account balance. If the account is an income statement, the Dates hot key displays a prompt, where you can enter a different fiscal year for the displayed account. After you enter the year, the system displays the postings for the first day of the fiscal year until the last posting in that fiscal year.
Branch	Moves the cursor to the Br field where you can change branch information without having to exit the screen.
Graph	Displays a graph of the transaction information. This hot key only works if you have the Eclipse EGRAPH companion product.
G/L Comp	Displays the G/L Inquiry Compare screen, where you can compare the percentage of difference between transaction amounts for two dates. For more information about this screen, see Comparing General Ledger Accounts.
Show SubLedgers	Based on the setting in G/L Subledger Maintenance, this hot key allows you to view related subledger accounts.
View	Changes the sort order of the general ledger data. Select Date by Source to list the account postings by the date they were posted and then by the source. Select Date by Branch by Source to list the account postings by date, by the applicable branch, and then by source. If you select Date by Branch by Source, you can drill into the detail for a posting for the branch using the Detail hot key, even if you are viewing postings for all branches.