Overview
The General Ledger Balance lookup shows an account's object code balances for each month of the fiscal year. Similar to some of the other Financials online lookup screens the user can drill down into the balances to view transaction detail and individual documents.
Lookup
- Fiscal Year, Chart Code and Account Number are required fields when using the General Ledger Balance Lookup.
- You can further refine your results by using Sub-Account Number, Object Code, Sub-Object Code, Balance Type and Object Type.
- The following options control the display in the Search Results:
- Consolidation Option:
- Consolidation: Aggregates sub-accounts into the total amount displayed.
- Detail: Displays balances by sub-account and sub-object.
- Exclude Sub-Accounts: Balances display without sub-accounts or sub-object codes.
- Include Pending Ledger Entry:
- No: Displays balances as of the last time the batch ran.
- Approved: Includes fully approved transactions in the balances.
- All: Includes fully approved, enroute and saved transactions.
- Note: Choosing to include all pending ledger entries in a balance inquiry can generate misleading results because saved documents may contain incomplete or unbalanced accounting entries. Choosing to view all pending ledger entries should be done with the understanding that unapproved entries may change drastically prior to actually posting or they may not post at all.
-
Amount View Option: Displays balances for each month (Monthly) and accumulating the balances as you progress through the fiscal year (Accumulate).
- Consolidation Option:
Search Results
The search results contain the following amount fields:
- Beginning Balance Line Amount: The amount in this account for this balance type and object code at the beginning of the selected fiscal year.
- Beginning Cumulative Balance Amount: The cumulative amount in this account for the selected balance type and object code that was carried forward from the previous fiscal year. Displays for Inception to date accounts, such as Contracts & Grants and Plant accounts.
- Account Line Annual Balance Amount: The total amount of activity in this account for the selected balance type and object code across all periods of the selected fiscal year.
- [Month] Balance Amount: The total of all activity for a given accounting period for the selected balance type and object code. These fields are labeled as the month to which they refer (July, August, September, etc.).
Drill down
The drilldown pattern of this lookup is as follows:
- General Ledger Entry
- Financials documents or Labor Ledger Entries
- Document numbers with Origin Code 01 can be drilled into, unless the document type is included in parameter DOCUMENT_TYPES_EXCLUDED (component: Entry).
- Labor Ledger Entries can be drilled into when the Origin Codes associated with labor transactions are included in parameter LABOR_ORIGINATION_CODES.
Comments
0 comments
Please sign in to leave a comment.