Cash Balance Inquiries

Each level of cash balance control has a corresponding inquiry page where amounts are tracked and may be used for editing if maintenance records are established for that feature.

The Cash Balance Pool page is used to track Cash Balances at the Pool level (that is, Fund Type level) if the Parameter Value is set to True for CBAL_POOL on the Application Parameters (APPCTRL) page. The page is used to edit cash availability if the Balance Control on Cash Balance Summary Maintenance is set to Pool.

There is no Cash Balance Pool Maintenance page, so controls for what amounts to use in calculating Adjusted Cash Balance, a minimum, and an error severity come from the Cash Balance Summary Maintenance (CBALS) page. Therefore, different Funds in a Fund Type can have a different set of controls, but all share the same aggregated amounts.

The Cash Balance Summary page displays current balances for cash tracking amounts for a Fund. Settings for control level and for what amounts to use in calculating Adjusted Cash Balance come from the Cash Balance Summary Maintenance (CBALS) page.

The Cash Balance Detail page displays current balances for cash tracking amounts for a Fund and Sub Fund combination. Settings for control level and for what amounts to use in calculating Adjusted Cash Balance come from the Cash Balance Detail Maintenance (CBALD) page.

The layout and fields for each page are very much the same. COA fields change, as do the Related Pages. Only one set of field definitions is given. COA fields are not defined unless they have a special property.

The following is a list of the errors that come from cash balance control. Each is governed by the Cash Balance Error Severity setting.

A2984 - Adjusted Cash Balance will become less than the Cash Balance Minimum for %p and %p. The modification or cancellation caused a reduction in the Adjusted Cash Balance for the Fund and Sub Fund so that the Available Cash Balance is now negative. The transaction function was allowed because a correction of this type should be permitted to correct any incorrectly recorded revenues or cash on the Cash Balance Detail Query.
A2985 - Adjusted Cash Balance will become even less than the Cash Balance Minimum for %p and %p. The modification or cancellation caused a reduction in the Adjusted Cash Balance for the Fund and Sub Fund so that the Available Cash Balance is even more negative. The transaction function was allowed because a correction of this type should be permitted to correct any incorrectly recorded revenues or cash on the Cash Balance Detail Query.
A3253 - Adjusted Cash Balance will become less than the Cash Balance Minimum for %p. The modification or cancellation caused a reduction in the Adjusted Cash Balance for the Fund Type so that the Available Cash Balance is now negative. Values for both amounts came from using the Fund's settings on the Cash Balance Summary Maintenance Page, as the two amounts do not exist on the Cash Balance Pool Query. The transaction function was allowed because a correction of this type should be permitted to correct any incorrectly recorded revenues or cash on the Cash Balance Pool Query.
A3254 - Adjusted Cash Balance will become even less than the Cash Balance Minimum for %p. The modification or cancellation caused a reduction in the Adjusted Cash Balance for the Fund Type so that the Available Cash Balance is even more negative. Values for both amounts came from using the Fund's settings on the Cash Balance Summary Maintenance Page, as the two amounts do not exist on the Cash Balance Pool Query. The transaction function was allowed because a correction of this type should be permitted to correct any incorrectly recorded revenues or cash on the Cash Balance Pool Query.
A631 - Adjusted Cash Balance will become even less than the Cash Balance Minimum for %p. The modification or cancellation caused a reduction in the Adjusted Cash Balance for the Fund so that the Available Cash Balance is even more negative. The transaction function was allowed because a correction of this type should be permitted to correct any incorrectly recorded revenues or cash on the Cash Balance Summary Query.
A630 - Adjusted Cash Balance will become less than the Cash Balance Minimum for %p. The modification or cancellation caused a reduction in the Adjusted Cash Balance for the Fund so that the Available Cash Balance is now negative. The transaction function was allowed because a correction of this type should be permitted to correct any incorrectly recorded revenues or cash on the Cash Balance Summary Query.
A2986 - Transaction amount exceeds available cash balance for %p and %p. The Amount on the Transaction exceeds the Available Cash Balance.
A632 - Transaction amount exceeds available cash balance for %p. The Amount on the Transaction exceeds the available Cash Balance.

Field Name	Field Description
Sub Fund	A special value exists for this field when Sub Fund is not being used to define a set of cash balance rules or track amounts – BLNK.
Cash Balance	The total balance of all cash accounts defined for the Fund and Sub Fund combination on the BSA tab of the Edit Cash Balance Detail Maintenance page.
Adjusted Cash Balance	A calculated amount using the ‘include amount’ indications set on the applicable Detail or Summary Detail Maintenance page and the Cash Balance. This amount gives a total before applying any Cash Balance Minimum. For pooled cash, this amount is calculated at the time of transaction editing.
Cash Balance Minimum	An optional minimum amount that should be kept in reserve.
Available Cash	The calculated net result after applying any Cash Balance Minimum to the Adjusted Cash Balance. It is this amount when calculated during transaction processing that is evaluated and an error of the defined severity is issued.
Pending Increase Non Cash Pending Decrease Non Cash	This pair of amounts on the inquiry pages and ‘include amount’ indications of the maintenance pages track and optionally include in the cash availability editing amounts that are approaching cash but are currently in workflow. Posting Code settings determine what Posting Codes are these amounts but Billed Earned Revenue (R002) and Accrued Expenditures (D011) are examples of each, respectively.
Pending Increase Cash Pending Decrease Cash	This pair of amounts on the inquiry pages and ‘include amount’ indications of the maintenance pages track and optionally include in the cash availability editing amounts that have a cash impact but are currently in workflow. Posting Code settings determine what Posting Codes are these amounts but Cash (A001) and Warrants Payable (D007) are example used for both amounts. Here a posting code is not defined as one or the other amount, but the type of update to the account determines the Pending Cash amount.
Accepted Increase Non Cash Accepted Decrease Non Cash	This pair of amounts on the inquiry pages and ‘include amount’ indications of the maintenance pages track and optionally include in the cash availability editing amounts that are approaching cash that have reached the Final Transaction Phase. Posting Code settings determine what Posting Codes are these amounts but Billed Earned Revenue (R002) and Accrued Expenditures (D011) are examples of each, respectively.
Cash Balance Error Severity	The level of error severity to be generated if a posting line should result in the cash balance amount to drop below the minimum cash balance. Valid values are Warning, Overrideable Error, Error, or No Error.
Balance Control	The indication of where the edits should be performed. Valid options are: Pool, Summary and Detail.
Current Balance	This amount is shown only on the BSA tab of the Edit Cash Balance Detail Maintenance page where it is the current balance for the account as seen on the ITD Balance Sheet Detail page. These amounts are summarized up to the Cash Balance amount seen on the three cash inquiry pages.