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
Feedback sent
We appreciate your effort and will try to fix the article