TradeOne logo TRADEONEUSER GUIDE

Inventory Reports

What These Reports Show

Reports > Inventory Reports shows your stock position and its history. You need the reports.inventory permission. They are read-only. To change stock, use the Inventory Hub.

There are six tabs. The first two show how things are now. The others cover a date range that you pick. The date controls work as in Sales Reports: From, To, From Time and To Time.

Stock reports show only the locations of the branch you are working in.

Low stock report

Stock on Hand

What you hold right now, per variant and location. Columns: Product, Variant, SKU, Location, Qty on Hand, Order Level and Status. The status is OK, or Low Stock when the quantity is at or below the order level.

Filter with "Search product, variant, SKU or barcode...", All locations and All categories. If nothing is there you see "No stock records found."

The Order Level is the Reorder at you set on the product. See Products.

Stock on Hand shows quantities only. It does not show the value of the stock.

Low Stock

Your shopping list. It shows every variant at a location where the quantity is at or below the order level. Columns: Product, Variant, SKU, Location, Current Qty, Order Level and Shortage. The shortage is Order Level minus Current Qty, and the list starts with the lowest quantity. Filter by All categories.

Example: the order level for 20L bottles is 10, and you have 4 at the counter. The shortage is 6. If nothing is low you see "No low-stock items found."

Note

A variant with Reorder at 0 and no stock also shows here, because 0 is at or below 0.

Stock Flow

Quantity in against quantity out, one row per day. Columns: Date, Received, Sold and Net.

  • Received counts stock that came in through received purchases.
  • Sold counts units sold at the till and by salespeople.
  • Net is Received minus Sold. It is green when more came in than went out.

A Totals row sums the period. If the period is empty you see "No data for selected period." Stock Flow does not count adjustments, transfers, production or voids. Use Movements for those.

Movements

The line-by-line log of every stock change in the period: Date, Product / Variant, SKU, Type, Qty, From, To and Staff. Filter by All locations and All types.

The types you can filter by are: Adjustment, Issue to Staff, Purchase, Return from Staff, Sale, Service Consumption, Transfer and User Sale. If nothing is there you see "No movements for selected period."

Use it to trace what happened to one item. The same history is on Inventory > Inventory Hub > Movements. See Inventory.

Stock Received

Purchases received in the period: Ref #, Supplier, Date Received, Items, Total and Total Value. Filter by All suppliers. If none you see "No stock received in selected period."

Purchase Orders

All purchase orders created in the period: Ref #, Supplier, Date, Status, Ordered, Received and Total. Filter by All statuses (Draft, Received, Cancelled) and All suppliers. If none you see "No purchase orders for selected period."

Which Report Do I Want

Question Use
How much do I have now? Stock on Hand
What must I order? Low Stock
How did it get to this number? Movements
How much came in and went out each day? Stock Flow
What did I receive from suppliers? Stock Received
What orders have I raised? Purchase Orders

Exporting

Most tabs have Print / PDF and Excel buttons. Stock Flow, Stock Received and Purchase Orders have Print / PDF only.