The debtors report allows you to browse and filter a list of trading programs in order to provide a summary of the due and overdue rebate, grouped into aged time periods per supplier and per trading program.
This functionality can be accessed by clicking on Finance at the top of your page and then on Debtors report from the drop-down menu.
On this page, a list will display a live view of any due or overdue rebate, where the aged debt for each payment line is based on:
In the panel on the right-hand side of the page, you will be able to filter the search results using the following criteria:
When you have finished making your selection, click the Search button in the bottom right-hand corner of the panel.
Once a search has been completed, the debtors report will be displayed, providing full visibility of any overdue rebate.
Please note — Your search criteria will be persisted for the duration of your session. Click the Reset button to clear the criteria.
The debtors report initially shows you a table of trading programs and their aged debt with the ability to drill down to view the debt by program line or payment line while filtering by the aged time period.
This ability to drill down to payment line level allows you to look up a specific payment frequency period for a program line and see how overdue the payment for that rebate is.
You will now have the option to either click on the Download button, which will generate a csv file of the on-screen search results, or select one of the trading program rows in the listing, which will display the program lines associated to the selected trading program (see screenshot below as an example).
When viewing the program lines for a trading program, you will have the following options:
Aged debt periods
The different aged debt periods are explained below:
The total debt column is the sum of all the above age categories.
The total due column is dependent on the configuration of the instance. It is either the sum of
OR the sum of