Stock Take Guide (1201 onwards)

Created by Migration Bot, Modified on Fri, 23 Oct at 2:30 PM by Migration Bot

Originally written by John Hardwick, last updated Feb 16, 2026, on the Swan Retail knowledge base (FRS).


Based on SwanFRS Release version 1201

Overview

This document describes the stock taking process within SwanFRS.

SwanFRS offers the ability to perform a stock check on goods in a location with the option to spot check by supplier/bay.

Configuration

This section details the control and settings used for stock taking.

Roles

Menu Location: System Admin > Security > Set up Roles

The following user privileges control access to functions and features within the stock taking system.

AMEND_SCANFILES

Allows the amendment of scanned stock take files.

ASSOCIATE_SCANFILES

Allows the linking of scanned stock take files to a stock take list.

CREATE_SNAPSHOTS

Allows the creation of snapshots

STOCK_TAKE_PLAN

Allows the operator to create and complete stock take plans.

STOCK_TAKE_PLAN_ADVANCED

Used in addition to the STOCK_TAKE_PLAN – when the operator has both privileges the user may also edit existing and cancel stock take plans.

VIEW_SCANFILES

Allows the viewing of manual stock take load file contents.

VIEW_SNAPSHOTS

Allows the viewing of computer ‘snapshots’.

Operation

Stock Taking

Stock taking does not attempt to affect stock but to simply advise where potential discrepancies exist therefore allowing an informed decision at to the form of rectification to be taken.  I.e., Once you have compared your manual stock take against that of the computer any difference must be adjusted manually either by transferring, writing off or on the relevant stock item. 

To begin the stock take it is necessary to create a ‘snapshot’ of the data held within SwanFRS.  The term ‘snapshot’ refers to taking a copy of the stock holding and keeping it for comparison purposes later.

Stock Take Plans

Menu Location: Warehouse > Stock Take Plan

Stock take plans are optional and do not influence the stock take process in any way.  These are designed to allow a retailer to pre-plan stock takes and to update the plan as they occur.

This feature acts as diary for stock takes.  The operator can set the date, location and owner of a future stock take and keep the diary up to date.

This part of the system acts as a plan and is not linked to the actual process of performing a stock take.

Clicking FIND shows the stock diary matching the selection criteria.

New Plans

This feature is only available for users possessing the STOCK_TAKE_PLAN privilege.

Clicking NEW allows a new diary date to be added to the plan.

Specify the location, date, and owner of the plan.

If a specific location is selected the routine will allow the setting of specific bay locations for stock take for all locations this is not possible.

  Once the details are correct clicking ACCEPT confirms the plan.

Editing Plans

To edit a plan, it is necessary to use the find option to locate the plan.

The bay location only becomes available if a specific location is chosen.

Clicking the pencil  icon allows the plan to be modified.

Deleting Plans

Clicking the dustbin / trash can cancels the plan.

Cancelling the plan changes the status to cancelled.

A cancelled plan may be re-opened using the pencil icon.

Completing Plans

Clicking COMPLETE icon (shown at the end of the line) sets the plan to complete.

Once completed the status changes to complete.

To re-open the plan, click the pencil icon.

Printing Plans

Clicking the Print icon (shown at the end of the line) produces a plan audit indicating changes applied.

Stock Taking

The SwanFRS stock take is split into the following steps.

  •    Take a copy of the computer’s stock holding - this is referred to as a ‘snapshot’

  •    Create a load file consisting of manually collected stock levels – this is referred to as a scanned data file.

  •    Compare – stock check reporting.

  •    Manually adjust stocking levels within SwanFRS where applicable using the stock transfers, write on and write off routines.

Snapshot Searching

Menu Location: Warehouse > Stock Snapshot Search

To begin the stock take it is necessary to create a ‘snapshot’ of the data held within SwanFRS.   Selecting this menu item presents the following screen.

Field

Comments

Stock Snapshot Reference

Optionally specify the reference to be searched for.

Location

Select the location for the snapshot from the drop-down list. 

Bay

Where applicable select the bay location to be searched for.

Date Created

Specify the date of the stock take.

NEW

Create a new stock take. 

SELECT

Select a stock take from the list shown.

RESET

Reset the screen back to its original load content.

CLOSE

Close the search page and return to the calling point.

New Snapshot

To create a new stock take, select the NEW button, the following screen is displayed.

Field

Comments

Stock Snapshot Reference

Specify the reference for this stock take.

Location

Select the location for the snapshot from the drop-down list. 

Bay

Where applicable select the bay location to be searched for.

Leaving the bay set to ‘not selected’ indicates a stock take is occurring for all bays within the selected location.

CREATE

Click to confirm the selection and take a snapshot of the stock holding.

CANCEL

Click to abort the process and return to the previous window.

Having selected the CREATE button the system will confirm the action with a screen like that shown below –

Viewing Snapshots

To view an existing stock take, either click in the snapshot reference, the following screen is displayed.

Whilst the snapshot has a copy of the computer stocking levels (As at the date and time the snapshot was taken) at this point there are no manually collated stock sheets associated.

Linking Scanned Data to the Stock Take

This option is designed to allow a hand-held scanner to be used and the output file saved on a local disk (on the PC) and for the contents of this file to be ‘uploaded’ onto the SwanFRS system for comparison with the computers stocking level.

This document does not describe how to save the data held on the scanning device on your local PC – please consult your scanner provider for details of how to achieve this.

If the file has already been loaded into SwanFRS but not yet associated to the snapshot by clicking the Associate Other Scanned Data link.  See Free Standing Scanned Data Load for details.

In its initial state there are no ‘scanned’ data files linked to the stock take.  To attach a scanned document, select the Upload and associate other scanned data field.  Selecting this field generates the following display.

Field

Comments

Scanned Data Reference

Specify a reference/ID for the data file to be loaded.

Location

This field auto defaults to that of the stock take.

Bay

Specify the bay location for the scanned data.  Leave as ‘not selected’ to load data relating to multiple bays.

Bay Inclusion

Tick if the load file contains storage bay data.

File Format

Choose the content type of the load file.

  •   SKU only (with optional stock number)

  •   Stock number

  •   Mixed – SKU/Stock number and suppliers bar code.

  •   Mixed stock number and manufacturers ID.

Upload File

Either manually enter the file location or use the CHOOSE FILE button to locate the load file.

To associate complete the load section and click UPLOAD .  The program presents a message once processed indicating success of the reason for a load failure.

The screen will then display the associated file.

It is possible to link multiple ’scan files’ to a single snapshot

If a file is associated in error this can be removed from the snapshot by selecting the Disassociate hyperlink.

Free Standing Scanned Data Load

Menu Location: Warehouse > Scanned Data Search

Where applicable it is possible to load a scanned data file into SwanFRS without linking it to a snapshot. 

To see a list of ‘free standing’ loaded data files click the SELECT button having entered the search criteria required.  This will generate a screen like that shown below.

To load a new data file, select the NEW button to create a new data file or select to view existing data (has it already been loaded) this will request specification of a data reference along with details relating to the location the stock take occurred.

Field

Comments

Scanned Data Reference

Specify a reference/ID for the data file to be loaded.

Location

This field auto defaults to that operator.

Bay

Specify the bay location for the scanned data.  Leave as ‘not selected’ to load data relating to multiple bays.

Bay Inclusion

Tick if the load file contains storage bay data.

File Format

Choose the content type of the load file.

  •     SKU only (with optional stock number)

  •     Stock number

  •     Mixed – SKU/Stock number and suppliers bar code.

  •     Mixed stock number and manufacturers ID.

Upload File

Either manually enter the file location or use the Browse button to locate the load file.

Once the data file has been loaded it may be associated with a snapshot using the process.

The data file may also be edited. This is achieved by entering the search criteria at the top of the screen and clicking SELECT .  This will produce a listing of scanned and uploaded data files (as shown in the example below)

Associate an Existing File Screen

If a free-standing data file is available and should be linked to the snapshot this can be achieved by selecting the associate other scanned data link.

Selecting this option lists all free-standing data files linked to the snapshot's location and optionally bays.

To associate a free-standing scanned data file simply click on the appropriate reference field.

Once attached the view screen will show the associated file with the stock take.

Scanned Data Search

Once a data file has been associated with a stock take it may be necessary to view/amend the content of the file. To view the contents of a scanned data file, select the scanned data search from the stock take menu folder which produces the following screen.

To view the content of a file, click on the underscored file reference. 

Clicking the file reference produces the following screen –

To amend a row, select the pencil icon which will allow a change of scanned quantity only. 

To compare the systems stock level against the scanned stock position run the ‘stock check analysis’ report from the stock reports menu.

It is not possible to delete or add items to the scanned data file.

Stock Check Analysis

Once the snapshot has one or more associated scanned data files SwanFRS can produce an audit report detailing the variances between the data sets.

To compare the manual data with the snapshot taken run the Stock Check Analysis report.

The report will request the ‘name’ of the snapshot file to compare.

Once a location has been chosen the routine allows selection of a snapshot from the list.

Clicking OK generates an exception report like the one shown below –

Acting on the Results

Any exceptions reported need manual resolution.  This may mean –

  •          Generating a stock write on

  •          Generating a stock write off

  •          Re scanning the location

  •          Editing the scan file

  •          Moving stock between locations

  •         Accepting the variance

Goods may also require one or more of their attributes changing, for example flagging an item as damaged. 

Other reports available are

  •          Stock Check Analysis

  •          Stock Check Analysis by Bay

  •          Stock Check Analysis-Loc Restricted.

These reports may be useful when collecting the manual stock list.

  •          Stock Take

  •          Stock Take by Model

Load File Structure

SwanFRS will accept a stock data load file containing one of the following formats.

  •          <SKU code><TAB><Quantity>       

  •          <SKU code><ASTERISK><stock ID><TAB><Quantity>   

  •          <SKU code><TAB><Quantity><TAB><Bay reference>  

  •          <SKU code><ASTERISK><stock ID><TAB><Quantity> <TAB><Bay reference>             

  •          <Stock ID><TAB><Quantity><TAB><bay location>

  •          <Stock ID><TAB>Quantity>

  •          <Manufacturers ID><TAB><Quantity><TAB><bay location>

  •          <Manufacturers ID><TAB>Quantity>

An example (without bay references) of a load file is shown below –

0-2-151    24
10-4-130    65.000
10-4-131    24.000
10-4-134    473
9-8-193*60.00  48
9-1-130 1
8-2-128 50.3146
8-2-136 960.000
8-2-137 12000.000
8-2-147 54.8400
9-1-130 10.0000
9-1-145 29
9-1-146 6
9-1-149 2
9-1-154 1
9-1-193 98

Files from the Confluence page

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article