For every organization, analyzing their inventory is an important aspect to maintain the stock level at respective inventory location. In Sage 300 ERP there are many useful inventory reports that help to manage the inventory efficiently. In our today’s blog we will discuss about the Overstocked Items report in Sage 300 ERP.
Overstocked item report is important when we want to estimate the cost of excess stock, or when we want to determine whether to redistribute overstocked items to other locations. The Overstocked Items report lists each item at each location for which the quantity on hand exceeds the maximum or projected sales quantity assigned for the item and location.
This report also provides 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. Here, the user can also have an option to find out the costs of carrying the extra inventory items.
Before printing this report, the user has to make sure that he/she has run the Day End Processing, this will include the latest costing information in the report.
To print the Overstocked Items report Inventory Control–>I/C Stock Control Reports–>Overstocked Items
New Stuff: How Deposit date in AR receipt entry plays important role in Bank Reconciliation

Basically there are five 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 that specify on UI.
• 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.
Refer the below sample report output:


Hence, using the Overstocked items Report, the Annualized Turn and Earn Ratio version of this report helps to find out company’s average inventory sale during the year to date and can also help to shows the profit margin, total sales, and total cost for each item in the year to date.
Also Read:
1.Stock summary Report
2.Date wise IC stock Transaction Report
3.IC Aged Inventory Report
4.Inventory Movement Report in Sage 300 ERP
5.Stock Aging Report in Sage 300 ERP