Understanding Trial Balance Inquiries

To review trial balances for accounts quickly and in a variety of sequences, use the trial balance inquiry programs. These inquiry programs display summarized information from the F0902 table and provide access to more detailed information.

The inquiry program that you choose depends on how you want to review the account and what information you want to see. This table describes the trial balance inquiry programs:

Inquiry

Description

T/B/ Ledger Comparison (P09210A)

This program displays account balances within a specific business unit or balances for a specific account.

T/B by Object Account (P09214)

This program displays account balances across all business units and displays any account numbering discrepancies. For the program to be useful, accounts must be numbered consistently across all business units.

T/B by Company (P09216)

This program displays account balance information across business units for a single company.

T/B by Subledger (P09215)

This program displays account balance information by subledger.

All four programs have a processing option that enables you to review account balances as of a specific date, instead of viewing balances only as of the ending date for a period.

If you do not specify a date for the review, the programs identify the current (open) period for the company in the Company Constants table (F0010) and use the period-ending date for that period as recorded in the Date Fiscal Patterns table (F0008).

Note: The P09216 program displays a total only if the inquiring company is out of balance.

The cumulative balance for balance sheet accounts includes the cumulative balance forward for the prior year. The cumulative balance for income statement accounts does not include this amount.