Account Balance Analysis
This report enables you to do a full analysis of a group of account balances. View the account balances by business unit, company, business unit category code, business unit trend over selected periods, budget vs. actual by business unit, top 10 subledgers, and budget vs. actual by object account. You can select account groupings such as your revenue, expense, or asset accounts to fully analyze them. You can run this report over multiple companies and business units or over only a specific business unit. Do it for a year, a quarter, or any number of periods.
This report gives you complete control over the information shown in the graphs and table by providing filtering by period and business unit category code 1. This report contains the following components:
Account Balance by Business Unit (gauges)
Account Balance by Company (pie chart)
Account Balance by BU Category Code 1 (pie chart)
Business Unit Trend (line graph)
Budget vs. Actual by Business Unit (horizontal bar graph)
Top 10 Subledgers by Account Balance (bar graph)
Budget vs. Actual by Object Account (horizontal bar graph)
Account Balance Detail (table)
The Account Balance Detail table component contains drill back functionality as described in the following table:
Functionality |
Value |
|---|---|
Table column containing drill back link |
Object |
Table columns passed to application |
Object, Company, Ledger Type |
Application called |
Trial Balance by Object (P09214) |
Form called |
W09214A |
Version called |
ZJDE0001 |
The following report was generated by selecting the A/P Expense accounts for periods four through six of fiscal year 2011 with ledger type of AA and a comparison ledger of BA for companies 00001 and 00200 with business units 3, 5, 9, M10, and M30. It shows a broad view of the A/P Expense account balances and budgets across the periods.
