Overview
The Available Balances Lookup displays total budget, actuals and encumbrance balances for an account by object code. If the Account is a Project To Date Account the amounts are inception to date. The Chart Code on this lookup will default when DEFAULT_CHART_CODE and DEFAULT_CHART_CODE_METHOD parameters are populated.
- Account is required.
- Supported Wildcards: The following wildcards are available:
- | (pipe)- indicates Or. For example, using 1031400|6044900 returns results for both account 1031400 and 6044900
- .. (two periods) - indicates a range. For example, using 1031400..6044900 returns results for accounts 1031400 and 6044900 and all accounts in between.
- 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.
- 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.
- Transfers: Choosing Exclude will not display object codes with object subtypes in parameter TRANSFER_SUB_TYPES
- Balance Sheet: Choosing Exclude will not display object codes with Basic Accounting Categories (attribute of Object Type) in parameter BALANCE_SHEET_CATEGORIES.
- Indirect Cost: Choosing Exclude will not display object codes with Object Levels in parameter INDIRECT_COST_OBJECT_LEVELS.
- Prior Year Balances:
- Choosing Include will Include:
- Prior years beginning balance (Balance Sheet object codes) and Cumulative Beginning Balances (Income Statement object codes for Inception to date accounts),
- Prior year's activity and
- Current year's activity
- Prior year encumbrances will be excluded when the Beginning Encumbrances Loaded Indicator is Yes. This flag should be set on the System Options table after encumbrances are loaded for the new year.
- Displays in the current fiscal year when the Beginning Balances flag on System Options for that fiscal year is No.
- When Beginning Balances are set to Yes, the toggle will no longer display until the following year.
- The toggle only works with the current fiscal year, if the toggle is set to include and the fiscal year is a prior fiscal year, an error will be returned.
- When drilling into the General Ledger Balance screen, the Fiscal Year displayed will be the current year, however, the results include both the current and prior year. Drilling into the General Ledger Entry screen will display the correct Fiscal Year for the included transactions.
- To make it display prior to the next year, you can edit "today" in the University Date table and set the Fiscal Year to the next fiscal year and the current period to 01. You may also need to run clearCacheJob.
- Choosing Include will Include:
- Consolidation Option:
Drill Down
From the Available Balances you can drill into:
- General Ledger Balance
- GL Entry Lookup
- 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.