Skip to content

How do I run the stock report?

The stock report tells you how much of each item there is in each warehouse, what it is worth, how much will be left once pending orders are filled and how much you need to order to reach the minimum. You can view it on screen and print it as a PDF.

What do I need before I start?

Nothing more than items with stock movements. The report comes from the real stock, so an item that has never had a quantity in a warehouse doesn’t appear in it yet.

If your company works with sizes and colours, you will also have the option of viewing the report broken down.

How do I do it?

  1. Go to Warehouse and click Warehouse reports.
  2. In the left-hand bar, open Warehouse stock and choose one of its options.
  3. The Warehouse and Item ranges are already filled in from end to end: narrow them if you want to restrict the report. You move through them with the keyboard just as in the other reports. All the options also ask for the item’s Family and Supplier, and offer Subtotals by warehouse, item family or supplier.
  4. Click View to see it on screen, Report to open the PDF, Data to export it or Send to email it.

If you don’t touch the ranges, all warehouses and all items are included.

What does each column mean?

The report has one line per combination of warehouse, item and variant.

The four valued reports follow the Desktop ERP’s layout, sorted by code:

In the valued reports, lines with stock at zero aren’t included: they add nothing to the value.

At average price also has, on the same line, the value at the average sales price (Sale and Sales total) and the Profit that stock would make if sold at that price (stock × (sale − cost)). Its cost price is called Cost.

Stock control has Code, Description, Whse., size and colour, Supplier and Reference, and instead of a price the Desktop ERP columns:

Here, lines at zero are included.

At the foot of the whole report there is a totals line: the sum of the stock and, in the valued reports, the value of the warehouse. To also see the total for each warehouse, each item family or each supplier, choose that option in Subtotals by.

For items with sizes, the report shows only the lines for each size and colour. The item’s overall figure isn’t listed separately: adding it would double the stock.

How do I see it broken down by sizes and colours?

Tick the Breakdown by size (line = item, columns by size/colour) box before clicking the button. The box only appears if your company has items with sizes.

In that mode the shape of the report changes: instead of one line per combination, you get one block per item and warehouse with a grid, rows by size and columns by colour, plus the total for each row and for the whole block.

What you see on screen and what comes out in the PDF are exactly the same figures: it is the same query drawn in two ways.

What is the difference between the four ‘valued’ reports?

The price the stock is valued at. Each one multiplies the stock on each line by a different price from the item record, and adds up the result per warehouse and in total:

OptionValues at
At sales pricethe sales price on the record (the first one on the prices tab)
At average pricethe current average price (the weighted average cost)
At last pricethe price of the last purchase
At purchase pricethe final purchase price on the record (with its discount and its costs)

The first two tell you what your warehouse is worth if you sell it; the last two, what it cost you. They are different figures on purpose: if they come out the same, those items are missing a price on their record.

Stock control doesn’t value: it shows the same lines with what came in, what went out, what is still to be filled and what needs ordering, which is what helps you restock the warehouse rather than put a value on it.

What do ‘Consumption’ and ‘Transferred stock’ give me?

Consumption by item tells you what has been sold of each item: Avg. price (the average sales price on the record), Tot. sales (the running total of units sold), the Stock and Totals (units sold × average price), with the total for each warehouse. Only items that have sold something are included; with the Items with no stock movements box, all of them are. It doesn’t ask for dates: the sales are the item’s running totals, not those of a period.

Transferred stock has the sales Price, the Current stock (without what was transferred), what is pending Transfer, the Totals, the % that hasn’t been transferred, the running totals of purchases and sales and the Total at sales price. All items in the range are included, as in the Desktop ERP.

What about the item catalogue?

It is in the Items group. The Item catalogue is run like the other reports: with View, Report, Print and Data. It gives one line per item with its Code, Description, Family, Supplier, SKU, Barcode and Retail price (the sales price on the record).

Its filters:

Items that have never had a stock movement are also included. Stock isn’t in the catalogue: that is what the stock reports above are for.

If your company works with sizes and colours, you also have the Item catalogue by size: one grid per item, with the last dimension in columns (‘x’ if the combination exists, or its price if it has one of its own). It has the same warehouse, item, item family and supplier ranges and the same discontinued items box. View shows it on screen, below the filters, just as it comes out in the PDF; PDF report opens it for printing.

The Save file button on the catalogue by size downloads the report as a PDF, with the name the program gives it. It doesn’t ask where to save it: it goes wherever your browser puts downloads.

If something goes wrong

What you seeWhat has happenedWhat to do
‘No stock for the selected filter.’The ranges don’t let any row throughEmpty the ranges and try again
An item with stock doesn’t appearThe ranges don’t include it, or the item doesn’t yet have a row in that warehouseCheck the ranges and the item’s Stock tab
An item in the report at sales price shows a price and total of zeroIts record has no sales priceEnter the price on the item’s prices tab
The figures for the item with sizes are missingIn normal mode only its sizes are listedAdd up the lines for its sizes, or tick the breakdown by size
‘Could not generate the PDF’Generation failedTry again; if it keeps happening, tell support

See also: View and correct an item’s stock · Add a warehouse

More about Warehouse