Varieties and Reports - Varieties in Stock
This report (to be found 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 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 10129 is "WS,FT,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,FT,LL" to "FT,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,FT,LL,FLY" (waist size, fit, leg length, fly type):
The second set of group headings ("Zip" and "Button") 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 156 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 128 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 Modules menu and click the [Reports] button in the Master Control panel. When the 'Reports' list opens, double-click 'Varieties in Stock'. The 'Specify Varieties in Stock report' window appears:
- 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.
- Location
- Paste Special
Locations setting Stock module
- To produce a report for one stock Location, enter its Location Code here.
- Include all Possible Varieties
- Usually the report will only show the Varieties that you have in stock. Check this box if you would like every Variety to be shown.
