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 [2025/03/19 15:46] – [Item ledger] Gary Willettsreports:items_and_stock [2025/07/08 01:19] (current) – [Report format] Gary Willetts
Line 28: Line 28:
   * "Each batch shown separately" will also give you a column on the right where, having done a physical stocktake, you can enter the quantity that is actually in stock, allowing any corrections to be made in mSupply.   * "Each batch shown separately" will also give you a column on the right where, having done a physical stocktake, you can enter the quantity that is actually in stock, allowing any corrections to be made in mSupply.
   * "Total stock for each item" will not show individual batches, but the total quantity on hand of each item.   * "Total stock for each item" will not show individual batches, but the total quantity on hand of each item.
-  * List the price of each batch in stock, with a total at the end of the report.+  * "Each batch with prices" List the price of each batch in stock, with a total at the end of the report. 
 +  * "Donor reporting" select this to see donor information - see the 'Donor reporting' section below. 
 +  * "Items in rows, Donors in columns" shows eaxactly what it says in the report! 
 +  * "Items in rows, Stores in columns" shows a row for each with columns for each store. The cells contain the number of units of the item in each store. Must be run in supervisor mode (see the [[https://docs.msupply.org.nz/other_stuff:misc_topics?|26.01. Miscellaneous topics]] page for details).
  
 The lines are reported alphabetically either by item name or shelf location, depending on what you have chosen in the "Sort report by" options The lines are reported alphabetically either by item name or shelf location, depending on what you have chosen in the "Sort report by" options
Line 259: Line 262:
  
 ==== Expired stock ==== ==== Expired stock ====
 +
 +<WRAP center round info 60%>
 +This is a customised report only available for few of our clients. 
 +</WRAP>
 +
 {{ :reports:pasted:20241021-114532.png?400 |}} {{ :reports:pasted:20241021-114532.png?400 |}}
  
Line 316: Line 324:
  
 {{ :reports:pasted:20250319-154418.png?1100 }} {{ :reports:pasted:20250319-154418.png?1100 }}
 +
 +The //Stock movement with stores// report looks like this:
 +
 +{{ :reports:pasted:20250319-163106.png?1100 }}
  
 \\ \\
  • Last modified: 2025/03/19 15:46
  • by Gary Willetts