Stocktaking records

Stocktaking records

9.6

Revision History
16.11.2009
The Status nested menu was added to the description of the context menu.
22.12.2009
The Store" column was added to the Collation report data grid.
11.08.2010
Descriptions of the New stocktaking records and New stocktaking record collation report items windows were added. A description of how to access commands in context menus was added. A description of the use of fields in windows was added.
12.04.2011
Tab pages were transformed into panels.
13.03.2012
The System column was added to the data grid of the document list. The Create based on command was added to the context menu. It enables the user to add a new stocktaking record created on the basis of previous records or the Stock on hand operational report.
11.02.2013
The Status field was removed from the specification. Only store status is displayed for specification items. The Calculated field was renamed Confirmed.
15.01.2014
Commands were added to the collation report's context menu that allow you to sequentially add items from the Stock items directory and the Stock on hand operational report.
19.08.2014
The Shipping note number field was added to the Stocktaking record window, and the Alcohol declaration panel was added to the Stocktaking record specification element window. These items will be displayed if working with alcohol declarations is available in Tillypad XL Manager.
08.09.2014
The Alcohol declaration panel is only displayed in the windows of surplus items from stocktaking record specifications.
21.10.2015
The description of the Date field was edited.
26.11.2015

Stocktaking denotes the physical counting of stock items on store shelves in order to compare actual and theoretical stock levels. Stocktaking is a major component of the system used for monitoring inventories and staff activities.

A stocktake can be full or partial. A full stocktake compares theoretical and actual levels of all stock items in a store. A partial stocktake only compares the levels of stock items that have been included in a collation report.

Stocktaking results are registered in stocktaking records.

The stocktaking record includes the actual (physical) count of the stock items, which is entered into the collation report. This physical account is compared with theoretical stock levels calculated according to documents. It allows shortages and excesses to be identified in order to adjust stock on hand.

The actual (physical) count is entered into the collation report on the date that the stocktake was actually carried out. Then, after processing in the storekeeping system, the specification panel of the stocktaking record is automatically populated.

When carrying out a full stocktake, the following stock items will be entered into the specification: first, items from the collation report whose actual levels deviate from their theoretical ones and second, items which have been registered but not included into the collation report.

In the case of a partial stocktake, the specification will contain only those stock items from collation reports in which actual levels deviate from theoretical ones.

The stock-out operations in stocktaking records can be taken into account when average standard daily consumption rates for stock items are calculated in the store. In order that stocktaking records be taken into account during calculation, they must be added to the stock-out document types specification in the Document types for calculating standard daily consumption rates panel.

The status of a stocktaking record reflects its current state. Unlike other documents, stocktaking records can have one of four statuses:

  • Not ready – the document is open for changes.

  • Ready – the document is temporarily unavailable for changes and cannot be run on the store.

  • Processed – this status makes the collation report enabled for processing and the specification complete and editable.

  • Registered – assigning this status to the stocktaking record disables editing and makes the document eligible to be processed by the storekeeping system.

The stocktaking record is processed in two stages: during the first stage, the specification is generated, while during the second stage stock on hand is adjusted according to the specification.

Figure 32.192. The entire sequence of operations that the user performs to process stocktaking records


When created, the stocktaking record is assigned the status Not ready. When this status is active, the user is allowed to alter the attributes of the stocktaking record and make changes to the collation report: add new stock items, change attributes of existing stock items, and delete items.

Assigning the Ready status makes the stocktaking record read-only. This stocktaking record cannot be run on the store, and no changes can be made to it. The status "freezes" the document as it is until the user wants to change it.

After filling in the collation report, the user assigns the status Processed to the stocktaking record. The document can then be processed by the storekeeping system. After processing, the specification is generated. The panel will contain only those stock items for which theoretical levels differ from the actual levels specified in the collation report.

While the stocktaking record has the status Processed, the specification containing the physical count data can be edited. The collation report, however, remains read-only.

Stock items with shortages will be deducted according to their cost price. If any stock items are to be added, their prices must be specified. Once these prices are specified, the record can be registered.

After the status Registered has been assigned to the stocktaking record, the user can implement the second stage of processing. During this stage the stock supplies are reconciled with the data specified in the specification. Theoretical levels of stock items for deduction will be lowered by the quantity specified in the Specification panel. Theoretical levels of items to be registered will be increased.

If the status Registered is assigned to the stocktaking record, only the status itself can be changed, not its attributes. As for the collation report and specification, they are read-only.

The Registered status can also be assigned to a document with the Not ready status. This will automatically create the Specification panel, data from which are used to adjust theoretical levels of stock items.

Figure 32.193. Stocktaking record processing with no changes made to the specification


To make the collation report editable again, the Not ready status must be applied to the record. This will delete the contents of the Specification panel. After changes have been made, the Processed status can be applied again, and the Specification panel contents will be repopulated.

Deleted records are given the Deleted status during processing by the storekeeping system.

Stocktaking records can also be created at the POS terminal in Tillypad XL POS). Only partial stocktakes can be carried out at POS terminals. The list of stores for which a stocktake can be carried out depends on the access settings of the POS terminal user.

Stock items in the specification of the stocktaking record also have statuses. These statuses are assigned automatically when the records are processed by the storekeeping system.

A document specification item can have one of the following statuses:

  • OK – denotes that processing was successful.

  • Enter stock-in price – occurs if the price of accepted stock items has not been specified.

  • Not enough on hand in store – occurs if the amount of a stock item specified in a stock-out document is greater than the amount of that stock item on hand in the store.

  • Theoretical on hand stock has changed since last calculation – is applied if the on-hand level was changed during processing.

Stocktaking records for all stores are stored in the Stocktaking records list.