Language:


Create Stocktaking Records

When you carry out a stocktake, you should enter the results in a new record in the Stocktaking register. You can do this yourself or you can create the new record using the 'Create Stocktaking Records' Maintenance function. This function will create a new record in the Stocktaking register listing each Stocked Item together with its current stock level as it is recorded in your Standard ERP database. Items that you don't have in stock won't be included. If you have several Locations, the function will create a separate Stocktaking record for each Location. In each of these records, you should enter the results of your stocktake in the Counted column in the matrix before marking them as OK and printing the Stocktaking Comparison report.

Selecting the 'Create Stocktaking Records' function brings up the following dialogue box:

Item No.
Paste Special    Item register
Range Reporting    Alpha
If you need the new Stocktaking record only to contain a particular Item, enter its Item Number here. You can also enter a range of Item Numbers separated by a colon (:).

Items in the range will not be included in the new Stocktaking record if they are not in stock or if they are not Stocked Items.

Item Group
Paste Special    Item Group register, Sales Ledger
Enter an Item Group here if you would like the new Stocktaking record only to contain Items belonging to that Item Group.

Item Classification
Paste Special    Item Classifications setting, Sales Ledger
If you need the new Stocktaking record only to contain Items that have a particular Item Classification, enter that Classification here. If you enter a number of Classifications separated by commas, only those Items featuring all the Classifications listed will be included in the new record. If you enter a number of Classifications separated by plus signs (+), all Items featuring at least one of the Classifications listed will be included. If you enter a Classification preceded by an exclamation mark (!), all Items featuring any Classification except the one listed will be included.

For example:
1,2
Includes Items with Classifications 1 and 2 (including Items with Classifications 1, 2 and 3).

1+2
Includes Items with Classifications 1 or 2.

!2
Includes all Items except those with Classification 2.

1,!2
Includes Items with Classification 1 but excludes those with Classification 2 (i.e. Items with Classifications 1 and 2 are not included). Note the comma before the exclamation mark in this example.

!1,!2
Includes all Items except those with Classification 1 or 2 or both. Again, note the comma.

!(1,2)
Includes all Items except those with Classifications 1 and 2 (Items with Classifications 1, 2 and 3 will not