reports:misc_built-in_reports

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:misc_built-in_reports [2020/10/27 21:50] – Mark Gloverreports:misc_built-in_reports [2025/05/07 03:42] (current) – [Sync report] Gary Willetts
Line 1: Line 1:
-{{indexmenu_n>80}} +{{indexmenu_n>110}} 
-====== 13.08. Other reports ======+====== 13.11. Other reports ======
 =====  ABC analysis ===== =====  ABC analysis =====
 {{ :reports:reports2-2.png }} {{ :reports:reports2-2.png }}
Line 73: Line 73:
  
 =====  Sync report ===== =====  Sync report =====
 +This report allows you to track simple remote site activity. There is more in depth remote site activity available on the mSupply dashboard (see the [[https://docs.msupply.foundation/dashboard/introduction/]] page for details). To run it, choose //Report// > //Sync report...// from the menus. There are no filters and the report will open automatically in your default spreadsheet application. It looks like this:
  
-This report allows you to to track remote site activity.  It is available from the special menu. The report is only visible in the menu if you're on a primary server (the main server in a sync system). +{{ :reports:pasted:20250507-034016.png?700 }}
- +
-{{:reports:syncreport.jpg}} +
-  +
- +
-{{:reports:syncreport2.jpg?700|}}+
  
 ===== Debtors and creditors ===== ===== Debtors and creditors =====
Line 121: Line 117:
 =====  Prescriber report ===== =====  Prescriber report =====
  
-This report (v1.93 onwards only) allows you to view the total value, mean item value and item count for prescriptions dispensed for each prescriber.+The Prescriber report allows you to view the total value, mean item value and item count for prescriptions dispensed for each prescriber.
  
 You will be shown a window with the normal date range options, and the option to report only on prescibers whose type field is set to a certain type. You will be shown a window with the normal date range options, and the option to report only on prescibers whose type field is set to a certain type.
Line 156: Line 152:
  
 =====  Backorder report ===== =====  Backorder report =====
- +This report shows the backorders that have been placed for items. Backorders are made when there is insufficient stock to meet the requirements of an order placed by the customer. Information about the item code, item name, current stock, customer code, the backordered quantity (number of units, not packs) and the date of the backorder is displayed.
-This report shows a list of Items that are not available or insufficient stock is present to meet the requirements of the order placed by the customer. Information about the item code, item name, current stock, customer code, b/ord quantity is displayed.+
  
 If you are running a backorder system this gives you a quick way to check if backordered items are now in stock so they can be supplied to customers. If you are running a backorder system this gives you a quick way to check if backordered items are now in stock so they can be supplied to customers.
Line 166: Line 161:
  
 =====  Update price list ===== =====  Update price list =====
 +This item updates the catalogue or price list prices of items with prices from their current stock lines. All items have separate catalogue prices in each store and they are displayed on the //Misc// tab of an item's details window catalogue (see the [[items:item_basics:tab_misc|]] page for details). 
  
-This item updates the prices of items from the item line on hand that has the most stock.+When you click on the //Update price list// option, the report options window is shown, allowing you to check what price is used:
  
-Only items whose "price list" check box is checked are updated.+{{ :reports:report_price_list_update_options.png?450 |}}
  
-Each line of stock is evaluated to determine which stock line you have the most of. That line is used as the indicator price for its item.+  * **the price of the largest batch in stock**: sets the price list (catalogue) price to the sell price of the batch with the largest number of units (pack size x number of packs) in stock. 
 +  * **the price of the highest priced batch in stock**: sets the price list (catalogue) price to the sell price of the batch with the highest price (i.e. highest sell price/batch pack size value) of all current batches in stock. 
 + 
 +Note that in both options, the //Catalogue pack size// is also set to the pack size of the batch that is used to set the catalogue price. 
 + 
 +Only items whose //On price list// check box is checked are updated. If no items have this checked then mSupply aill tell you so and the update won't run.
  
 Note that if an item has no stock, then the price for that item will not be altered. Note that if an item has no stock, then the price for that item will not be altered.
  
-It is a good idea to run the "suggest price list additions" report first.+mSupply will show you the progress of the update and will also tell you when it is complete. 
 + 
 +It is a good idea to run the "suggest price list additions" report before running this function.
  
 =====  Price list ===== =====  Price list =====
  • Last modified: 2020/10/27 21:50
  • by Mark Glover