Show/Hide Toolbars

SpendMap User Guide (v14.5)

Navigation: Inventory Control > Reports

Inventory Re-Order Report

Scroll Prev Top Next More

INVENTORY CONTROL > Reports > Inventory Re-order

 

This report lists items that have fallen below their re-order levels and need to be replenished.

TIP:  You can automatically build Purchase Orders or other documents for items that need to be re-ordered (i.e. the items that show on this report) using the Item Requirements Staging Batch.

To proactively forecast when items may need to be re-ordered in the future, try the Inventory Forecast Report.

 

Noteworthy Questions & Options

Also consider re-order level expressed in weeks?  This will determine whether SpendMap considers the re-order level for each item expressed in “weeks” or just the fixed (unit/quantity) re-order level for each item.

If you choose to include the weeks re-order level, in addition to including items on the report that might not otherwise be included if you considered only the fixed re-order level, the report will also include a forecast of how long the current stock for each item will last.

Include safety factor?  This will add a "margin of error" by artificially increasing the re-order level for each item by the percentage that you enter. That is, the system will “pretend” that the re-order level is higher by a certain percent, therefore flagging items to be re-ordered sooner, even if they are not down to their actual re-order levels. This might be used during a busy season with higher than usual item demand and/or longer than usual delivery lead times from your suppliers.

Item or Location re-order level?  If you keep stock in multiple stock locations, you can generate a list of items that need to be ordered at one specific location as opposed to generating a list of items that have fallen below their re-order levels company-wide (i.e. across all locations).

If you select [LOCATION], SpendMap will compare the current stock at the specified location to the  re-order level for the item at that location (as indicated in the Location/Bin Details Screen).
If you select [ITEM], SpendMap will compare the total stock that you have across all locations to the item’s overall re-order levels (as indicated in the Inventory/Locations Folder). This option is most commonly used where the individual locations are in fairly close proximity to one another and items can easily be transferred from location to location as stock is depleted.

Consider on-order balances?  Since items that you’ve already placed orders for will eventually be received into stock, you may want to consider these open orders in determining whether or not an item needs to be re-ordered. The types of orders you include will be added to the in-stock quantity for the respective items, which might push them above their re-order levels, thereby omitting them from the report.