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 [2020/05/12 08:53] – [13.02. Stock and items reports] 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 35: | Line 37: | ||
==== Stock on date ==== | ==== Stock on date ==== | ||
- | This report allows you to produce a report for the stock in your store on a particular date. You are shown a window like this: | + | This report allows you to produce a report for the stock in your store on a particular date. The stock shown will be the stock at the END of the day. If you want to see the stock at the beginning of the day, choose the day before in the date selector. |
+ | |||
+ | You are shown a window like this: | ||
{{ 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 91: | Line 95: | ||
{{ : | {{ : | ||
- | This report allows you to view an on-screen or printed | + | This report allows you to print a list of you items in certain formats. |
- | There is only one report layout listed | + | There are 3 options |
+ | * //Code, Name and Shelf Location//: Shows exactly | ||
+ | * //Code, Name, Shelf Location with Item Long Description//: | ||
+ | * //List of items in Catalogue//: | ||
=== Local / remote report === | === Local / remote report === | ||
Line 127: | 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 163: | 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 208: | 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 225: | Line 234: | ||
=== Months of stock === | === Months of stock === | ||
- | * Enter the number of months of stock to report on. Items with more than this number of months of stock on hand will be included in the report. The correct figure to enter here depends upon your desired stock turn. In general, if you are turning over your stock 3 or 4 times a year, you would want to know about items which have more than 8 months of stock on hand. | + | * Enter the number of months of stock to report on. Items with more than this number of months of stock on hand will be included in the report. The correct figure to enter here depends upon your desired stock turnover. In general, if you are turning over your stock 3 or 4 times a year, you would want to know about items which have more than 8 months of stock on hand. |
* The report is calculated using the last 12 months usage as a guide to the average monthly usage. | * The report is calculated using the last 12 months usage as a guide to the average monthly usage. | ||
Line 251: | Line 260: | ||
==== Expiring items vs. cover ==== | ==== Expiring items vs. cover ==== | ||
- | This is a versatile | + | The Expiring items vs. cover report |
{{ : | {{ : | ||
Line 274: | Line 283: | ||
Ledger entries may be viewed in this report; different formats of report are available in addition to several filter options from the drop down lists, so the report may be designed to meet your specific requirements. | Ledger entries may be viewed in this report; different formats of report are available in addition to several filter options from the drop down lists, so the report may be designed to meet your specific requirements. | ||
- | {{ :reports:itm_ldgr_ddl.png }} | + | {{ :reports:itm_ldgr_ddl_ru.png?400 |}} |
\\ | \\ | ||
Line 281: | Line 290: | ||
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||