Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
reports:items_and_stock [2023/01/26 13:37] – [Stock on date] Gary Willetts | reports:items_and_stock [2023/07/28 02:40] (current) – [Only include items whose stock cover is less than...] Mark Glover | ||
---|---|---|---|
Line 12: | Line 12: | ||
=== Item filter === | === Item filter === | ||
- | A "Find" | + | A "Item filter" allows you to enter the normal find item filter |
- | A random report | + | === Random === |
+ | |||
+ | A ' | ||
=== Additional options === | === Additional options === | ||
Line 41: | Line 43: | ||
{{ reports: | {{ reports: | ||
- | Enter the date for which you wish to show the stock. | + | Enter the date for which you wish to show the stock for. |
=== Type of report === | === Type of report === | ||
Line 132: | 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 168: | 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" | + | The default of '' |
=== Include items with no usage in the last 12 months === | === Include items with no usage in the last 12 months === | ||
Line 213: | 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 256: | Line 260: | ||
==== Expiring items vs. cover ==== | ==== Expiring items vs. cover ==== | ||
- | This is a versatile | + | The Expiring items vs. cover report |
{{ : | {{ : |