Generating a daily earnings report allows earnings results for a specific trading partner to be extracted from Trading Programs for a specified period of time.
When clicking on Reports at the top of the page and then on Daily earnings in the drop-down menu, you will be taken to a page that allows you to extract actual earnings results from Trading Programs that relate to trading activity over a specified time period, including the transactions that has generated those earnings.
You will be required to select a single trading partner and then (optionally) filter by any of the following:
Hide dimension items with no transaction · When unchecked, dimension items that are included in the program line with no transactions will be shown in the report results, allowing users to see which dimension items are inactive in their trading program.
The results of your report are then filtered down to the results that match all of your filters. Trading Programs will, however, prevent a report from being run if your criteria does not satisfy the requirement that the ‘View by’ selections must be across a maximum of 3 dimensions.
By clicking on the Preview button at the bottom of your page, you will be taken to a new page displaying the first 40 results of your report in a table.
As you can see from the preview above, all the relevant information about your program line will be pulled through. The earnings will be broken down into columns depending on the program line results types chosen in the filters of the criteria page. You can also see there are two transacted values columns: Total transacted value and Effective transacted value. The difference being that total transacted value is the value of the transactions for this program line once deductions and discounts have taken place.
You will then have the option to revise your filters and re-generate the results by clicking on the Change criteria button, refresh the preview to re-generate the results by clicking on the ⟳ button or download the full set of results by clicking on the Download button, as seen in the screenshot below.
Reports with a large amount of dimension items to be included will now be scheduled to run overnight.