Stock Take Analysis (1214 onwards)

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

Part of: Stock Reports

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

Light green backgrounds indicate matched rows - i.e. the system and scanned data match

Light red backgrounds indicate mismatched data

Selection Criteria

Run time choices, user selectable.

• Group By

  • Supplier / Product Group / Stock Take Bay / Sales Dept 1 / Sales Dept 2 / Sales Dept 3 / Sales Dept 1 & 2 / Sales Dept 1,2 & 3

• Secondary Grouping

  • None /Supplier / Product Group / Stock Take Bay / Sales Dept 1 / Sales Dept 2 / Sales Dept 3 / Sales Dept 1 & 2 / Sales Dept 1,2 & 3

• Supplier(s)

• Product Group(s)

• Include

  • All records / Matched Only / Unmatched Only

• Show Accessory Stock In Detail

  • Yes / No

• Show Ownership Location

  • Yes / No

Print Sequence

As indicated by blue numbered squares in the report example.

1 Group level 1

2 Group level 2 (if selected)

3 Range

4 SKU

5 SKU Options (where applicable)

Report Totals

As indicated by yellow numbered squares in the report example.

1 SKU

2 Group level 2 (where selected)

3 Group level 1

4 Report

Printed Fields

Fields printed on the report.

• Group level 1 (Product Group, Supplier, Bay or Sales department(s) dependant upon selection)

• Group level 2 (Product Group, Supplier, Bay or Sales department(s) dependant upon selection)

• Range / Collection

• SKU

• Supplier’s Model Reference

• Product Description

• Secondary (scannable) barcode for Accessory items

• Product Class

• Item Options (where applicable)

• System Stock ID

• System Bay

• System Quantity

• System unit Cost

• System Line Cost

• System length for measured goods

• Scan Stock ID

• Scan Bay

• Scan Quantity

• Scan unit Cost

• Scan Line Cost

• Row Status

  • Variance both Quantity and Cost (variances shown with red backgrounds)

Attachments (1)

image-20260427-071627.png
215 KB