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’.
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
Feedback sent
We appreciate your effort and will try to fix the article