User Tools

Site Tools


Sidebar

Table of Contents

finance:inquiry:generalledgerinquiry:generalledgerinquiry

General Ledger Inquiry - FIN5000

Finance > Inquiry > General Ledger Inquiry > General Ledger Inquiry

This tab is used to perform the following:

  • Review the balances on individual accounts or groups of accounts.
  • View the processed, current period, next period, or any combination of these.
  • View a detailed listing of the account or just the balances in a summary view of the account.
  • View records by page or by printing.
  • After a deferred check is printed, the check number description will display “PAYABL” in the expenditure account. The numerical check number is displayed in the accounts payable account for the accounting period in which the check was printed.

Perform a general ledger inquiry:

The default Retrieve function only displays active account codes.

❏ Select any of the following fields to include in the inquiry:

❏ Select Include Inactive Accounts to display inactive account codes in the inquiry.

Field Description
ProcessedSelect to include account balances as of the end of the last reporting period.
Current PeriodSelect to include account balances as of the current accounting period.
Next PeriodSelect to include account balances as of the next accounting period.
Show Details Report will display Transaction Details

Select to display and print a detailed list of all transactions. If not selected, a summary for all accounts is displayed and printed:

Totals - The totals of all accounts with the selected account code component are displayed.
Balance Accts Only - The totals for only the accounts that are selected in the account code mask are displayed.

Include soft encumbrances when POs existSelected, by default, to include general ledger transactions when purchase orders exist. If not selected, the soft encumbrances (where the associated purchase order has been created) are not displayed.
Exclude Objects 61XXSelect to exclude all object codes that begin with 61.
Include Inactive AccountsSelect to include inactive account codes in the inquiry.

❏ Under Description, select one of the following:

ReasonSelect to display the reason for each account transaction.
Vendor NameSelect to display the vendor name for each account transaction. If selected, the requisition number is not displayed.

Note: Descriptions are only displayed for line items that are checks (CK) or purchase orders (EN). The Description option only works if the Show Details option is selected.

Account Code

Type an account code for each of the account code components or click Ellipsis Icon to select a code.

Masked account code components (Xs) will retrieve any digit in that account code position.

For example, the account mask XXX-XX-63XX-XX-XXX-XXXXXX would pull all grant expenditure amounts for supplies.

Encumbrances for student activity fund accounts are displayed in class 2XXX object codes.

❏ Click Retrieve to process the inquiry based on the values selected. The results are displayed.

General ledger description notes

Note: If the number of records being retrieved is more than 20,000 and the Display GL Inquiry Warning field is selected on the Tables > District Finance Options > Finance Options tab, the following warning message is displayed: “Report will take longer to generate due to the number of rows being retrieved for the Account Code selected.”

  • Click Yes to continue processing the inquiry.
  • Click No to return to the General Ledger Inquiry tab.

Review the report.

Other functions and features:

ResetClick to clear the account code and return to the default setting (all Xs).
finance/inquiry/generalledgerinquiry/generalledgerinquiry.txt · Last modified: 2022/08/02 16:08 by emoreno