Answered
Use Minimum Stock/Inventory Level to help with re-orders
A Client recently asked:
We want to be able to run a stock report that will show the Item Number, Item Name, Current Stock Level, Minimum stock level, and available stock (current stock level less committed stock) so that we can use it to reorder any stock lines that are nearly out.
We have used the Inventory on Hand Favourite as a base, but just wondering if there is any way of easily filtering between items that have a min stock level & items that don’t, whilst keeping the item code in alphabetical order. We only maintain Minimum inventory levels for certain stock items.
0
Comments
Starting with the Bi4 Inventory on Hand or suggest instead using the Bi4 Item Sales v All Inventory report as a starting point you are able to set a Filter to select only items where the Minimum stock level is say > 0.
Bi4 Item Sales v All Inventory
By using the Bi4 Item Sales v All Inventory report you will also see other information to help with re-ordering including:
Set Alert to Notify when SOH or Available is Below Minimum
Why not set a second Numeric Filter for where Qty on hand or Qty Available is < 0.
This would be an ideal report to save as an email alert to notify you when it is time to re-order, see
Please sign in to leave a comment.