Originally written by John Hardwick, last updated Jun 27, 2024, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
This report is designed to show all stock on-hand which was specifically purchased to fulfil customer requirements, which have subsequently been cancelled and are now free to sell.
The report shows the cost and selling value of the stock and the current financial balance of the sales order it is linked to.
Crystal report name Free To Sell Special Order Stock 1
This report only includes ‘on-hand’ stock which was purchased specifically to fulfil customer demand (not internally ordered) and is therefore deemed to be deliverable.
The blue italic text is only displayed when the stock/order/supplier/location format is chosen
Selection Criteria
Run time choices, user selectable.
-
Report Format
-
Order - Location Totals / Order - Supplier - Location - Totals / Stock - Order - Supplier - Location Totals
-
-
Highlight if Delivery Due with X days
-
Restricted Location(s) - Selling Location
-
Include
-
All Orders / Due (using highlight Days) / Overdue Deliveries Only / Overdue and Due Deliveries
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Sales Location
2 Supplier / Vendor (where Selected)
3 Sales Order Number
4 SKU
Report Totals
As indicated by yellow numbered squares in the report example.
1 Sales Order
2 Supplier / Vendor (Where Selected)
3 Location
4 Report Totals
Printed Fields
Fields printed on the report.
-
Selling Location
-
Supplier / Vendor
This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)
-
Sales Order Number
-
Sales Order Stock Cost
-
Sales Order Selling Price
-
Sales Order Date
-
Required Date
-
Early / Part Delivery Indicators
-
Order Total
-
Order Payments
-
SKU
-
Item Cost
-
Item Selling Price
-
Stock ID
-
Product Description
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