The transactions report allows you to view, aggregate, and filter transactions that have been uploaded into Enable. This provides you with the ability to understand the raw transactional data which impacts your special pricing agreements and support calculated.
This article will guide you through:
- How to navigate to the SPA transactions report
- How to use filters in the transaction report for SPAs
- How to configure dimension filters
- Viewing and understanding the report results
Looking for something else?
- Need help viewing transactions for rebate agreements rather than special pricing agreements? Click here to generate a transactions report for trading programs.
- Alternatively, see our Help Center for more on SPAs.
The transactions report for SPAs is located in the Trading programs app.
To access the transactions report:
Step 1: Click the hub switcher icon (nine dots) in the top right. This will display the Apps you have access to.
Step 2: Click on Trading programs.
Once in trading programs:
Step 3: Click on Reports in the green banner at the top of the page
Step 4: Click on Transactions in the drop-down menu.
If the Reports menu is not available, a channel admin user at your organization will need to provide you with the correct user permissions.
Filters on the transaction report can be used to add more context to report results. Filters are all optional except for Trading partner which is mandatory.
The filters available are:
- Trading partner: Click the hamburger icon to select one or more trading partners to filter results to only use transactions where the specified trading partner(s) were involved. If left as None, the report results will include all trading partners.
- Currency: Click the hamburger icon to 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.
- Transaction period: Click to select a From and To date to only display transactions for the given date range. The From and To dates can be used separately or together.
- Frequency: Select from Daily, Weekly, Monthly, Quarterly, Annual, None, or Full period to set the granularity of the transactions displayed in the report. E.g. selecting None will display by individual transaction line, Monthly will display transactions grouped by each month, and Full period will display the totals across transactions held within the channel’s data.
- Dimension filters: Use to include only specific dimension items (e.g. products) or dimension attributes (e.g. product categories or groups). Click here to learn how to configure dimension filters.
- View by: Click the hamburger icon to set the checkbox for one or multiple dimension items and/or dimension attributes, to increase the granularity of the transactions displayed. Each View by selected will display an additional column in the report (e.g. specific products, product categories, or branches). Note: Each report supports a maximum of 3 view bys. Interested in reporting on more than these? Reach out to your Customer Success Manager to discuss Advanced Reporting options.
- Consider manually imported transactions only?: This is rebate-specific functionality; leave the checkbox clear for SPAs transactions.
- Consider unassigned transactions only?: Set the checkbox to only display transactions that have not accrued any support.
- Consider trading partner-fed transactions only?: Set the checkbox to only display transactions that have been imported via Collaborator users.
- External reference: This is rebate-specific functionality; leave the checkbox clear for SPAs transactions.
- Order reference: Type to filter by an order reference used on the transaction line. Only available if the Frequency is set to None.
- Delivery reference: Type to filter by a delivery reference used on the transaction line. Only available if the Frequency is set to None.
- Invoice reference: Type to filter by an invoice reference used on the transaction line. Only available if the Frequency is set to None.
- Transaction owner: Click the hamburger icon to search and select one or more trading partner who owns the transaction. Only available if the Frequency is set to None.
- Type: Select Purchases or Sales to only display transactions of that type. Select None to display all transactions.
Dimension filters can be used to include only specific dimension items (e.g. products) or dimension attributes (e.g. product categories or groups).
To add a dimension filter in the transactions report:
Step 1: Click the hamburger icon for Dimension filters.
Step 2: Click Add and select the dimension you wish to filter on from the drop-down.
Step 3: (Optional) Select the relevant Collection; this should default to the only collection.
Step 4: (Optional) Click the hamburger icon next to Item to search and select single or multiple dimension items (e.g. product); click Done to save the item selection.
Step 5: (Optional) Click the hamburger icon next to Attribute to set the checkbox for single or multiple grouping items (e.g. product category or group); click Done to save the attribute selection.
Step 6: Click Add to create the filtering rule.
Step 7: Click Add to add another dimension filter, or click Done to save the dimension filters.
When you are ready, click the Preview button at the bottom of the page to view your report's results.
Alternatively, click the Reset button to change all filters to their defaults.
Once you have clicked to Preview results from the filters page, the transaction report will be displayed with the first 40 results. Loading times may vary depending on the number of results in your report.
The report preview displays totals at the bottom of each column from the full data set, even if the preview doesn’t include all rows.
The buttons below the report can be used to:
- Download to save and view the results for the full report as a CSV file.
- Refresh to update results based on any changes made within the channel since the report was generated.
- Change criteria to navigate back to the report filters to make any amendments.
The columns displayed in the report results include:
- Trading partner: The name of the trading partner who the transaction was with.
- Trading partner reference: The reference of the trading partner that transaction was with.
- Transaction date(s): The actual date, or dates from and to, that the transaction(s) in the row occurred.
- Total transacted units: The total units for the transaction or group of transactions in the row.
- Total transacted value: The total value for the transaction or group of transactions in the row.
- Currency: The currency of the transactions for the row.
Additional columns may also be displayed grouping transactions, e.g. by product category, if a View by filter was used for the report. This aggregates the transactions displayed in each row.
If a frequency of None was selected in the report filters, additional columns will also be displayed, populated based on the original transactions imported. These could include Product and Branch.
What’s next?
Want to dive deeper into the specific transaction files imported? Learn how to review transaction logs for SPAs here.
Ready to see how much support your SPAs are earning? Learn how to run the special pricing support report here.