Skip to content

How do I view stock by size and colour?

For an item with variants, stock is kept per combination and in total. There are two places to check it: the detail on the item record, to look at one specific thing, and the stock report, to review the whole warehouse.

What do I need before I start?

You need the item with its variant grid generated and some movement made. A combination that has never had any receipts or issues shows as zero on the record and doesn’t appear in the report.

How do I see the stock of each combination of an item?

On the item record, Stock tab:

  1. Choose the warehouse at the top. The detail is always for one warehouse.
  2. Scroll down to the Size breakdown card and click View detail by size.

A grid appears with the same shape as the quick entry grid on documents: the item’s last dimension in columns and the combinations of the previous ones in rows. With size and colour, one row per size and one column per colour; with model, colour and size, one row for each pair of model and colour (Slim · Azul) and one column per size; with a single dimension, a single row, Stock, with the values in columns. You see the names of the values, not their keys.

Each cell shows the stock of that combination. If there are pending quantities, they are added in brackets: as a positive figure what is still to be received and as a negative figure what is still to be delivered. Combinations that don’t exist in the item’s grid are shown as —.

The card only appears if the item works with sizes. And it is read-only: stock isn’t corrected here.

Why don’t the figures at the top match the sum of the grid?

They do match, but they aren’t added up: they are broken down. The stock fields at the top of the Stock tab are the item total, and the grid is that same total split by combinations.

Each movement of a variant adjusts both its combination and the item total, in the same operation. That is why there is no way for one to move forward and the other to fall behind.

If you see a difference, it is almost always a variant that was deleted from the item’s grid while it still had stock: its quantity is still in the total, but it no longer has a row to be shown in.

How do I produce the stock report by size?

In Warehouse → Warehouse reports, in the Warehouse stock group:

  1. Choose one of its reports (for example Valued at sales price) and fill in the warehouse and item ranges, if you want to narrow it down.
  2. Tick Breakdown by size (line = item, columns by size/colour).
  3. Click View on screen to see it, or PDF report for paper.

Without that box, the report comes out in normal mode: one line per combination, with its code, its description, the combination in a single column (M · Azul marino) and its stock, reserved, pending and available quantities. The column is headed with the dimensions of the items listed, or Details if they have different ones.

With the box ticked, the report is grouped: one block per warehouse and item, with the same shape as the grid on the record —each item’s last dimension in columns— and totals per row and per item.

The box only appears if some item in the company works with variants.

Which rows appear in the stock report?

For items with sizes only the combinations appear, never the item total: listing it as well would duplicate the quantities. For items without sizes their single row appears, with the combination column empty.

The report is built on what has had movement. A combination that hasn’t yet had any receipt or issue doesn’t appear, even if it is in the item’s grid.

If you ever see a line with the base item code and no size or colour on an item that does work with variants, it is a combination deleted from the grid that was left with stock.

Can I produce the catalogue with the sizes?

Yes. In Warehouse → Warehouse reports, Items group, choose Item catalogue by size. Each item’s combination matrix appears instead of one line per item, with the same shape: the last dimension in columns. You can narrow it down by warehouse, item, item family and supplier.

Can I correct a size’s stock by hand?

Not from the record. The editable fields on the Stock tab are those of the item total; the size grid is view only.

To balance a specific combination, make a warehouse receipt or issue document with that variant on the line. It is also the only way if the item has batches or serial numbers: in that case, the record doesn’t even let you change the stock by hand.

If something goes wrong

What you seeWhat has happenedWhat to do
The Size breakdown card doesn’t appearThe item doesn’t work with sizes, or it has no variants generatedGenerate the matrix on its Sizes tab
The whole grid shows zeroThat warehouse hasn’t had movements of those combinationsChange warehouse, or check that sales were made with a variant
The whole grid shows —The warehouse shown isn’t the one with the stock, or the combinations were removed from the recordChange warehouse and check the grid on the Sizes tab
The Breakdown by size box doesn’t appearNo item in the company has variants generatedGenerate the grid for some item
‘No stock for the selected filter.’The ranges don’t pick up anything, or there are no movementsEmpty the ranges and click View on screen again
A report line with no size or colour on an item with variantsThe combination was deleted from the grid while it had stockCreate it again on the Sizes tab so you can balance it

See also: Sizes and colours of an item · Sell an item with sizes · Set up sizes and colours

More about Records