One View Account Balance Inquiry (P09217)

Access the One View Account Balance Inquiry application (P09217) from the Accounting Inquiries (G0914) menu. Use One View Account Balance Inquiry to report on account balances. One View Account Balance Inquiry uses the One View Account Balance Inquiry business view (V09217), which includes columns from the Account Balance table (F0902), F0901, and F0006. This application provides much data and is extremely flexible in the types of reports that can be generated. Choose from more than 250 columns in the business view to report on your Account Balances by fiscal year, period, business unit, company, account, account ranges, business unit and account category codes, and subledger (for example, customer, supplier, asset, or item). In addition to high-value reports delivered with this application, you can use this application to create reports for many business purposes. Examples are A/P or A/R Trade Account Balance by Business Unit analysis, Budget versus Actual by Company Comparisons, Quarterly Expense Account Balance review, analysis of any number of account balances, and many others. Associated descriptions are provided so you can choose between viewing codes, descriptions, or both. Examples include company, business unit, account, ledger type, subledger type, category codes, currency, and many others.

Several predefined reports are delivered with this application. They are G/L Account Balances, Q1 Sales by Store within a Region, Budget vs. Actual by Business Unit, Trial Balance, Account Balance Trend, Gross Profit, and Account Balance Analysis. Using these delivered reports, you can see how your account balances are spread across subledgers, category codes, and stores; you can analyze your budgets versus actual across multiple criteria; and you can see trends for account balances and see the data that drives the charts and graphs. The Account Balance Analysis report provides an even broader view of your transactions by providing multiple views of the same data broken down by company, business unit, category codes, object account, and subledgers. It also shows budget versus actual information.