Supplier Ageing Report – A summary of the activity

In this activity, you can generate a supplier ageing report to view the payment outstanding to the suppliers as on a given date. The report is generated based on selected parameters such as finance book, date and range of supplier codes.

You can generate either a summary report, or a detailed supplier ageing report in this activity, based on the option setting.

Detail supplier ageing report

The detail supplier ageing report is generated when the “Option” field is set as "Detail".

Report Heading

Aged Payables Trial Balance (Detailed)

Columns Printed

Group Header Details

Currency

Supplier Group

Supplier Code, Supplier Description, Tel, Contact, Currency

Data Element Details

Invoice No., Supp Inv No., Date Total, Current, 31-60 Days, 61-90 Days, 91-120 Days and 121+ Days

Sub Total of the fields Total, Current, 31-60 Days, 61-90 Days, 91-120 Days and 121+ Days for each supplier code

Grand Total of the fields Total, Current, 31-60 Days, 61-90 Days, 91-120 Days and 121+ Days for each supplier group.

Grand Total of the fields Total, Current, 31-60 Days, 61-90 Days, 91-120 Days and 121+ Days for each transacted currency.

Grand Total level % Distribution to specify the percentage distribution under each of the fields Total, Current, 31-60 Days, 61-90 Days, 91-120 Days and 121+ Days for each supplier group. for each transacted currency

Summary-wise supplier ageing report

The summary-wise supplier ageing report is generated when the “Option” field is set as "Summary ".

Report Heading

Aged Payables Trial Balance (Summary)

Columns Printed

Group Header Details

Currency

Supplier Group

Data Element Details

Code, Name, Total, Current, 31-60, 61-90, 91-120 and 121+ Days

Grand Total of the fields Total, Current, 31-60, 61-90, 91-120 and 121+ Days for each supplier group.

Grand Total of the fields Total, Current, 31-60, 61-90, 91-120 and 121+ Days for each transacted currency.

Summary % Distribution to specify the percentage distribution under each of the fields Total, Current, 31-60, 61-90, 91-120 and 121+ Days for each transacted currency

Click here to know more on "Generating Supplier Ageing Report".