Generating Supplier Ageing Report

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

The “Supplier Report” page appears.

Enter the following fields:

Finance Book	Use the drop-down list box to select the finance book based on which the supplier ageing report must be generated. The system displays the “All” option and other finance books as defined in the “Organization Setup” business component. The system displays “All” by default.
Date	The date for which the supplier ageing report must be generated (Date format). Mandatory. By default the system displays the current system date.
Supplier Group	Use the drop-down list box to select the supplier account group for which the supplier ageing report must be generated. The system lists the option “ALL” along with all the supplier account group codes as defined in the “Account Group” business component. The system displays “ALL” by default.
Supplier Name	The name of the supplier for which the report must be generated (Alphanumeric 120). You can enter the supplier name in full or specify it partially using the “*” character. The system leaves the field blank by default.
Supplier Code From	The starting supplier code, in the range of supplier codes, from which the supplier ageing report must be generated (Alphanumeric, 16). You can enter the supplier code in full or specify it partially. Help facility available.
Supplier Code To	The ending supplier code, in the range of supplier codes, till which the supplier ageing report must be generated (Alphanumeric, 16). You can enter the supplier code in full or specify it partially. Help facility available.
Transaction Currency	Use the drop-down list box to specify the transaction currency code of the supplier group. Only transactions made in that currency will be displayed in the report. The system lists the option “ALL” along with all the currency codes mapped to the login organization unit in the “Organization Setup” business component. The system displays “ALL” by default.
Display Currency	Use the drop-down list box to specify the type of currency in which the report must be generated. The system lists the following options Transaction Currency – Select this option to generate the values in transaction currency Base Currency – Select this option to generate the values in base Currency The system displays the field as “Transaction Currency” by default.
Account Type	Specify the account type for which the report is to be generated. Check any of the following check boxes, to specify the account type. Payables - Check this option if the report must be generated with only payables transactions Prepayment – Check this option if the report must be generated with only prepayment transactions Deposit – Check this option if the report must be generated with only deposit transactions The system displays all of the check boxes mentioned above as checked.
Supplier Payment Mode	Use the drop-down list box if you wish to generate the ageing report based on the pay mode as specified in the Supplier Master. Based on the set options defined for the installation, all he paymodes defined, along with the option “All” is listed in this field. Note that you are required to contact Ramco Support to enable your installation to list all the pay modes along with “All”, if you require such an option to be listed in this field.

Check the “Display Suppliers with Net Debit Balances” check box, to generate a report with only the list of suppliers with negative balances.
Check the “Suppliers with Unadjusted Debit Documents” check box to generate a report with the list of suppliers having unadjusted debit documents only.

Note: The unadjusted or unpaid amount does not include payment or adjustment transactions made after the specified date.

Note: Ensure that "Supplier Code To” is greater than or equal to "Supplier Code From".

The system generates the supplier ageing report for all the suppliers specified by the range entered here.

Report Type

Use the drop-down list box to specify the type of supplier ageing report to be generated. The system lists the following options:

Detail-Select this option to generate a detailed supplier ageing report
Detail – Line Level – Select this option to generate a detailed line level supplier ageing report.
Summary-Select this option to generate a summary of the report

By default the system sets the field as “Summary”.

Sort Option

Use the drop-down list box to specify the order in which the report must be generated.

The system lists the following options:

Supplier Name - Select this option to generate the supplier ageing report based on supplier name in alphabetical order within the Supplier Group
Supplier Code – Select this option to generate the supplier ageing report based on supplier code in descending order within the Supplier Group

The system displays the field as “Supplier Code” by default

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