Slow Moving Parts List

 
This report prints out a list of parts that are in inventory that have a year usage less than or equal to a user prompted number and were last received prior to a user prompted date. You are prompted for a facility and bin range, as well as a threshold date (will be used to pull last purchases prior to this date), and a usage number. 
This report may be used to help identify slow moving parts to reduce overhead. 
Prints the following: 
 
Report is sorted by: Facility, bin location, and part number 
Part facility number
Bin location
Part number
Part description
Last receive date
Average use per period
Average use per year
Average price
Total cost
Total on hand quantity 
Subtotal by facility on number of parts and total cost and grand total on number of parts and total cost.