Customer Balance Ageing Analysis

This page allows you to carry out a search and generate a balance ageing analysis report. Tell me more

Select the “Customer Balance Ageing Analysis” link under the “Reports – Receivable Management” business component.

The “Customer Balance Ageing Analysis” page appears.

Enter the following fields in the “Search Criteria” group box:

Company Code	Use the drop-down list box to select the code identifying the company for which you want to view the analysis of the ageing of customer balances. All the companies that are in the “Active” status and have been mapped to the login organization unit will be available for selection.
Business Unit ID	Use the drop-down list box to select the code identifying the business unit for which you want to view the analysis of the ageing of customer balances. All the business units that are in the “Active” status and have been mapped to the selected company will be available for selection.
Group Type Code	Use the drop-down list box to select the type of group to which the customer belongs. All the customer group types that have been defined for the login organization unit will be available for selection.
Customer Group Code From	Use the drop-down list box to select the customer group from which you want to view the balance ageing analysis. All the customer group codes that have been defined for the selected group type will be available for selection.
To	Use the drop-down list box to select the customer group till which you want to view the balance ageing analysis. All the customer group codes that have been defined for the selected group type will be available for selection.
Hierarchy Balance	Use the drop-down list box to select whether you want to view the hierarchy balance during the analysis. You can select from “Yes” or “No”. The system displays “No” by default on launch of the page.
Customer Code From	The starting code in the range of customer codes for whom you want to view the balance ageing analysis (Alphanumeric, 18).
To	The ending code in the range of customer codes for whom you want to view the balance ageing analysis (Alphanumeric, 18).
As on Date	The date on which you want to view the balance ageing analysis report (Date Format). Mandatory. The system date is displayed by default on launch of the page.
Bucket No From	Use the drop-down list box to select the credit bucket to which the balance belongs. You can select from “1” to “9”. The system displays “1” by default on launch of the page.

Note: The credit bucked number selected in this field must be before the number selected in the “To” field.

To	Use the drop-down list box to select the credit bucket to which the balance belongs. You can select from “1” to “9”. The system displays “9” by default on launch of the page.
Currency	Use the drop-down list box to select the code identifying the currency in which the currency balances are available. All the currency codes that have been assigned to the login company will be available for selection. The system displays “All” by default on launch of the page.
Report Currency	Use the drop-down list box to select whether you want to view the ageing analysis report in the transaction currency or the base currency of the company. You can select from “Base Currency”, “Tran Currency” or “Tran and Base Currency”. The system displays “Tran Currency” by default on launch of the page.

Click the “View Customer Balance Ageing” pushbutton to view the report.

The system generates and displays the ageing report of the customer balances based on the search criteria entered. This report can be printed whenever required.

Customer Balance Ageing Analysis – An overview

The balance of a customer increases whenever a credit sale is made. This balance is regularly tracked and recovered from the customer. If a customer does not settle his balances periodically, an aging tool would help in segregating the balances to speed up the recovery. An ageing analysis allows you to generate a report on the number of days the balance has aged for the customer. You can view this report for a type of customer group and customers in a business unit. You can view the report in the base currency of the company, the parallel base currency of the company or in both the base and parallel base currency of the company.

You can carry out a search by specifying a range of customer codes for which you want to retrieve the ageing analysis. You can generate the report for a business unit on a particular date. You can also select the currency in which you want to view the report. You can also view the credit bucket in which the payment would fall.