Stock Reports

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

Originally written by John Hardwick, last updated Aug 25, 2023, on the Swan Retail knowledge base (FRS).

This section details stock related ‘on demand’ audits produced as an information request by the operator.

Aged Sold Stock

This report is designed to provide the viewer with a breakdown of stock sold but not delivered to the customer, ageing it in weeks and showing the number of days the ‘oldest’ item of stock has been in stock for.

Aged Sold Stock Summary

A report listing all goods which are held in stock for more than the user specified number of days and are allocated to a sales order.

Aged Stock

Bay Allocations

This report provides an audit of which bays are holding which items of stock and / or which bays are currently empty.

Bay Movements

This report provides an audit of stock movements between bays.

Carpet Cutting List

The report lists all ‘measured’ goods which require a ‘cut’ to be performed prior to confirmation of delivery. The cut may be in respect of a sales order or a ‘freestanding’ cut where scheduled.

Colour Cuts

A report detailing the colour combinations of measured goods by range within supplier.

Dead Stock

This report is designed to list stock on hand which haven’t been sold for a specified number of days.

Delivered Product Statistics Report

This report details the deliveries (and collections) processed within the specified date range by SKU showing successful and failed deliveries.

Delivery Manifest (1214 onwards)

This report provides a list of tasks / orders / places to visit for a specified run number and is designed to be plugged in to the DELIVERY_MANIFEST_RPT control within Set Up Report Links.

Delivery Sold Stock Weights

This report shows the weight of goods sold for a specific location.

Freestanding Picking Note (1214 onwards)

This report allows the picking team to find goods for a specific sales order and could be plugged into the side panel of the sales order detail page if desired.

Free Stock List (1214 onwards)

A report showing ‘free to sell’ goods at the specified location(s), grouped by supplier within product group.

Free Stock Summary

A report showing ‘free to sell’ goods at the specified location, grouped by supplier within product group.

Goods Received Audit

This report details all goods receipted within the user specified location and date range.

Grouped by purchase order within receipt location sequenced by GRN number within receipt date, it is possible to see the stock booked in.

The report will show or omit the cost price, dependent upon the setting on the GOODS_REC_AUDIT_SHOW_COSTS application parameter.

Goods Received Export

This report replicates the Goods Received Audit with an output designed to be fed directly into a spreadsheet.

Imperfect Stock Report

This audit is designed to show the viewer all stock, within the report’s selection criteria, marked as imperfect.

Marked Down Stock List

This report is designed to list and value all stock marked down by location, showing the reason why and whether the item is available to be sold.

Mass Stock Load Rejections

This report provides analysis as to why stock failed to be written on when using the ‘mass stock load feature’.

Negative Stock Adjustments

This audit is designed to work with integrated EPOS tills and identifies where stocking levels have gone negative.

Not Displayed Stock

This report produces a list of stock held in the selected stock / warehouse location(s) which is not present in the selected showroom location(s).

Option Usage - Products

This report is designed to list all SKUs where a specific option has been linked. (Effectively, this is a where used report for options / questions).

Option Usage - Products (Choices)

This report is designed to list all SKUs where a specific option and choice has been linked. (Effectively, this is a where used report for options / answers).

Option Usage - Stock

This report is designed to list all stock items where a specific option has been linked. (where used report).

This allows the viewer to see which stock items would be affected if a particular item option combination were to be discontinued.

Required Cuts Report

Designed for measured goods, this report shows stock items where a cut is necessary or has been processed.

Scanned Data Valuation Report

This report is designed to offer the ability to value a manual stock take scan.

Serial Stock Report

This report lists all stock items which are marked as needing a serial number.

Short Roll Carpets

This report shows the measured items which are in stock and not flagged as remnants which are less than the specified minimum roll length.

Stock Aged List

The report enables the generation of an aged stock list. For a specified location / product group combination, the report will show all stock held for more than the specified number of days.

Stock Check

This report produces a list of stock held within physical bays within the location. The output shows system stocking levels to be checked by the audit team.

Stock Check Analysis

The report provides a listing of the items within the stock take. It is possible to drill down into the stock items making up the data.

Stock Cost Analysis

This report is designed to show cost price changes for selected products providing graphical representation of cost movements along with, where required, a detailed analysis of cost changes.

Stock Evaluation (1214 onwards)

This report shows the cost of stock held within the specified location(s) collated by product group and show free to sell, sold or both categories of stock.

Stock Evaluation by Category

This export is designed to feed into personal productivity programs such as Excel and replicates the data content of the Stock Evaluation by Category Report

Stock Evaluation by Category Export

This export is designed to feed into personal productivity programs such as Excel and replicates the data content of the Stock Evaluation by Category Report.

Stock Evaluation Enhanced (1214 onwards)

The enhanced version of the stock evaluation report uses the locations ‘current promotion’ prices to show the potential value if sold at full value using today’s selling price per stock item held within the specified location(s) collated by product group and show free to sell, sold or both categories of stock.

Stock Evaluation Enhanced Export

This report replicates the Stock Evaluation Enhanced Report with an output designed for importing into personal productivity tools such as Excel.

Stock Holding by Bay

This report is designed to show stock held in selected bay locations. It can be used as the start of a manual stock count.

Stock List (1208 to 1211)

This detailed stock holding report shows all stock held within the user specified location, grouped by bay.

Stock List (1214 onwards)

This detailed stock holding report shows all stock held within the user specified location, grouped by bay.

Stock List at Date

A detailed stock holding report with data produced for a given date / time.

Stock List Export

A stock listing report designed to be exported to a third-party application.

Stock List no Options

This stock holding report shows all stock held within the user specified location, grouped by bay.

Stock Movements

The report details goods which need transferring from one location to another.

The second section of the report details transfers which have been part processed.

Stock Options Audit

For products with ‘can assemble’ options, it is possible to change the option at any time prior to scheduling delivery. This audit details these changes.

Stock Position

This audit shows the current stock holding by SKU for the chosen supplier. The report details current stock, sold stock, quantity on demand and on order, thus presenting a balance (negatives effectively indicate a shortage of goods).

A filter allows the operator to view all products, only those flagged as ‘re-orderable’ or those not flagged as ‘re-orderable’.

Stock Replenishment

The report details stock holding for a specified supplier detailing full stock status and purchasing trends over the last six months cumulating in an average sales value which will aid in purchase demand planning.

Stock Report

The report details all stock held within the user specified selection criteria with the ability to show ‘paid for’ (invoiced), pending supplier payment or both. The report also indicates the number of days the goods have been ‘in stock’ A detailed and useful stock report with many potential uses.

The sequencing and order of this report is controlled by the operator and therefore the examples used in this document may differ from those produced on your system, the content and format however are representative.

The report splits data into 2 sections – stock holding followed by sold to customer stock.

Stock Report Export

This report replicates the Stock Report, with its output designed to feed a spreadsheet report.

Stock Representation

This report generates a grid of stock items held at all locations showing the number of items on hand and on display per location grouped by range within supplier.

Stock Take

The report shows system stock levels by location, broken down into bays. Within each bay, the data is presented in SKU within supplier sequence. The operator is expected to enter the actual stock count and therefore the difference per expected stock item.

Stock Take Analysis (1214 onwards)

The report produces an audit / statement re the findings of a stock take (v 1214 onwards).Take

Stock Take by Model

The report shows system stock levels by location, broken down into bays grouped by model. Within each bay, the data is presented in SKU within supplier sequence. The operator is expected to enter the actual stock count and therefore the difference per expected stock item.

Stock Transfer Audit

The report forms an audit of goods sent/received between user specified dates, grouped by either sending or receiving location.

Stock Turn

The report details sales broken down into stock and special order for a given selection range.

Transfer Pick List

The report details sales broken down into stock and special order for a given selection range.

Unsold Special Order Stock

The report is designed to show all stock which was originally special ordered for a customer (The PO was raised as a result of a sales order) which is now free to sell. I.e., the Order was changed or cancelled after the PO was raised / not subsequently cancelled.