Performing A Custom Stocktake

Performing A Custom Stocktake

InfoBefore following the instructions on this article, it is advisable that you read the Overview of Stocktaking article.
A custom stocktake can be useful if you only want to stocktake specific departments, categories, brands or suppliers without affecting any of your other stock items. It involves the follow:
  1. Creating a list of stock based on specified criteria (suppliers, departments, categories etc.)
  2. Only items in the list will be affected by counting and clearing stock on hand figures.
  3. Sales can be performed during the stocktake.
  4. Arrivals should not be performed during stocktake.

Starting a Custom Stocktake

InfoWe have a video guide on how to stocktake in Retailer - ðŸŽ¬ Stocktaking
Idea
Our Custom Stocktake Examples advice sheet contains specific instructions for creating various Custom Stocktakes
  1. On the top menu bar in Retailer, click on Stock Maintenance → Stocktake → Stocktake.
  2. Click the New Stocktake button on the top-left.
  3. Select New Custom Stocktake.
  4. At the top of the new screen that appears, click the Search button to access the Advanced Stock Search feature.
    You can use the Search button multiple times to create a list of multiple criteria.
    1. Select the criteria of stock that you want to perform a stocktake on.
    2. Click Search.
  5. You can repeat step 4 to add more stock to the stocktake list.
  6. Once you're done building the stock list, click OK in the bottom left.
  7. The stocktake screen will now be populated with the selected items.
  8. Enter a description of the stocktake in Stocktake Name.

Performing a Custom Stocktake

  1. Tick Prompt when user scans an item not currently in the grid on the top-right.
  2. To start counting items, click in Scan Barcode/PLU and scan your first item.
    Then, type the number of items in the Quantity field and press [Enter].
    1. You can also tick Show number pad to display a number pad to the right of the Stocktake window in Retailer, as seen below.

    2. To count items by scanning each item individually (i.e scan three items separately - you have counted three), tick the box Count by scanning individual items. This will stop the quantity field being used and every scan will increase the quantity by one.
  3. Alternatively, change the counted quantity directly in the grid.

Editing Scanned Items

Once you've scanned items into the grid, they can be edited accordingly:
To change the counted number of a particular stock item: 
  1. Click on the Counted Qty field for the particular stock item.
  2. Enter the new quantity. Alternatively, click on the drop-down arrow to access the numeric keypad.
  3. Press [Enter].
To change the Department, Category, Cost Prices, Sell Price, Supplier and Supplier Stock Code:
  1. Click on the respective field in the panel on the right.
  2. Enter the new value or click on the drop-down arrow to select it from the list.

Finishing a Custom Stocktake

Once you have scanned all the stock items in the store you can process the stocktake and update all the quantities in retailer.
  1. Click the Process button in the bottom-right corner.
  2. You will be asked Are you sure you wish to process this stocktake?
    Only click Yes if you are confident you have scanned everything in store as this process cannot be undone.
  3. Next, you will be asked Do you wish to reset the QOH for items in this list that were not stocktaked to 0?
    Select Yes to clear the quantity on hand for items, on the list, that were not counted. Otherwise, click No.
  4. You will then be asked to confirm this choice. Select Yes to this message.
  5. The stocktake will be processed. It is now closed and cannot be edited anymore.
AlertStocktaking a large amount of stock items will create some backend-processing load. If you are stocktaking more than 1000 items at a time, please contact Tower Support during business hours after processing, to prevent Retailer from freezing up.

Reporting on a Custom Stocktake

To view the total count of your current stocktake:
  1. Click the Report button at the bottom right corner.
  2. Untick Only show items with a discrepancy.
  3. Click OK.
To view a discrepancy report for the stocktake:
  1. Click the Report button at the bottom right corner.
  2. Tick Only show items with a discrepancy.
  3. Click OK.
This report will show you all items stocktaked and any discrepancies will show against each item.
Use this report to find items that were missed or miscounted during stocktake to reduce your discrepancy.
The Stocktake Discrepancy Report can also be used.

To view a complete stock-on-hand report, use the General Stock Listing report:
  1. On the top menu bar of Retailer, click on Reports → Stock Reports → Stock Listing Reports → General Stock Listing.
  2. Select the options based on your needs.
  3. Click Preview or Print.
    • Related Articles

    • Overview of Stocktaking in Retailer

      This article provides a brief overview of what to do before a stocktake, the types of stocktakes available in Retailer, and some frequently asked questions about stocktaking. Before beginning your stocktake, we recommend that you read the Stocktake ...
    • Best Practice for Stocktaking

      This advice below is about the best business approach to undertaking a stocktake. For information on how to actually use the software for stocktaking, click HERE Use the Latest Version of Retailer Please ensure you have the latest version of Retailer ...
    • Performing a Full Store (Whole store) Stocktake

      The instructions below are intended for stocktaking in Retailer 2.6.1 or later. If you are running a version older than this, click HERE for instructions on updating to the latest version. Before following the instructions on this article, it is ...
    • Performing a Spot Stocktake

      The instructions below are intended for stocktaking in Retailer 2.6.1 or later. If you are running a version older than this, click HERE for instructions on updating to the latest version. Before following the instructions on this article, it is ...
    • Custom Stocktake Examples

      Below are specific steps for different Custom Stocktakes you can perform. This is achieved using Filtering in Stock Manager. Click HERE for more information on performing a Custom Stocktake. Stocktake Items by Department or Category On the top menu ...