Unsold Special Order Stock

Originally written by John Hardwick, last updated Apr 29, 2024, on the Swan Retail knowledge base (FRS).

Part of: Stock Reports

The report is designed to show all stock which was originally special ordered for a customer (The PO was raised as a result of a sales order) which is now free to sell. I.e., the Order was changed or cancelled after the PO was raised / not subsequently cancelled.

Where the stock has been marked down, the markdown reason and revised selling price are shown in red.

Selection Criteria

Run time choices, user selectable.

• Group By

  • Stock by Supplier within Location / Stock By Location

• Restricted Stock Holding Location(s)

• Include

  • Show Option Choices / Hide Option Choices

Print Sequence

As indicated by blue numbered squares in the report example.

1 Raised Date

2 Supplier

3 Purchase Order Number

Report Totals

As indicated by yellow numbered squares in the report example.

1 Supplier / Vendor

2 Location

3 Report

Printed Fields

Fields printed on the report.

• Stocking location

• Supplier / Vendor

• Stock Detail ID

• SKU

• Product Description

• Product Options (where selected)

• Current Cost

• MRP

• Standard Selling Price

• Marked Down Selling Price (where set)

• Mark Down Discount Percentage

• Mark Down Reason

• Product Category

• For Sale Indicator

• Free to Sell Indicator

• Imperfect Indicator

Attachments (1)

image-20230119-150002.png
30.7 KB