reports:items_and_stock

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
reports:items_and_stock [2023/07/28 00:58] – [Item filter] Mark Gloverreports:items_and_stock [2023/07/28 02:40] (current) – [Only include items whose stock cover is less than...] Mark Glover
Line 134: Line 134:
  
 ====  Item usage ==== ====  Item usage ====
-This report gives you a breakdown of item usage for the last few months, with summaries for the last 2 years, It also includes stock on hand and stock on backorder for each item in the report.+The Item usage report gives you a breakdown of item usage for the last few months, with summaries for the last 2 years, It also includes stock on hand and stock on backorder for each item in the report.
  
 The report produced is very useful for forecasting or for seeing a list of items that need to be ordered. The report produced is very useful for forecasting or for seeing a list of items that need to be ordered.
Line 170: Line 170:
 If you want only to report on items whose stock is low, enter the threshold for days of stock on hand into the second field. For example, entering 90 into this field will only include items in the report whose stock is not sufficient to cover average usage for the next 90 days. If you want only to report on items whose stock is low, enter the threshold for days of stock on hand into the second field. For example, entering 90 into this field will only include items in the report whose stock is not sufficient to cover average usage for the next 90 days.
  
-Enter "0" (zero) for this field to report on items with any amount of stock remaining.+The default of ''0'' (zero) in this field will include //all// items with any amount of stock remaining.
  
 === Include items with no usage in the last 12 months === === Include items with no usage in the last 12 months ===
Line 215: Line 215:
  
 ====  Item slow movers ==== ====  Item slow movers ====
 +
 +The Item slow movers report shows all items that have more than a specified number of months worth of stock.
  
 You will be shown a window to enter the item details: You will be shown a window to enter the item details:
Line 258: Line 260:
 ====  Expiring items vs. cover ==== ====  Expiring items vs. cover ====
  
-This is a versatile report which allows you to see at a glance the amount of any stock items, and the number of months' cover provided by that amount of stock you have. **Note:** The cover calculation uses the last 12 months of usage data to calculate your rate of consumption.+The Expiring items vs. cover report shows the number of [[items:item_basics:tab_stock#months_cover|months of cover]] for items you have in your store.  The cover calculation uses the last 12 months of usage data to calculate the AMC which is used to determine months of cover.
  
 {{ :reports:itms_expiring_v_cvr.png }} {{ :reports:itms_expiring_v_cvr.png }}
  • Last modified: 2023/07/28 00:58
  • by Mark Glover