One View G/L Inquiry (P09219)

Access the One View G/L Inquiry application (P09219) in the Accounting Inquiries (G0914) menu. You can use One View G/L Inquiry to analyze General Ledger transactions. One View G/L Inquiry uses the One View G/L Inquiry (F0911-F0901-F0006) business view (V09219), which includes columns from the Account Ledger table (F0911), Account Master table (F0901), and Business Unit Master table (F0006). This application provides a wealth of data and is extremely flexible in the types of reports that can be generated. Choose from more than 300 columns in the business view to analyze your G/L by subledger (for example, customer, supplier, asset, or item), business unit, company, account, account ranges, or business unit and account category codes. In addition to high-value reports delivered with this application, you can use this application to create reports for many business purposes. Examples are Expense Account Analysis, Revenue Account by Business Unit, Inventory Accounts by Region, a full analysis of any selected G/L Transactions, and many others. Associated descriptions are provided so you can choose to view codes, descriptions, or both. Examples include company, customer, supplier, asset, item, category code, document, batch, ledger, subledger, subledger type, currency, posting code, and many others.

Several predefined reports are delivered with this application. They are G/L Transactions by Customer and Business Unit, G/L Transactions by Account, Business Unit Detail, and G/L Transactions Analysis. With these delivered reports you can view your transaction amounts for your customers and business units. You can also view them by accounts or business units by date or document type. The G/L Transactions Analysis interactive report provides an even broader view of your transactions by providing multiple views of the same data broken down by business unit, object account, subledger, document type, posted or unposted, and account.