Serial Stock Report

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

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

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