Aged Stock

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

Part of: Stock Reports

This report is designed to provide the viewer with a breakdown of stock sold but not delivered to the customer, ageing it in weeks and showing the number of days the ‘oldest’ item of stock has been in stock for. 

• Detailed format without customer omits the customer name and delivery address.

• Stock on pending transfer notes (detail format only) show the transfer note number.

• Stock linked to service, in detail mode, show service call reference.

• Stock notifications - background colours

  • Red Indicate the item cannot be sold

  • Green indicates a display item

  • Yellow indicates sold stock.

Selection Criteria

Run time choices, user selectable.

• Restricted Stock Holding Location(s)

• Product Group(s)

• Format

  • Detail with Customer Information / Detailed / Summary

• Number of Days in stock

• Prices

  • Cost / Selling

• Ageing

  • 30-60-90 / 30-90-180

Print Sequence

As indicated by blue numbered squares in the report example.

1 Stock Holding Location

2 Product Group

3 SKU in Summary mode / GRN in Detailed

Report Totals

As indicated by yellow numbered squares in the report example.

1 Product Group

2 Location

3 Report

Printed Fields

Fields printed on the report.

• Stocking location

• Product Group

• GRN Number (Detailed Only)

• SKU (Summary Only)

• Stock ID (Detailed Only)

• Supplier / Vendor

• Range / Collection

• Model Number

• Product Description

• Product Options (Detailed Only)

• Date Received

• Quantity (Length) in stock

• Current Cost

• Age in stock (banded as specified)

• Actual days displayed per band in detail mode

Attachments (2)

image-20230129-135739.png
37.6 KB

image-20230129-135927.png
24.9 KB