Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
This audit is designed to allow the operator to generate a product list with the option to include prices as at a date.
The output contains product information, including any discontinued dates.
Crystal report name Product Portfolio 8
The supplier’s image must reside in the ‘Supplies' subfolder within the stated image folder (Application Parameters IMAGE_PATH) and be named as per the supplier’s name within FRS, saved as a JPG.
If the item is marked as discontinued, the date of discontinue will be shown with a red background if historic or with a yellow background if a future date is set. (This is checked against the current date, not the pricing date of the report.)
The MRP price will show red if less than the selling price.
Where prices exist for more than one location, the system will show multiples per SKU
Selection Criteria
Run time choices, user selectable.
-
Supplier / Vendor
-
Range / Collection
-
Show Prices
-
Yes / No
-
-
Show Supplier Image
-
Yes / No
-
-
Restricted Selling Location(s)
-
Pricing Date
Print Sequence
As indicated by blue numbered squares in the report example.
1 Supplier / Vendor
2 Range / Collection
3 SKU
Report Totals
As indicated by yellow numbered squares in the report example.
-
There are none.
Printed Fields
Fields printed on the report.
-
Supplier / Vendor
This Report will show the catalogue debranded supplier or the debranded supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)
-
Range / Collection
-
SKU
-
Model Reference
-
Product Description
-
Product Group
-
Lead Time (Delivery Days)
-
Discontinued Date
-
MRP / MSRP
-
Selling Price
-
Selling Location
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