Varieties and Reports - Varieties Control
Once you have entered a
Variety Mask for a particular Item, and have then used the Item in at least one sales or stock transaction, you should not change the Mask. Doing so will cause your stock records to become inaccurate.
For example, you might have an Item 10147 representing a particular style of trouser whose Variety Mask is "WS,LL" (waist size, leg length). When you enter a Goods Receipt to receive the first consignment into stock, you will use combined Item/Variety Numbers such as 10147.30W.30L. If for some reason you change the Mask to "LL,WS", the combined Item/Variety Numbers of the examples already in stock will be rendered unrecognisable, because "30W" is not a leg length and "30L" is not a waist size. This will mean that you cannot sell these examples or otherwise remove them from stock. It may also mean that these examples are excluded from some reports.
The Varieties Control report can help find combined Item/Variety Numbers that are not constructed correctly. Usually this will be because the Mask has been changed, as previously described. Continuing the example, running this report with the default options will produce the following result:
The report lists a single Item. This signifies that the Item has been used in at least one transaction with a combined Item/Variety Number that does not match the relevant Mask. Drilling down from the Item Number will display a list of transactions in which an incorrect Item/Variety Number has been used:
In this case, the transaction is a Goods Receipt. As there is no outgoing stock transaction, it is likely that the Item is still in stock. If there is no stock using the correct Item/Variety Number, one solution might be to revert the Variety Mask. One way of checking is to reopen the report specification window and select the
Include all events option. This will list transactions with the incorrect Item/Variety Number and transactions with the correct Item/Variety Number:
If, as in this example, there is stock using both the correct and the incorrect Item/Variety Numbers, one way to correct the error will be to proceed as follows. First, change the Variety Mask so that the incorrect Item/Variety Number becomes valid. Remove all examples from stock using a Stock Depreciation. Change the Variety Mask to the correct one and bring them back in to stock. This process will ensure that all examples of the Item in stock have the correct Item/Variety Number, but it will not correct the original transactions, so the Item History report for the Item will be incomplete.
To produce the Varieties Control 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 Control'. The 'Specify Varieties Control' 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.
- Period
- Paste Special
Reporting Periods setting, System module
- Specify the period to be covered by the report. All stock transactions from this period will be checked for incorrect combined Item/Variety Numbers.
- Item No.
- Paste Special
Item register
- Range Reporting Alpha
- Enter an Item Number (or range of numbers) if you need to check that all combined Item/Variety Numbers relating to a particular Item are correct. You can also enter a range of Item Numbers separated by a colon (:).
- Alternative Code
- You can also produce a report for a specific Item by specifying its Alternative Code here.
- Group
- Paste Special
Item Group register, Sales Ledger
- Range Reporting Alpha
- Enter an Item Group Code here if you need to check that all combined Item/Variety Numbers relating to Items belonging to a particular Item Group are correct.
- Function
- Use these options to control the level of detail shown in the report.
- Overview
- This option simply lists any Items in the range that have been used in at least one transaction with an incorrect combined Item/Variety Number (i.e. one that does not match the relevant Mask).
- Detailed
- This option lists the transactions in which an Item in the range has been used with an incorrect combined Item/Variety Number.
- If you print the Overview to screen, you can click (Windows/Mac OS X) or tap (iOS/Android) an Item Number to produce the Detailed version of the report for a particular Item.
- Include all events
- By default, the Detailed version of the report only lists transactions in which an Item in the range has been used with an incorrect combined Item/Variety Number. Select this option if you would like to list every transaction in which the Items in the range have been used.
---
Varieties in Standard ERP:
Go back to:
