Originally written by John Hardwick, last updated Aug 14, 2023, on the Swan Retail knowledge base (FRS).
This training guide details how to perform a stock take within SwanFRS
Click to Download a PDF version of this document
FRS-10. Stock Taking-140823-150923.pdf
By following this document, you will be able to check stocking levels and take the appropriate action to adjust, where necessary, within SwanFRS.
The aim of these training notes is to give you a quick reference booklet following the training session, and you are encouraged to make your notes within these pages.
This document covers the very basic stock taking process. There are a myriad of permutations and possibilities relating to this not covered by this guide, therefore it is recommended this be the start of your familiarisation process. It is useful to understand the concepts of SwanFRS’s sales, purchasing and stock management. Continue to use the test systems to explore the system and to scenario test.
Manual Stock Checks
There are a number of reports in the system designed to produce a stock list.
Report Examples
Reports provide a listing of stock (possibly) at a date which can be used as a check sheet
Stock Taking
SwanFRS offers an electronic stock take comparison process whereby a picture of the stock holding is compared to a manually collated list of stock, detailing variances between the two sets of data.
SwanFRS refers to a computer picture of the stock position as a Snapshot.
This is ‘taken’ when the stock take is created and records the position of ALL stock in the system at this time.
This is then compared to a manual count of stock at a later date, presenting a variances list.
Menu Location: Warehouse > Stock Snapshot Search
-
Click NEW to create a new stock take (snapshot)
-
Having entered search criteria, clicking SELECT lists the stock takes known to SwanFRS
-
Stock takes are linked to a specific location, optionally bays, and have a ‘snapshot’ date and time.
New Stock Takes
Clicking NEW generates the following screen
-
Snapshot Reference - Give the stock take a name
-
Location - Which location is the stock take for.
-
Bay - Optionally choose the bay location(s) this stock take includes.
-
Control & A selects all bays
-
Shift & click to choose disparate bays
-
Click on First bay, hold Control and click last item for a range
-
-
Click CREATE to generate the snapshot
-
Click CANCEL to abort and return to menu
SwanFRS now hold an immovable record of stock at the time the stock take was created.
Search results show the date and time stock takes were created, which should coincide with the act of recording stock in the selected bay / location combination.
Stock should not be allowed to move during the time of collecting the manual data to minimise the number of variants reported by the system.
Manual Stock Collection
There are a number of ways to link manually collected stock take data with a computer generated snapshot.
SwanFRS refers to a manually collected stock lists as a Scanned Data.
One or more scanned data files can be associated with a stock take.
Menu Location: Warehouse > Scanned Data Search
-
Click NEW to create a new scanned data file.
-
Having entered search criteria, clicking SELECT lists the scanned data files known to SwanFRS
-
Click on the file name (Reference) to view its contents.
-
The allows modification of the quantity and bay location of the scanned line.
-
Items cannot be added or deleted
New Scanned Data Files
Click the NEW button to inform SwanFRS of a new scanned data file.
-
Scanned Data Reference - enter the filename for this data set.
-
Location - Which location is the stock take for.
-
Bay - Optionally choose the bay location(s) this stock take includes.
-
Control & A selects all bays
-
Shift & click to choose disparate bays
-
Click on First bay, hold Control and click last item for a range
-
Tick checkbox if load file contains bays
-
-
File Format
-
choose from SKU, Stock Number, or Mixed.
-
-
Click the CHOOSE FILE button to locate the scanned data file on your local PC to be added to the database.
-
Click UPLOAD to process the data file.
-
Click CANCEL to abort the process
Associating Scanned Data Files
Menu Location: Warehouse > Stock Snapshot Search
The process of linking scanned data to snapshot data is via.
Find the snapshot you wish to link the scanned data with via the search and click on the name.
-
Click Associate Other Scanned Data to link a scanned data file previously loaded into the database.
-
Click Upload and Associate Other Scanned Data to load and link at the same time.
-
Click Reference to associate it with the snapshot
Clicking moves the item to the associated list
-
Click Disassociate to unlink a file previously associated with the snapshot
Clicking upload and link presents the load panel.
Stock Check Analysis
Once all scanned files have been associated with the snapshot, the Stock Check Analysis report can be produced.
The report can be configured to show only exceptions.
These are
-
Snapshot data not present in the scanned data file set.
-
Scanned data not present in the computers' Snapshot
-
Product in the wrong location / bay location.
Adjustments
SwanFRS does not attempt to make any stock adjustments.
Once an adjustment has been confirmed, one of the following actions should be taken
-
Write On stock found during the stock take
-
Write Off stock identified as missing during the stock take
-
Move stock to the correct bay location.
-
Move stock to the correct location.
Files from the Confluence page
- FRS-09. Invoice Matching-140823-105815.pdf
- FRS-06. Delivery Planning-040823-152320.pdf
- FRS-04. Goods Receipting-040823-092251.pdf
- FRS-02. Sales Ordering-030823-071505 (1).pdf
- 02. Sales Orders.pdf
- FRS-03. Purchase Ordering-030823-124958.pdf
- FRS-05. Delivery Scheduling-040823-101822.pdf
- FRS-08. End of Day Processing-090823-071107.pdf
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