inventory control Reports

Excess Inventory Report

Last Revised: 02/06/14

This application displays the excess inventory of any items. Excess inventory is determined by operator-specified excess month on hand quantity. This report can be used to determine which items to promote based on infrequent sales. The report will contain the item number and description, the vendor number, the product class, the warehouse, the available quantity, the minimum quantity, the maximum quantity, the last inc, the last sale, the last month usage, the average monthly usage, the month on hand, the excess quantity, and the value. The top of the report will display the specified amount of excess months on hand.

1. Choose the item sequence.
2. Specify the range.
3. Choose the warehouse(s).
4. Indicate whether or not to include sales by supplied warehouse(s).
5. Indicate whether or not to have a separate page for each warehouse.
6. Specify the months on hand.

 

Excess Inventory Report Key
LTMU	Last Month Usage (in last full month)
AMU	Average Monthly Usage (over last full 12 months)