Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).
Part of: Stock Reports
This export is designed to feed into personal productivity programs such as Excel and replicates the data content of the Stock Evaluation by Category Report.
Crystal report name Stock Evaluation by Cat Export 1
The output is designed for export, and therefore the on-screen display may overlap text.
Selection Criteria
Run time choices, user selectable.
-
Stock Status
-
All Stock / Sold Stock Only / Free to Sell Stock Only
-
-
Restricted Stock Location(s)
Stock holding location or stock ownership location will be used commensurate with the Report by choice.
-
Report by
-
Physical Location / Ownership Location
-
-
Supplier(s)
-
Product Category (ies)
-
Product Group(s)
-
Sales Departments, Level 1 to 3
Print Sequence
As indicated by blue numbered squares in the report example.
-
Not Applicable
Report Totals
As indicated by yellow numbered squares in the report example.
-
There are none
Printed Fields
Fields printed on the report.
-
Current or Ownership Location
-
Product Category
-
SKU
-
Stock Detail ID
-
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
-
Stock Quantity
-
Unit Cost
-
Line Cost (Quantity x Unit Cost)
-
Product Group
-
Stock Notes
-
Sales Department 1
-
Sales Department 2
-
Sales Department 3
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