Balances by Consolidation

Note: For general information about entering lookup criteria, interpreting dollar accumulators, drilling down into inquiries to see more detail, and including or excluding pending entries, see GL Inquiries: Basic Information.

This inquiry displays account balances at the highest reporting level (the consolidation level) and allows you to drill down to the next reporting level. You can continue this drill down process to arrive at the actual e-doc where the transaction began (assuming the transaction originated with a KFS e-doc and not from an external system). You must specify the chart and the account number you wish to view in the report criteria window. The fiscal year defaults to the current fiscal year, but may be changed. You may also include a sub-account if you are interested in that level of detail.

The Consolidation option defaults to display an aggregate total for all sub-accounts for the selected chart and account number. If you select the Detail option, the report displays the balances for each sub-account for the chart and account number selected. The Include Cost Share Sub-Accounts default is to exclude activity on Cost Share sub-accounts. If you wish to view activity on these special sub-accounts select the Include option. The Include Pending Ledger Entry option provides the user with the ability to include all pending entries, no pending entries, or only those pending entries that are fully approved. Cancelled and disapproved pending entries are not pulled into the balance inquiry results.

The drilldown pattern of this inquiry is as follows:

1.     Balances by Consolidation

2.     Balances by Level

3.     Balances by Object

4.     General Ledger Balance

5.     General Ledger Entry

6.     E-Doc

More:

Lookup Criteria

Search Results