Originally written by John Hardwick, last updated Aug 18, 2023, 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.
Crystal report name Aged Sold Stock Report 1
Stock on pending transfer notes (detail format only) show the transfer note number.
Stock linked to service, in detail mode, shows the service call reference.
Deposit percentage background colours
Zero deposit is red,
Less than 10% - light red
Less than 20% - orange
Less than 50% shown in yellow
Less than 100% is light green
Fully paid is green
Overpaid is blue
Selection Criteria
Run time choices, user selectable.
-
Service
-
Show only orders with service / Omit orders with service / Show all orders
-
-
Transfers
-
Show on orders with pending transfers / Omit orders with pending transfers / Show all
-
-
Format
-
Detail / Summary
-
-
Age by
-
Order Creation Date / GRN or Sold Date
-
-
Include
-
Orders with stock ready for delivery / Orders with one or more item in stock
-
-
Contact Status
-
Restricted Stock Holding Location(s)
-
Restricted Selling Location(s)
-
Sequence
-
Stock Holding Location / Selling Location
-
Print Sequence
As indicated by blue numbered squares in the report example.
1 Stock Holding or Selling Location
2 Sales Order Number
3 Stock ID (Detail Only)
Report Totals
As indicated by yellow numbered squares in the report example.
1 Sales Order
2 Stock Holding or Selling Location
3 Report
Printed Fields
Fields printed on the report.
-
Stocking or Selling location
-
Sales Order Number
-
Stock ID (detail only)
-
Age (in Days)
-
Stock Age in Weeks (1,2,3,4 to 8, 8 to 12, over 12)
-
Service ID
-
Transfer Note Number
-
Contact Status
-
Sales Order Total
-
Customer Payment
-
Finance Value
-
Customer to Pay Value
-
Finance to Pay Value
-
Percentage payment against order value.
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