Supplier Ageing

Most companies deal with multiple suppliers offering multiple credit terms. Tell me more

Select the “Supplier Ageing” link under the “Reports – Payables Management” business component.

The “Supplier Ageing” 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 supplier ageing report. 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	Use the drop-down list box to select the code identifying the business unit for which you want to view the supplier ageing report. All the business units that are in the “Active” status and have been mapped to the selected company will be available for selection.
Finance Book	Use the drop-down list box to select the code identifying the finance book for which you want to view the supplier ageing report. All the finance books that have been deployed in the company will be available for selection. The system displays “All” by default on launch of the page.
Created At	Use the drop-down list box to select the organization unit in which the supplier documents have been created. All the organization units in which the “Payables Management” business components have been deployed will be available for selection.
Currency Option	Use the drop-down list box to select the type of currency in which you want to view the supplier ageing report. You can select from “Base”, “Transaction” or “Parallel Base”. The system displays blank by default on the launch of the page.
Currency	Use the drop-down list box to select the code identifying the currency in which you want to view the supplier ageing report. 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.
Supplier Group	Use the drop-down list box to select the supplier group for which you want to view the supplier ageing report. All the supplier group codes that have been defined for the selected group type will be available for selection.
Supplier Code From	The starting code in the range of codes identifying the suppliers for whom you want to view the ageing report (Alphanumeric, 18).
Supplier Code To	The ending code in the range of codes identifying the suppliers for whom you want to view the ageing report (Alphanumeric, 18).
As on Date	The date on which you want to view the supplier ageing report (Date Format). The system date is displayed by default on launch of the page.
Include Prepayments	Use the drop-down list box to select whether you want to include the prepayments details in the supplier ageing report. You can select from “Yes” or “No”. The system displays “Yes” by default on the launch of the page.
Language	Use the drop-down list box top select the language in which you want to view the supplier ageing report. You can select “English”.
Report ID	Select the check box to print the report ID in all the pages of the report.
Entry Point Page	Select the check box to print the entry point page on the first page of the report.

Enter the following fields in the “Ageing Analysis” multiline:

Bucket Range	A unique code identifying the bucket range to which the supplier ageing belongs (Alphanumeric, 20).
Days From	The starting day in the range of days for which you want to view the supplier ageing report (Date Format). The day entered in this field must be before the day entered in the “To” field.
Days To	The ending day in the range of days for which you want to view the supplier ageing report (Date Format). The day entered in this field must be before the day entered in the “To” field.

Click the “View Supplier Ageing” pushbutton to view the supplier ageing report.

The system generates and displays the ageing report of the supplier based on the search criteria entered.

Supplier Ageing – An overview

In view of the huge volume of transactions, it is important for the company to be able to consolidate its’ payable transactions in a report to forecast and plan its cash flows and analyze the dues to its’ suppliers. It is also critical for the company to monitor payments that are long over-due to suppliers’ to avoid payment of penalty. This is also to avoid the situation in which relationships have to be severed with its suppliers. The aging report allows dynamic definition of slabs / buckets in terms of which the suppliers’ outstanding can be viewed. A maximum of 9 buckets can be defined and the balances in each time range can be viewed in the transaction currency, base currency as well as the parallel base currency. The report also gives a facility to include / exclude the effect of prepayments.

This page allows you to carry out a search by selecting the company, the corresponding business unit and the corresponding finance book for which you want to view the ageing report. You can also search by specifying the group and a range of codes identifying the suppliers for whom you want to view the ageing report. You can also select the currency option and the currency in which you want to view the ageing report. You can also select the option to include the prepayments in the report. You can also enter the bucket range, the days from and days to. The system retrieves the ageing report based on the search criteria entered.