Stocktaking Comparison
When you carry out a stocktake, you should enter the results to a new record in the
Stocktaking register. After you approve this record, you can compare its contents ("Counted Quantities" of each
Stocked Item) with current stock levels in FirstOffice using this report. Once you have checked the report and confirmed it to be correct, you can enter any discrepancies shown in the report to the
Stock Depreciation or
Goods Receipt registers, depending on the reason for the discrepancy.
Please click
here for details about the Location field added to the specification window by the Stock Locations Value Pack.
- Item No.
- Paste Special
Item register
- Range Reporting Alpha
- Enter an Item Number (or range of numbers) to include specific Item(s) in the report. Use a colon (:) to separate the first and last number.
- Only Stocked Items in the range will be shown (not Plain Items).
- Group
- Paste Special
Item Groups setting, Sales Ledger
- Range Reporting Alpha
- Enter an Item Group Code to produce a report covering the Stocked Items in a particular Item Group.
- Date
- Paste Special
Choose date
- Enter a date to produce a report for a specific date.
- If you do not enter a date or if you specify a date for which no Stocktaking record exists, all Counted Quantities will be zero.
- If Item not on last Stocktaking assume 0 in Stock
- In order to find the Counted Quantity of an Item, this option looks to the Stocktaking record for the specified date to find a reference to the Item in question. If no date was specified, it looks to the most recent Stocktaking record. If the Item is not included in that Stocktaking record, it will assume the stock level in FirstOffice and the Counted Quantity are both zero. So, no discrepancy will be shown.
- If you accidentally specify a date for which there is no Stocktaking record, the report will assume the stock levels and Counted Quantities for all Items are zero. So no discrepancies will be shown, even when some are expected.
- You might use this option in the situation where you have not finished with the stocktaking process, so you do not want discrepancies shown for Items that you have not counted yet.
Introduction to Reports in the Stock Module
