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:
- Choose the warehouse at the top. The detail is always for one warehouse.
- 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:
- 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.
- Tick Breakdown by size (line = item, columns by size/colour).
- 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 see | What has happened | What to do |
|---|---|---|
| The Size breakdown card doesn’t appear | The item doesn’t work with sizes, or it has no variants generated | Generate the matrix on its Sizes tab |
| The whole grid shows zero | That warehouse hasn’t had movements of those combinations | Change 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 record | Change warehouse and check the grid on the Sizes tab |
| The Breakdown by size box doesn’t appear | No item in the company has variants generated | Generate the grid for some item |
| ‘No stock for the selected filter.’ | The ranges don’t pick up anything, or there are no movements | Empty the ranges and click View on screen again |
| A report line with no size or colour on an item with variants | The combination was deleted from the grid while it had stock | Create 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
- How do I change the length of codes?
- What are trades for?
- What are customer types for?
- How do I classify my customers by type, route, trade and carrier?
- How do I set up my company’s sizes and colours?
- How do I add a sales agent?
- How do I add an item?
- How do I add a customer?
- How do I add a supplier?
- How do I add my customers’ vehicles?
- How do I add a currency?
- Mailing for your customers and suppliers