Product Portfolio

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

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

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