Overstocked Items Report — Features
The 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.
You can choose from four basic reports:
-
Quantity Greater Than Maximum Level. Lists items for which the quantities on hand are more than a specified percentage higher than the maximum levels entered for the items in the Reorder Quantities form.
-
Quantity Greater Than Projected Sales. Lists items for which the quantities on hand are greater over the number of days you specify than the projected sales quantities entered for the period in the Reorder Quantities form.
-
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 specify in the Greater Than field.
-
Most Recent Cost of Excess Quantity. Lists items whose most recent cost is greater than the amount you specify in the Greater Than field.
You can report item quantities for locations that are over the maximum level or over the projected sales figures entered for the items in the Reorder Quantities form. You can include cost figures on the report to see the costs of carrying the extra inventory items.
To print meaningful data on some versions of this report, you must first enter figures for the items in the Reorder Quantities form.
For instructions on printing the report, see Printing the Overstocked Items Report.
Information printed on the report
The report's features differ according to the criterion you select for determining whether items are overstocked.
For example, if you select overstocked items by their annualized turn and earn ratios, the report includes:
-
The quantities on purchase order and sales order, which are entered and updated by Sage ERP Accpac Purchase Orders and Order Entry, respectively.
-
The quantity sold, total sales, and cost amounts posted for the item in the year to date, from the Sales Statistics form.
-
The number of times the company's average inventory has been sold in the year to date, calculated as:
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.
-
The margin percentage, calculated as:
-
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 select overstocked items by the most recent cost of excess quantity, the report includes:
-
The starting and ending dates for the reorder period, as defined in the Reorder Quantities form.
-
The date of the last shipment and receipt of the item.
-
The maximum quantity specified for the item, location, and period entered in the Reorder Quantities form.
-
The amount by which the item quantity on hand exceeds the maximum quantity entered for the item, location, and period in the Reorder Quantities form.
-
The excess cost (excess quantity multiplied by the most recent cost per unit).
You can print this version of the report only if you entered reorder information in the Reorder Quantities form.
See also