General Ledger Inquiry allows you to view transactions for a date or date range, a batch code, or a journal control number. This will include all transactions that affect the general ledger, including DSRs, AP Invoices, Manual Checks, Manual Payments, Payroll, Inventory, and General Journals. It also allows you to see all of the transactions in a particular GL account. You might use GL inquiry to quickly check the activity of a GL account on a particular date or during a particular time period.
Access the screen under the Inquiry menu:
Note: You will be able to inquire on any GL transaction for the current year, or for a past year if that year has not yet been closed using the Close Year feature.
Enter the criteria for the GL entries you wish to display; you must specify at least one of the following options:
Entity # Enter an entity number, or leave blank for all.
From and To Dates Enter a range of dates between which the journal transactions must fall. The dates are inclusive; for example, you can specify 10/1/09 to 12/1/09 to see all of the journal entries made on or after October 1st and on or before December 1st.
Batch Code Enter a batch code number, or select one from the list. You should filter by batch code when inquiring on summary postings (see Summary vs. Detail Postings).
Journal Ctrl # Enter a journal control number, or select one from the list. For a list of the batch code and journal control number prefixes, see the Batch Code and Journal Control Number Prefixes Table.
GL Acct # Enter a From and To General Ledger account number or leave blank to include all.
After specifying inquiry criteria, click Get Records and the detail grid will be populated with the returned data.
Get Records Generates the inquiry and displays all found data in the detail area.
Find in Results Lets you search for particular records through a series of filters.
Expand Opens all detail area items to show their sub-parts (like clicking all the + signs) when the grid has been grouped by a column.
Collapse Closes all detail area items to show only summary parts (like clicking all the minus signs) when the grid has been grouped by a column.
Once you have data in the detail area, you can easily filter and sort the inquiry screen to find the data you want (see Finding Items).