SPA transactions report

The transactions report allows you to view, aggregate, and filter transactions that have been uploaded into Enable. These must be reviewed via trading programs > reports > transactions. By default, the transaction report will show the following columns at a daily frequency:

• Customer: the name of the customer who has transacted.
• Customer reference: the reference of the transacting customer.
• Transaction date: only dates with transactions will be included.
• Total Transacted units: the total units across all transactions for the given period (day by default).
• Total transacted value: the total value transacted for a given day for a given currency.
• Currency: the currency of the total transactions.

Transaction report filters allow you to add more context to the default report. The steps below are all optional; if you encounter any issues, please reach out to our support team here:

1. Search transactions for a specific customer: This is the end customer on the transaction.
2. Filter for a given currency (e.g., GBP).
3. Filter by latest transaction date: Use a from and to date selection to return transactions for a given date range. The from and to date selection can also be used separately.
4. Set the report to a given frequency: this changes the report totals to daily, weekly, monthly, quarterly, annual, none, or full period. Please note none will show individual transactions uploaded, and the full period will show the system totals.
5. Add a dimension filter to exclude transactions from the total columns. You will need to do this for each of the dimensions you wish to filter on:
   a. Click on the dimension filter.
   b. Click add and select the dimension you wish to filter on.
   c. (Optional) Select the relevant collection; this should default to the only collection.
   d. (Optional) Select a single or multiple dimension items (i.e., product, location, type) you wish to filter by clicking on the three lines next to item. Click done.
   e. (Optional) you can also select single or multiple groupings using the attribute menu by clicking on the three lines next to the attribute heading. Click done.
   f. Click add to create the filtering rule.

tip: if you click on an item or attribute in steps d or e, the Done button will navigate you back from the picker.

6. Add a view by to increase the granularity of your search by having additional columns for each of the view by settings selected. To add a view by:
   a. Select one or many dimension items and/or attributes (for example, specific products, product categories, or Branches).
   b. Multiple view by’s can be added to increase the granularity further.
7. Set whether to consider manually imported transactions only?:  This is rebate-specific functionality.
8. Set whether to consider unassigned transactions only: ticking this box will return transactions that have not accrued any support.
9. Search for a specific external reference; this is rebate-specific functionality. This is only available if the frequency is set to none.
10. Consider customer fed transactions only?: Only displays transactions that have been imported via collaborator users.
11. Search for a specific order reference in uploaded transactions; see the transaction template to learn more. This is only available if the frequency is set to none.‍
12. Search for a specific delivery reference in uploaded transactions; see the transaction template to learn more. This is only available if the frequency is set to none.
13. Search for a specific invoice reference in uploaded transactions; see the transaction template to learn more. This is only available if the frequency is set to none.
14. Search for the transaction owner: The organization that owns the transaction. This will be the distributor for SPAs. This is only available if the frequency is set to none.
15. Type: none, purchases or sales, where none returns all transactions.