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.

Note: As Of Date must be entered in order for this report to provide accurate information.

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.

Supplier Account Balance Analysis. Supplier Account Balance Analysis. Supplier Account Balance Analysis.