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.
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.
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).
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.
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.

Note: If the As on Date is earlier than the system date then the check box ‘ Include Post dated Payments’ can not be checked.

If the As on Date is earlier than the system date and the check box ‘Include Post Dated Payments’ is not checked , then all the Post Dated Documents with pay date equal to or earlier than the As on Date will alone be considered for the report.. The Post Dated documents with pay date greater than the As On Date will not be considered.

Report Option	Use the drop down list to select the repot option for which you want to view the Supplier ageing Report. You can select from ‘Due Date’ and ‘Transaction Date’. The system displays “Due Date” by default on the 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.
Include Post Dated Receipts/ Payments	Check the box to include the Post Dated Transactions

Note: When the ‘Include Post dated Payments’ check box is checked, all the Post Dated Transactions with the pay date greater than ‘As on Date’ will be considered for the report..

When the ‘Include Post Dated Payments’ check box is not checked then post dated documents with pay date as equal to or earlier than the As on date’, whether processed or unprocessed would be treated as normal payment transactions and not as post dated transactions. Post Dated Transactions with Pay Date greater than the ‘As on Date’ will not be considered in the report.

Detailed Report	Check this check box to extract the balances for the buckets along with transaction details
Include Deposits	Use the drop-down list box to specify whether you want to include the deposit account 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.

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. The facility to include the effect of post dated checks issued is also available. . If certain transactions which were created as Post dated and are Overdue and Unprocessed are considered in the report tthen remarks for the same will also be displayed in the report.

This page allows you to carry out a search by selecting the company 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 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 select the option to include the effect of post dated transactions. 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.