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.
|
|
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.
|
|
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
Feedback sent
We appreciate your effort and will try to fix the article