Click here to know more on "Generating Supplier Ageing Report".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, account type 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 selected.
Supplier Ageing - Detail 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 Transaction Currency Supplier Group Data Element Details Document No., Supp Inv No., Date, Total, Current, 1-30 Days, 31-60 Days, 61-90 Days, 91-120 Days and 121+ Days Sub Total of the fields Total, Current, 1-30 Days, 31-60 Days, 61-90 Days, 91-120 Days and 121+ Days for each supplier code Grand Total of the fields Total, Current, 1-30 Days, 31-60 Days, 61-90 Days, 91-120 Days and 121+ Days for each supplier group. Grand Total of the fields Total, Current, 1-30 Days, 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, 1-30 Days, 31-60 Days, 61-90 Days, 91-120 Days and 121+ Days for each supplier group. for each transacted currency |
Supplier Ageing – Detail – Line Level Report
The detail supplier ageing report is generated when the “Option” field is set as "Detail".
|
Report Heading |
Aged Payables Trial Balance (Summary) |
|
Columns Printed |
Group Header Details Transaction Currency Supplier Group Data Element Details Document No., Supp Inv No., Date, Line No., Total, Current, 1-30 Days, 31-60 Days, 61-90 Days, 91-120 Days and 121+ Days Sub Total of the fields Total, Current, 1-30 Days, 31-60 Days, 61-90 Days, 91-120 Days and 121+ Days for each supplier code Grand Total of the fields Total, Current, 1-30 Days, 31-60 Days, 61-90 Days, 91-120 Days and 121+ Days for each supplier group. Grand Total of the fields Total, Current, 1-30 Days, 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, 1-30 Days, 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 of 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 Transaction Currency Supplier Group Data Element Details Code, Name, Total, Current, 1-30 Days, 31-60 Days, 61-90 Days, 91-120Days and 121+ Days Grand Total of the fields Total, Current, 1-30 Days,31-60 Days, 61-90Days, 91-120 Days and 121+ Days for each supplier group. Grand Total of the fields Total, Current, 1-30 Days,31-60 Days, 61-90Days, 91-120 Days 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".