Customer Account Balance Analysis

This report enables you to analyze in depth your customer account open balances. This analysis of your open amounts can be done by many attributes. These attributes include credit manager, collection manager, region (customer master category code 1), payor, customer, periods, aging categories, and gross vs. open amounts. View the data for multiple companies or business units for select periods to see how your accounts receivable staff and process are performing.

The Aging check box must be selected and an As Of Date entered (if it is blank, then today's date will be used) on the application header to have the data calculated correctly for this report.

This report gives you complete control over the information shown in the graphs and table by providing filtering by Region (customer master category code 1). This report contains the following components:

• Overdue Amount by Collection Manager (gauges)

• Open Amount by Region (pie chart)

• Top 10 Payors by Open Amount (horizontal bar graph)

• Top 10 Customers by Open Amount (horizontal bar graph)

• Aging Open Amount by Collection Manager (horizontal bar graph)

• Open Amount by Credit Manager (pie chart)

• Gross Amount vs. Open Amount by Period (bar graph)

• Aging Open Amount by Customer (horizontal bar graph)

• Open Invoices (table)

The Aging Open Amount by Customer 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
Application called	Customer Ledger Inquiry (P03B2002)
Form called	W03B2002A
Version called	ZJDE0001

The following report was generated by activating Aging and As Of processing with a date of June 30, 2011. The data selected was a large group of customers for company 00001 for periods four through six of fiscal year 11. It shows a broad view of the Customer Account Balances across the periods.