Originally written by John Hardwick, last updated Aug 23, 2023, on the Swan Retail knowledge base (FRS).
Part of: Stock Reports
This report lists all stock items which are marked as needing a serial number.
Crystal report name Stock Serial Number 2
Items marked with a red font indicate there is no serial number assigned to the item, or the item is delivered without a serial number.
Reclaims: The blue italic text relates to notes added to the stock record containing the word ‘rebate’ and is designed to allow the retailer to track to see if a rebate has been requested / authorised by the supplier.
Spiffs: The blue italic text relates to notes added to the stock record containing the word ‘spiff’ and is designed to allow the retailer to track to see if a spiff has been requested / authorised by the supplier.
Both are controlled via the Set Up Service Events - Action Note
Selection Criteria
Run time choices, user selectable.
-
Supplier(s)
-
Restricted Stock Holding Location(s)
-
Model Number
Optionally, enter a model number, which may contain the wildcard character '*'
-
Include
-
All Serial Stock / Only items with Serial Numbers / Only Items without Serial Numbers
-
-
Stock Status
-
Delivered & On Hand / Delivered Only / On Hand Only
-
-
Include Supplier Reclaims
-
Yes / No
-
-
Include Spiffs
-
Yes / No
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Stock Holding Location
2 Supplier / Vendor
3 Range / Collection
4 SKU
Report Totals
As indicated by yellow numbered squares in the report example.
1 Location
Printed Fields
Fields printed on the report.
-
Stock Holding Location (where applicable prior to delivery to customer)
-
Supplier / Vendor
-
Range / Collection
-
SKU
-
Model Number / Supplier’s Stock Reference
-
Product Description
-
Stock ID
-
Sales Order Number
-
Bay / Storage Location
-
Delivery Run Number
-
Delivery Date
-
Serial Number
-
Stock Status
-
Rebate Notes (where selected)
-
Spiff Notes (where selected)
-
Total Stock Units with Serial Numbers
-
Total Units without Serial Numbers
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