Stock Take Guide (1214 onwards)

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

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


Overview

The stock taking process was redesigned in version 1214 to make use of a real-time hand held scanner.

Stock taking may form part of a full audit of your systems data. To assist with auditing we have the following recommendations.

  • SwanFRS reporting is designed to produce stock audits using ‘real-time’ figures, with the exception of the Stock List At Date report (and its variants). This report builds a stock figure from movements created since ‘going-live’ with SwanFRS. It’s data can be changed by any ‘retrospective’ transactions processed within SwanFRS and therefore should not be used to ‘prove' stock values.

    • SwanFRS offers the ability to catch up with transactions. i.e. Enter a working date when logging in to the system to the selection of historic confirmation dates. If the date selected falls before the audit date, the action has the potential to change the results of audits produced at the ‘cut-off' date. It is therefore recommended that all ‘retrospective processing' is completed before producing audit reporting. It is recommended that all stock transfers, write on’s, off’s and deliveries are completed before generating financial and stock values.

    • Ideally stock take values should be obtained by running one of the real time reports such as Stock on Hand, Stock Evaluation and the output saved to file. Save as a PDF and also save in an raw data format such as Excel, CSV or RTF.

    • If using Stock List At Date, run the report for today and compare to a stock list report - any variances should be raised as a support ticket.

  • In addition to running stock reporting also ensure you have a data backup corresponding to the audit date and ensure it is stored in a safe place, should this be needed in the future. For Hosted operators please ensure your Account Manager is aware of the ‘cut off date’ or raise a support ticket, This will enable Swan to ensure the relevant back-up is generated. This process should run alongside your daily / regular security practices.

  • Note the NOMINAL_TRANSACTION_MODE , simple allows retrospective transactions to be processed. when set to Sync historic transactions are restricted and effectively can be prohibited completely. For more information please discuss with your Account Manager.

The option to generate a load file via other means remains however scanning barcodes to provide a stock position reduces the overheads in producing a stock take.

The Wi-Fi Scanner requires a licence to operate and is documented in the Wi-Fi Warehousing (1214 onwards) guide.

Previous versions of SwanFRS have used the following terms.

  • Scan - This refers to a manually generated set of data which is used to ‘match’ against a system generated stock holding.

  • Snapshot - This is the name given to the systems copy of the stock holding at the time a stock take was created. This is effectively SwanFRS’s stock holding position and is used to calculate what ‘actions' need to be taken when processing anomalies between Scanned and System data.

Wherever possible these two terms have been removed from the system, it now refers to scanned data and stock data.

Configuration

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

Application Parameters

Menu Location: System Admin > Security > Set up Application Parameters

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

STOCK_TAKE_AUTO_CHANGE_BAY

Ticking instructs the Wi-Fi Stock take process to automatically move scanned stock from its ‘current’ bay into the scanned data file bay.

This is effectively a put-away operation ensuring the bay SwanFRS ‘thinks’ the stock is in, is accurate.

An audit of the bay transfer is made as the item is scanned with the bay transfer taking immediate effect.

When unticked, the scan process records the fact the stock is in a variant bay but does not apply a bay transfer, thus leaving it for manual change or for the stock take completion process to address later in the stock take processing cycle.

When processing accessory goods the system will not move the bay a stock item is held in when completing the stock take. For accessory goods the system builds write off and write on notes instead.

STOCK_TAKE_AUTO_TRANSFER

Ticking instructs the Wi-Fi Stock take process to automatically transfer scanned stock from its ‘current location’ into the scanned location / bay.

This is effectively a ‘stock transfer' operation ensuring the scanned stock is now recorded in the specified location and bay combination.

An audit of the inter-location movement (stock transfer) is made as the item is scanned with the transfer taking immediate effect.

When unticked, the scan process records the fact the stock is in a variant location (and therefore bay), but does not apply a transfer, thus leaving it for manual change or for the stock take completion process to address later in the stock takes processing cycle.

STOCK_TAKE_EXCLUDE_SCHEDULED

Ticking instructs the stock take creation process to exclude any stock scheduled for delivery from the systems stock holding. I.e. the stock take will ignore any stock scheduled for customer delivery and as such will not be considered in it’s matching process.

Unticking instructs the system to include stock on hand irrespective of whether it is due to be delivered to a customer.

STOCK_TAKE_MODE

When processing the collection of scanned stock data via the Wi-Fi scanner the system will operate in one of two modes

  • Scan Stock First - This mode allows the operator to ‘define’ the bay and then loops around requesting stock barcodes, meaning the operator has to select the bay to change it.

  • Scan Bay First - This mode moves control back the bay field after each barcode scan.

Please note that when the BLOCK_BLANK_OPTION_ANSWER application parameter is ticked it may cause the stock take analysis report to omit option descriptions. This will not affect the matching process but may cause confusion when viewing mismatched details.

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.

SCANNER_STOCK_TAKE

Allows the operator to collect ‘scan’ data via a Wi-Fi scanning device.

SELECT_SCANFILE_LOCATION

Allows the operator to choose which location (from their visible list) the stock take is to be performed for.

STOCK_TAKE_CANCEL

Allows the operator to cancel a stock take effectively completing it without applying any adjustments.

STOCK_TAKE_COMPLETE

Allows the operator to complete a stock take which will, where appropriate, create a series of ‘open’ transfers and adjustments.

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.

UPLOAD_SCANFILES

Not directly linked to stock taking, this privilege allows the operator to ‘load’ an externally collated data file into SwanFRS for onwards processing.

VIEW_SCANFILES

Allows the viewing of manual stock take load file contents.

VIEW_SNAPSHOTS

Allows the viewing of computer ‘snapshots’.

Operation

Stock Taking Plans

This is an optional feature and simply reminds the designated party that a stock take is scheduled.

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.

  • Create a stock take - this process captures the stock holding in the specified location (and bays) which is then used to match against manually captured data and results in a audit of matches and exceptions.

  • Capturing scanned data - At the same time a stock take is created, and preferably before any stock moves, a list of ‘found’ stock should be collated. This may be in one or many data files which can then be ‘linked’ to the stock take

  • Comparing the data - Once the manual capture capture of the stock holding is complete and all data files have been linked to the stock take, the comparison process produces an audit of matches and exceptions for analysis

  • Completing the stock take - having reviewed the audit (and having made any appropriate adjustments), completing the stock take applies the findings of the comparison process by creating stock transfers and write off’s by moving stock within bays. Transfers and write off’s require completion before these actions are confirmed.

Stock Takes

Menu Location: Warehouse > Search Stock Takes

This process allows the operator to view and subject to permission create a stock take.

On loading the page offers a series of selection criteria.

image-20260216-110500.png

To find existing stock takes and their status the filters can be used to ‘focus in on' desired results.

Field

Comments

Stock Take Reference

Text entered here is used to search against stock take titles.

The search will look for the combination of characters anywhere in the stock take ‘name’.

Location

Specify the ‘location’ where the stock take occurred.

Bay

Select the bays included within the stock take.

Status

Choose the current status of the stock take

  • All

  • Created

  • In Progress

  • Closed

  • Cancelled

Date Range

Specify a start / end date range and relates to the date the stock take was created.

Ignore Date Range

Tick if the date range filter is to be ignored.

NEW

Create a new stock take. 

FIND

Select to search for stock takes matching the search criteria.

RESET

Reset the screen back to its original load content.

CLOSE

Close the search page and return to the calling point.

New Stock Takes

Clicking the NEW button instructs the system to create a new stock take.

image-20260216-112130.png

Field

Comments

Stock Take Reference

Specify the name for this stock take.

It is suggested the name be meaningful as it will form a searchable reference and appear on literature

Location

Specify the ‘location’ where the stock take occurred.

Bay

Select the bay or bays this stock take includes. One, some or all bays defined within the specified location can be selected.

Once the stock take has been defined click the CREATE button to build the stock take.

If this page has been reached in error, clicking CANCEL or the back option on the side panel cancels the creation process.

Clicking CREATE takes a copy of the stock ‘on hand’ within the specified location which forms the ‘base data’ from which the stock take comparison process will operate.

At this point the stock take is given the CREATED status.

Once completed a notice similar to that shown below will be displayed

image-20260216-112923.png

Click the OK button to proceed.

Finding existing Stock Takes - Search Results

Clicking the FIND button instructs the system to use any specified search filters to produce a list of matching stock takes.

image-20260216-111426.png

The list will can be resequenced by reference, date and time of creation or closure date.

Stock Take Details

Clicking the stock take reference displays the details of the stock take.

image-20260216-113015.pngimage-20260216-120829.png

Subject to the status of the stock take the screen will display the header, a list of associated files and a series of action buttons in the top right of the page.

Cancelling a Stock Take

When the stock take is in the CREATED state it is possible to cancel it (subject to permission) via the CANCEL STOCK TAKE button. Once cancelled the status changes to CANCELLED and no further processing is allowed. A confirmation message is presented to screen.

image-20260216-113315.png

If the stock take has scanned data files attached these must be removed (disassociated) before the stock take can be cancelled.

Once a stock take has been completed it cannot be cancelled.

Once cancelled it cannot be re-opened.

Associating Scanned Data Files

To complete a stock take it must have at least one ‘scanned’ data file linked to it.

This can be achieved directly via the Wi-Fi scanning device or by associating data files collated by other means.

It is possible to create a ‘free-standing’ data file via the Wi-Fi scanner and associate it manually with a stock take should this be necessary.

To link a scanned data file to a stock take, select the LINK FILES or UPLOAD FILE buttons.

Linked Files

Selecting LINK FILES presents a page listing all scanned data files which have not been associated to a stock take.

It is possible to ‘filter’ the data using the available filters prior to clicking FIND or to move to the data file upload process by clicking the UPLOAD FILE button.

image-20260216-114111.png

At this point it is possible to

Option

Comment

Tick the row (A/N or at line level)

This indicates the data file it is to be added to the stock take.

When ready to do so, click the LINK SELECTED button.

View the details of the data file

Clicking the file name displays the contents of the data file.

image-20260216-114439.png

This page allows the quantity to be changed via the icon.

It is not possible to delete a row however the quantity can be changed to zero which effectively cancels the line.

Where items have been scanned (via the SwanFRS Wi-Fi process) as part of a free-standing data file which resulted in a stock transfer (inter-location), or a bay transfer, the transfer note and bay details will be displayed.

LINK

Clicking the LINK button adds the selected data file to the stock take and closes the listing having presented a confirmation message.

image-20260216-115226.png

Clicking the dustbin / trash can deletes the data file from the system again producing a confirmation notice.

image-20260216-115454.png

This page can also be accessed via the Search Scanned Data routine within the Warehouse menu. When accessed via the menu it will also show associated data files - these will have a status of IN PROGRESS

Once a stock take has a linked data file the status of the stock take will change to IN PROGRESS

Any number of data files can be linked to a single stock take (and removed from it where necessary).

Upload File

If SwanFRS is not aware of a data file, this can be uploaded to the system via the UPLOAD FILE button.

Selecting presents the following page.

image-20260216-115950.png

It is important to give the file a meaningful filename and specify the appropriate details. The BROWSE button can then be used to locate the file on the local server before clicking UPLOAD which will pull the file into the application.

There are a number of acceptable file structures.

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

Dependent upon where the upload process was instigated the file will either be automatically linked to the stock take or become a free standing data file.

Processing a Stock Take

Once a stock take has the IN PROGRESS status it is possible to run a comparison of data. Pressing the PROCESS DATA button, instructs the system to compare the system data (captured when the stock take was created) against the linked data files and to produce an audit of the results.

Due to data volumes it may take a few moments for the completed message to appear.

image-20260216-121331.png

At this point the buttons along the top of the stock take offer a RE-PROCESS DATA and an ANALYSIS REPORT button.

It is still possible to adjust the linked data files and to change their composition however if this occurs it will be necessary to re-process / analyse the stock take.

Analysis report

It is possible to link in a different analysis report if desired however the standard offering provides the following selection criteria.

image-20260216-121730.pngimage-20260216-122052.png

For more details see the Stock Take Analysis (1214 onwards)

The report can be run as many times as necessary.

Completing the Stock Take

To allow the stock take to be completed the report must have been run and the Complete button selected on the side panel.

At this point the stock take offers the COMPLETE button.

Selecting it instructs the system to adjust mismatched stock - this may take a short while to complete, however once completed the following message will display.

image-20260216-122402.png

Completing a stock take may result in one, some of all of the following

  • Stock is moved to a new bay location.

  • A stock transfer is created and populated with goods to be move from their current location to the stock takes location.

  • A stock write off is created and populated with stock held in the stock take location which did not present in any (scanned) data file associated with the stock take.

Bay transfers are completed, whereas stock transfers and write off’s will require manual intervention to complete them.

At this point the stock take status is set to COMPLETED. No further activity is possible against this stock take however it is possible to re-generate the analysis report via the ANALYSIS REPORT button.

Scanned Data

Menu Location: Warehouse > Search Scanned Data

This routine allows the operator to view ‘scanned’ data files once they are visible to SwanFRS.

When selected from the menu the screen displays a series of selection criteria.

image-20260216-130616.png

o find existing stock takes and their status the filters can be used to ‘focus in on' desired results.

Field

Comments

Stock Take Reference

Text entered here is used to search against stock take titles.

The search will look for the combination of characters anywhere in the stock take ‘name’.

When used this restricts the result to data files associated to stock takes where its name matches the search pattern.

Scanned Data Reference

Text entered here is used to search against manually collated data file names.

The search will look for the combination of characters anywhere in the data file ‘name’.

Location

Specify the ‘location’ associated with the data file.

Bay

Select the bays included within the data files.

Date Range

Specify a start / end date range and relates to the date the data file was created (for Wi-Fi data) or Uploaded (for manually uploaded files).

Ignore Date Range

Tick if the date range filter is to be ignored.

UPLOAD FILE

Create a new stock take. 

This process is documented above https://swanretail.atlassian.net/wiki/spaces/FRS/pages/edit-v2/3337551873#Upload-File

FIND

Select to search for data file matching the search criteria.

RESET

Reset the screen back to its original load content.

CLOSE

Close the search page and return to the calling point.

Search Results

When searching for data files any matches found are listed as shown below

image-20260216-132026.png

The status of the data file dictates the available actions

  • CREATED These files have been loaded but as yet not linked to a stock take and can therefore be amended, linked to a stock take, or deleted

  • IN PROGRESS This file is linked to a stock take and can therefore be amended but cannot be linked to a second stock take or deleted.

  • COMPLETED These files are linked to a completed stock take and can no longer be edited, assigned to other stock takes, or be deleted.

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