Deliverable Special Order Stock

Created by Migration Bot, Modified on Fri, 23 Oct at 11:26 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 report is designed to show all stock on-hand which was specifically purchased to fulfil customer requirements but has not been delivered.

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 Deliverable 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

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