Purchase reports: filters

The purchases list and purchase detail report can both be filtered to refine the information being reported on. This article will detail all the fields that can be filtered on with a description of how they work.

The filter on each report is made up of different sections. The combination of sections differ between reports. The four sections are:

  • Order filters
  • Product filters
  • Additional filters

Order filters

(present on all purchase reports)

mceclip0.png

The order filters are as follows:

Field name Description
Search

This field searches the amount, invoice reference, order reference, order ID, customer name and vendor company fields.

Ticking the checkbox next to the field will search the contents of the order instead (SKUs, product descriptions).

Date

This field limits orders based on a date range.

Choose the kind of date from:

  • Created
  • Tax date
  • Delivery
  • Payment due

Then pick a time frame from:

  • Custom date range (displays a 'to' and 'from' date picker)
  • Yesterday
  • Today
  • Tomorrow
  • Last 7 Days
  • Last 30 Days
  • Last 90 Days
  • Month to date
  • Year to date
  • Previous month
  • Previous year
Channel Use this filter to display orders from specific sales channels.
Order type

Choose from:

  • Purchase order
  • Purchase credit
Order status Use this filter to limit which order statuses are included in the report.
Invoiced

Use this filter to choose whether to display invoiced purchases or uninvoiced purchases.

Choose from:

  • Yes
  • No

This filter is more reliable than using the order status, as invoiced orders can have any order status.

Shipping method Filter orders based on shipping method.
Drop-ship

Filter for drop-shipped purchase orders.

Choose from:

  • Yes
  • No
Payment

The payment status of the order.

Choose from:

  • Paid
  • Partially paid
  • Unpaid
  • Authorized
  • Not applicable
Country Filter for orders with a specific delivery country.
Created by Filter for orders created by a certain staff member.
Assigned to Filter for orders assigned to a certain staff member.
Team Filter for orders assigned to a certain team.
Warehouse Filter for orders assigned a certain warehouse.
Lead source Filter for orders assigned a certain lead source.
Project Filter for orders assigned a certain project.
Season Filter for orders assigned a certain season.
Price list Filter for orders assigned a certain price list.
Supplier

Only on purchases list.

Filter for orders assigned to a specific contact.

Stock status

Only on purchases list.

Filter purchase orders based on the received status of the stock.

Choose from:

  • No stock tracked items
  • Not received
  • Part received
  • All received
  • Drop-ship not shipped
  • Drop-ship part shipped
  • Drop-ship all shipped
Row stock status

Only on purchase detail report.

Filter purchase order rows based on the received status of the row.

Choose from:

  • Non-stock tracked items
  • Items received
  • Items not received

Product filters

(present on purchase detail report)

mceclip1.png

Field name Description
Name/SKU Filter for order rows containing specific SKUs or products.
Product Type Filter for order rows containing products of a specific type.
Brand Filter for order rows containing products of a specific brand.
Category Filter for order rows containing products of a specific category.
Option Filter for order rows containing products using a specific option.
Option value Filter for order rows containing products with a specific option value, if filtering for an option.
Product status Filter for order rows containing products of a specific product status.
Supplier Filter for order rows containing products associated with a specific supplier.
Season Filter for order rows containing products associated with a specific season.

Additional filters

(present on the purchases list)

mceclip2.png

Field name Description
Delivery address fields Filter for orders based on delivery address.
Custom fields Filter for orders based on relevant custom field values.
Have more questions? Submit a request