Understanding Account Ledger and Balance Inquiries

You might need to review detailed transactions and balances for your accounts in different formats and sequences. The online ledger and balance inquiry programs provide information for specific accounts. These programs access either the F0911 table, which contains detailed transactions or the F0902 table, which contains posted balances, or both of these tables. The inquiry program that you choose depends on what you want to review and how you want to see information displayed. This table describes the account ledger and account balance inquiry programs:

Inquiry	Description
Account Ledger Inquiry (P09200)	Displays detailed transactions from the F0911 table.
Account Inquiry by Object Account (P09201)	Displays detailed transactions from the F0911 table using a selected object account, across all business units.
Account Inquiry by Category Code (P09202)	Displays detailed transactions from the F0911 table using one of the category codes that are set up for a government-defined (alternate) chart of accounts.
Account Balance by Month (P0902P1)	Displays monthly net changes and cumulative monthly balances from the F0902 table for each period of the fiscal year. The system includes net posting totals for income statement accounts and balances forward for balance sheet accounts.
Account Balances by Subledger (P092131)	Displays balances and posted amounts from the F0902 table for the current period and for the year-to-date in sequence by subledger and subledger type.
Statutory Account Inquiry (P09218A)	Displays balances from the F0902 table by company or organization structure using one of the category codes that are set up for a government-defined (alternate) chart of accounts.
T/B / Ledger Comparison (P09210A)	Displays balances from two different ledgers in the F0902 table. You can display the calculated comparison or the cumulative balances for each ledger. This program is helpful in comparing budgets to actual amounts.