Supplier Account Balance Analysis
This report enables you to analyze in depth your supplier account balances. This analysis of your open amounts can be done by many attributes. These attributes include approver, region, business unit, document type, due date, payee, supplier, periods, and gross vs. open amounts. View the data for multiple companies or business units for select periods to see how your accounts payable staff and process are performing.
This report gives you complete control over the information shown on the graphs and table by providing filtering by Region (address book category code 1). This report contains the following components:
Open Amount by Approver (gauges)
Open Amount by Region (pie chart)
Top 10 Payees by Open Amount (horizontal bar graph)
Top 10 Suppliers by Open Amount (horizontal bar graph)
Open and Discount Amount by Business Unit (horizontal bar graph)
Open Amount by Document Type (pie chart)
Gross and Open Amount by Period (bar graph)
Open Amount by Due Date (bar graph)
Open Vouchers (detail table)
The Open Vouchers table component contains drill back functionality as described in the following table:
Functionality |
Value |
---|---|
Table column containing drill back link |
Doc Number |
Table columns passed to application |
Doc Number, Doc Type, Doc Company |
Application called |
A/P Standard Voucher Entry (P0411) |
Form called |
W0411G |
Version called |
ZJDE0001 |
The following report was generated by activating As Of processing with a date of June 30, 2011. The data selected was a large group of suppliers, for company 00001 for periods four through six of fiscal year 11. It shows a broad view of the supplier account balances across the periods.