Overview
The I/C Overstocked Items report lists each item at each location for which the quantity on hand (plus the quantity on PO minus the quantity on sales order) exceeds the maximum or projected sales quantity assigned for the item and location.
Choose one of the following report versions:
- Quantity Greater than Maximum Level. Lists items for which the quantities on hand exceed the maximum levels by the percentage you specify. The maximum quantities for the items are from the I/C Reorder Quantities screen.
- Quantity Greater than Projected Sales. Lists items for which the quantities on hand are greater than the projected sales quantities over the number of days you specify. The projected sales for the items are from the I/C Reorder Quantities screen.
- Annualized Turn and Earn Ratio. Lists items for which the ratio of the inventory turnover rate to the profit margin is less than the percentage you specify.
- Average Cost of Excess Quantity. Lists items with an actual cost that is greater than the amount you specifyfor Greater than..
- Most Recent Cost of Excess Quantity. Lists items whose most recent cost is greater than the amount you specify for Greater than.
You can generate the report for all locations or a range of locations.
When to Print
Print the Overstocked Items report when you want to see which items are overstocked , or when you want to determine whether to redistribute overstocked items to other locations.
Information Printed on This Report
The information on the report depends on the version of the report that you select.
If you selected the annualized turn and earn ratio version of this report, the report includes:
- Item number, description, and location.
- Quantities on hand, on purchase order, and on sales order, which are entered and updated by Sage 300 Purchase Orders and Order Entry, respectively.
- Stocking unit, quantity sold YTD, sales YTD, and cost YTD (from the I/C Sales Statistics screen).
- Turnover rate, based on the number of times the item was sold in the year to date, calculated as follows:
Inventory Control calculates the number of days gone by in the year by subtracting the session date from the first day in the current fiscal year.
- Margin percentage, calculated as follows:
- The turn and earn ratio, calculated by multiplying the YTD turnover by the margin. (The ratio may not exactly equal the YTD turnover multiplied by the margin percentage because the report rounds figures to two decimal places.)
If you selected the version of the report that includes overstocked items by the most recent cost of excess quantity, the report includes:
- Item number, description, and location.
- Quantities on hand, on purchase order, and on sales order.
- Reorder start and end dates for the reorder period (from the I/C Reorder Quantities screen).
- Date of the last shipment and date of the last receipt of the item.
- Maximum quantity for the item (from the I/C Reorder Quantities screen), location, and period entered in the Reorder Quantities screen.
- Excess quantity and most recent cost of the item.
- Excess cost (calculated by multiplying the excess quantity by the most recent cost).