Stock Position

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

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

Part of: Stock Reports


This audit shows the current stock holding by SKU for the chosen supplier.  The report details current stock, sold stock, quantity on demand and on order, thus presenting a balance (negatives effectively indicate a shortage of goods).

A filter allows the operator to view all products, only those flagged as ‘re-orderable’ or those not flagged as ‘re-orderable’.

image-20240628-123548.png

Crystal report name Stock Position 12

The report will highlight shortfalls in stock requirements with a pink background on the stock balance and overall balance columns.

  • Stock Balance = (Current Stock + On Order) less (Sold + Cannot Sell)

  • Overall Balance = (Current Stock + On Order) less (Cannot Sell + Pre Demand + Demand)

  • Demand = Goods waiting to be purchase ordered linked to accepted SO/IOs

  • Pre Demand = Goods on SO/IOs which have never been accepted.

Values are show to 2 decimal places for Measured goods and integer values for Accessory and Uniquely classed items.

Selection Criteria

Run time choices, user selectable.

  • Supplier(s)

  • Restricted Stock Holding Location(s)

  • Show

    • All / Re-Orderable Stock Only / Exclude Re-Orderable Stock

Print Sequence

As indicated by blue numbered squares in the report example.

1 Stock Holding Location

2 Supplier / Vendor

3 SKU

4 Option Choice

Report Totals

As indicated by yellow numbered squares in the report example.

  • There are none.

Printed Fields

Fields printed on the report.

  • Stocking location

  • Supplier / Vendor

This Report will show the catalogue supplier or the supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)

  • SKU

  • Range / Collection

  • Model Number / Supplier Stock Reference

  • Item Description

  • Number of Rolls - Measured goods only

  • Stock Position / Roll length for measured goods

  • Current Stock Quantity / Length

  • Sold Stock

  • Cannot Sell Stock

  • Stock Balance

  • Pre Demand units

  • On Demand Items

  • Overall Balance

  • Re-Orderable Indicator

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