The special pricing support report allows you to review how much support has been calculated for your special pricing agreements (SPAs) based on various aggregations of data, in addition to transactions that haven’t been matched to a SPA.
Step 1: Click on Reports in the green banner at the top of the page
Step 2: Click on Support in the drop-down menu.
Navigating to the SPA support report
How to use filters in the SPA support report
Filters on the support report report can be used to add more context to report results. Filters are all optional except the Manufacturer/Distributor field. The filters available are:
Manufacturers: Only displayed if your organization is the distributor. Click the hamburger icon to select one or more manufacturers to only display transactions where the specified manufacturer(s) were involved. If left as None, the report results will include all manufacturers.
Distributors: Only displayed if your organization is the manufacturer. Click the hamburger icon to select one or more distributors to only display transactions where the specified distributor(s) were involved. If left as None, the report results will include all distributors.
End-customers: Click the hamburger icon to select one or more customers to only display transactions where the specified end-customer(s) were involved. If left as None, the report results will include all end-customers.
Date from: Select a date to only display transactions dated on or after the selected date.
Date to: Select select a date to only display transactions dated on or before the selected date.
Frequency: Groups transactions based on the selected time period. Options available to select from are Daily, Weekly, Monthly, Quarterly, Annual, or None. If set to None, the report results will display by individual transaction line rather than grouping transaction lines by day, week, month, quarter, or year.
Show unmatched transactions: Set the checkbox to display all transactions fitting the chosen criteria. If the checkbox is clear, results will be filtered to only display transactions matched to a SPA.
Special pricing agreement: Type to search by SPA Reference or Agreement name, and click to select one or more SPA to filters transactions displayed to those that are matched to the selected agreement(s). When one or more SPA is selected here, the Show unmatched transactions field is disabled.
Currency: Select one or more currency, to filter results to only display transactions for a given currency (or currencies). Options to select from are based on currencies configured in your channel.
When you are ready, click the Preview button at the bottom of the page to view the results of your report.
Alternatively, click the Reset button to change all filters to their defaults.
Viewing the SPA support report results
Once you have clicked to Preview results from the filters page, the support report will be displayed.
Additional columns within the report can be viewed by scrolling to the right of the report screen, and arrows in the top right will allow you to navigate through the pages of results.
Alternatively, the buttons below the report can be used to:
Download to save and view the results for this report as a CSV file.
Change criteria to navigate back to the support report filters to make any amendments before you preview the results again.
Support report results: Frequency set to None
Understanding the support report results
The support report results will display the following columns:
Manufacturer reference: Only displayed if your organization is the distributor. The reference of the distributor, as specified in the transaction file.
Distributor reference: Only displayed if your organization is the manufacturer. The reference of the manufacturer, as specified in the transaction file.
Customer reference: The reference of the end-customer, as specified in the transaction file.
Transaction date (Displayed if a frequency of None or Daily has been selected): The date on which the transaction occurred, i.e. the date the product was sold to the end-customer, as specified in the transaction file imported. Dates will only be displayed where transactions occurred.
Transaction start date (Displayed if a frequency of Weekly/Monthly/Quarterly/Annually has been selected): Date of the start of a period. Periods will only be displayed where transactions occurred for the period.
Transaction end date (Displayed if a frequency of Weekly/Monthly/Quarterly/Annually has been selected): Date of the end of a period. Periods will only be displayed where transactions occurred for the period.
Agreement reference on transaction (Displayed only if a frequency of None has been selected): The agreement reference relating to the SPA in Enable for the transaction line, i.e. the SPA the claim has been made against against, if specified in the transaction file imported.
Has matched agreement reference? (Displayed only if a frequency of None has been selected): Displays Yes if the agreement reference supplied in the transaction file matches the agreement Enable has calculated support for. Displays No if the agreement reference supplied in the transaction file does not match the agreement Enable has calculated support for. This will be blank if no agreement reference was supplied in the transaction file.
Matched SPA reference: The reference of the agreement Enable has calculated support for, if applicable.
Matched agreement name: The name of the agreement Enable has calculated support for, if applicable.
Tag (Displayed only if a frequency of None has been selected): The tag from the matched agreement, if applicable. This will be blank if there is no tag on the matched agreement.
Branch: The name of the branch associated with the branch reference specified in the transaction file imported. Refers to the distributor’s branch the product was sold from.
Branch reference: The reference of the branch, as specified in the transaction file imported. Refers to the distributor’s branch the product was sold from.
Delivery type: The name of the delivery type associated with the delivery type reference specified in the transaction file imported. Refers to the delivery type of the transaction (i.e. sold through distributor stock or direct from manufacturer).
Delivery type reference: The reference of the delivery type, as specified in the transaction file imported.
SPA reference: The reference of the SPA, as specified in the transaction file imported. Refers to the SPA the uploading user was targeting for support on the associated transaction.
Invoice reference: The invoice reference for the transaction line, if specified in the transaction file imported.
Order reference: The order reference for the transaction line, if specified in the transaction file imported.
Delivery reference: The delivery reference for the transaction line, if specified in the transaction file imported.
Product: The name of the transacted product associated with the product reference specified in the transaction file imported.
Product reference: The reference of the product, as specified in the transaction file imported.
Total transacted units: The total transacted units for the given transaction date(s), as specified in the transaction files imported.
Total transacted value: The total transacted monetary value for all units for the given transaction date(s), as specified in the transaction files imported.
Forfeited support: The amount of support the transaction(s) for the given transaction date(s) would have received, if not for the reason mentioned in the Unsupported reason column. A value for forfeited support will display if support is already met and exceeded the quantity limit, or if a transaction fell outside the start and end dates of the SPA dates. This may be 0 if no support has been forfeited, or if multiple reasons contribute to the transaction not earning support for the SPA.
Actual support: The amount of support the transaction(s) for the given transaction date(s) is calculated to earn, i.e. how much support the manufacturer owes the distributor.
Distributor estimate: The estimated support the distributor expects to receive from the transaction(s) for the given transaction date(s), if Advised earnings was specified in the transaction file imported.
Difference: Calculates the actual support minus the distributor estimate.
%203.svg){kind=logo}