INVENTORY CONTROL > Reports > Excess inventory
This report lists items that are overstocked.
An item is considered to be overstocked if the in-stock balance (and optionally the on-order balance) of the item exceeds the Economic Order Quantity (EOQ) by a factor that you specify. The EOQ is defined for each item in the Item Master File.
•Number of times the EOQ? This refers to how many times the EOQ the in-stock balance has to be for the item to show on the report. A higher number will result in fewer items being listed.
•Consider on-order balances? Since items that you’ve already placed orders for will eventually be received, you may want to consider these open orders in determining whether an item is overstocked. If you select [YES], the open (un-received) quantities on Purchase Orders and Releases will be added to the in-stock quantity before being compared to the item’s EOQ.