Inventory audit trail

The inventory audit trail can be found at Products > Inventory audit trail.

This report displays every change to your inventory's in stock levels, both increases and decreases.

Every time a unit of inventory is:

  • Received into the system on a purchase order
  • Received into the system on a sales credit
  • Shipped out of the system on a sales order
  • Written off on a sales credit
  • Manually added
  • Manually removed
  • Transferred from one warehouse to another

... an entry is created on the inventory audit trail.

The most recent change is listed at the top by default.

Reading the report

The inventory audit trail displays:

  • The product ID, SKU, name and option values (if applicable)
  • The quantity added or removed
  • The total unit price of the unit(s) added or removed (unit cost plus unit landed cost)
  • A reference (see below)
  • The warehouse impacted
  • The date the movement occurred
  • A unique movement ID

References

The reference field on the inventory audit trail contains a lot of useful information.

If the inventory movement was associated with a sales order, a purchase order, or a sales credit, the reference column will contain a link to the relevant order.

If the inventory movement was the result of a manual correction (either a CSV update or an individual write on/off), an icon will appear in the reference field: mceclip0.png

Hovering over this icon will bring up more information about the movement:

mceclip1.png

It will indicate:

  • the movement ID
  • the reason provided when the adjustment was made (stock takes made via CSV will display the reason as 'Stock Update')
  • the kind of adjustment (in, out, or a price correction)
  • the product ID and SKU
  • the username of the staff member who performed the update

This information is also stored on the journal associated with the stock movement, making it easy to cross-reference the two reports for audit purposes.

Note: Inventory transfers are also recorded on the inventory audit trail. They appear as two equal but opposite lines, with the same date stamp and value but opposite quantities, and no reference. This is regardless of whether the items have been released from transit or not!
mceclip2.png

Filtering the report

There are a number of different filters on the inventory audit trail which can be used to identify particular products, view historical data, or toggle which warehouses to report on.

Finding specific products

The Inventory audit trail can be filtered by the following product attributes to enable you to look up a subset of products:

  • SKU
  • Product name
  • Product ID
  • Product status

It is also possible to filter by warehouse, to view the movements of inventory in and out of a particular warehouse.

You are also able to filter by Movement ID.

Filtering by date

The inventory audit trail has a date from and a date to field, enabling you to look up all the movements within that date range.

This is useful for seeing the activity during a period (i.e. the total value in or out of the system), as opposed to the overall value on a specific date, as with the inventory summary and detail reports.

Filter first setting

The inventory audit trail is a filter first report, so it can be configured to always display the filter first before loading the report. This can be useful if you have a large product catalog.

Learn more about filter first reports here.

 

 

Have more questions? Submit a request