Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).
Part of: Stock Reports
A detailed stock holding report with data produced for a given date / time.
Crystal report name Stock List at Date 11
Selection Criteria
Run time choices, user selectable.
-
Supplier
-
Stock Holding Location
-
Product Group
-
Include items with zero stock
-
Yes / No
-
-
Report Cut Off Date & Time
The report will use movements to establish what stock was in the selected location as at the specified cut-off date / time.
-
Group By Location
-
Yes / No
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Stock Holding Location (where selected)
2 Supplier / Vendor
3 Range / Collection
4 SKU
Report Totals
As indicated by yellow numbered squares in the report example.
1 SKU with Options
2 SKU
3 Range / Collection
4 Supplier / Vendor
5 Report
Printed Fields
Fields printed on the report.
-
Stock Holding Location (where selected)
-
Supplier / Vendor
This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)
-
Range / Collection
-
Product Description
-
Product Options
-
SKU
-
Stock Detail ID
-
Purchase Order Number
-
Cost (includes Ancillary costs where applicable)
-
Quantity
-
Sales Order Number
-
Product Group
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