Stock Report

Created by Migration Bot, Modified on Fri, 23 Oct at 11:28 AM by Migration Bot

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

Part of: Stock Reports


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. 

Crystal report name Stock Report 13

Selection Criteria

Run time choices, user selectable.

  • Include

    • Invoiced & Un-invoiced Stock / Invoiced Stock Only / Un-invoiced Stock Only

  • Stock Class

    • All Stock / Unit Stock / Accessory Stock / Measured Stock

  • Restricted Stock Holding Location(s)

  • Supplier(s)

  • Aged Stock

Enter minimum number of days stock is on hand to be included.

Set to zero to include all items.

  • Group

    • Location (Loc) - Supplier (Sup) - Product Group (PG) / Loc-PG-Sup / PG-Loc-Sup / PG-Sup-Loc / Sup-Sup-Loc-PG / Sup-Loc-PG

  • Format

    • Summary / Detail

Print Sequence

As indicated by blue numbered squares in the report example.

1 Stock Status

This section has two groups ‘Stock Holding’ & 'Sold To Customer'

2 Stock Class

3 Group 1

4 Group 2

5 Group 3

6 Stock ID

Report Totals

As indicated by yellow numbered squares in the report example.

1 Group 1

2 Group 2

3 Group 3

4 Location

5 Stock Status

6 Report

Printed Fields

Fields printed on the report.

  • Stock Status

  • Stock Class

  • Location

  • Supplier / Vendor

This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)

  • Product Group

  • Stock ID

  • SKU

  • Range / Collection

  • Model Number / Supplier Stock Reference

  • Product Description & Options

  • Internal Order

  • Sales Order Number

  • Purchase Order Number

  • GRN Number

  • Can Sell

  • Display Item

  • Stock Category

  • Mark Down

  • Cut Carpet

  • Quantity

  • Unit Cost

  • Line Cost

  • Measured length

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