The creditors 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 customer and per trading program.
This functionality can be accessed by clicking on Finance at the top of your page and then on Creditors report from the drop-down menu.
On this page, a list will display a live view of any due or overdue rebate, where the age 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 the creditors 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 creditors report initially shows you a table of trading programs and their aged rebate payment with the ability to drill down to view the aged rebate by program line or payment line, while filtering by the aged 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:
The different aged periods are explained below:
The total total column is the sum of all the above age categories.
Total due column is dependent on the configuration of the instance. It is either the sum of
OR the sum of