Inventory audit trail

The inventory audit trail is a filter first report, learn more here

Visit Products > Inventory audit trail .

You can filter this report by various options, including:

  • Product SKU
  • Product name
  • Product ID
  • Dates from and to
  • Warehouse

This report provides a full audit trail of changes to your inventory, both increases and decreases. This can be from receiving inventory on a purchase, shipping inventory from a goods-out note or from inventory corrections. Each change to your stock levels is listed here, the most recent change at the top by default. You'll find links to the relevant sales and purchases plus by clicking on the product name you can view details of the product item itself.

During a manual stock correction, if a reason why there was a change in stock was captured at the time, then you will see an 'i' icon next to that line. Hovering over this will display the stock correction reason. These notes will also be included in any export of this report that you do. If no reason was added when amending stock, then you will not see an ‘i’ icon and will see a blank space in the ‘Reference’ column next to that product line.

Why is there is there an asterisk next to the inventory value?

When the same SKU is added onto a purchase order using multiple rows (instead of a single row with the total quantity), perhaps because of different pricing, it is possible that the individual items will be allocated different landed costs. Once the items have been received into stock the total inventory value for the SKU in the batch can be seen on the inventory detail report and inventory audit trail. Since there are two different landed cost values to be shown on a single report line, the average landed cost will be calculated and displayed. When this happens an asterisk will be shown.

In this example, the SKU was received into stock on the purchase order with different landed costs:

PO-landed-cost.png

The SKU gets combined on the inventory detail report so an average cost is used to display a single landed cost:

inventory-detail-LC.png

Have more questions? Submit a request