Language:


Varieties and Reports - Varieties in Stock

The Varieties in Stock report in the Stock module provides similar information to the Varieties Enquiry report. However, where that report is a simple list of Varieties, this one displays the information in a table format.

Before producing this report, you must specify a Report Order for the relevant Item(s) on the 'Varieties' card of the Item record(s) or on flip B of the Variety Masks setting. If you have not done this, the report will be empty.

In this example, the Report Order for Item 10144 is "WS,FIT,LL" (waist size, fit, leg length):

The Varieties in Stock report for this Item looks like this:

The row titles ("30 inch waist", etc) are Varieties belonging to the "WS" Variety Group (waist size), the first Variety Group in the Report Order field. The column headings ("Comfort Fit", etc) are Varieties belonging to the second Variety Group in the Report Order field. The group headings ("30 inch inside leg", etc) belong to the third Variety Group in the Report Order field. The figures show the quantity in stock of each Variety (e.g. there are 78 Comfort Fit trousers with a 30" waist and 30" inside leg in stock).

Changing the Report Order from "WS,FIT,LL" to "FIT,WS,LL" produces this report:

This change causes the column headings and row titles to be swapped over.

In this final example, there are four Variety Groups in the Report Order field: "WS,FIT,LL,FLY" (waist size, fit, leg length, fly type):

The second set of group headings ("Button" and "Zip") are Varieties belonging to the "FLY" Variety Group, the fourth Variety Group in the Report Order field. The figures show the quantity in stock of each Variety (e.g. from the first set of group headings, there are 286 Comfort Fit trousers with a 30" waist and 30" inside leg in stock, including trousers with both types of fly; and from the second set of group headings, there are 280 Comfort Fit trousers with a 30" waist and button fly in stock, with all inside leg measurements).

Unlike the Mask field on flip A of the Variety Masks setting, you can change the Report Order field at any time, so you can produce different reports. One option is that if, for example, there are four Variety Groups in the Mask field, you do not need to quote all four in the Report Order field.

To produce this report, ensure you are in the Stock module using the [Switch Module] button in the Navigation Centre, then click (Windows/Mac OS X) or tap (iOS/Android) the [Reports] button, also in the Navigation Centre. When the 'Reports' list opens, double-click or tap 'Varieties in Stock'. The 'Specify Varieties in Stock report' window illustrated below will appear. Once you have entered the reporting criteria as described below the illustration, click or tap the [Run] button to produce the report.

Item No.
Paste Special    Item register
Range Reporting    Alpha
Enter an Item Number (or range of numbers) to produce a report for specific Item(s). Use a colon (:) to separate the first and last number.

Item Group
Paste Special    Item Group register, Sales Ledger
Enter an Item Group Code to produce a report listing the Items in a particular