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 [2019/10/16 18:43] – Emily Porrelloreports:misc_built-in_reports [2021/08/19 13:43] (current) – [Backorder report] Gary Willetts
Line 1: Line 1:
-{{indexmenu_n>70}} +{{indexmenu_n>80}} 
- +====== 13.09. Other reports ======
-====== 11.08. Other reports ====== +
 =====  ABC analysis ===== =====  ABC analysis =====
 {{ :reports:reports2-2.png }} {{ :reports:reports2-2.png }}
Line 78: Line 76:
 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). 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:syncreport.jpg }} +{{:reports:syncreport.jpg}} 
-\\ + 
  
-{{:reports:syncreport2.jpg?700| }} +{{:reports:syncreport2.jpg?700|}}
-\\  +
-\\  +
-\\  +
-\\  +
-\\  +
-\\  +
-\\  +
-\\  +
-\\  +
-\\  +
-\\  +
-\\  +
-\\  +
-\\  +
-\\  +
-\\ +
  
-=====  Debtors and creditors =====+===== Debtors and creditors =====
  
 The following reports are available: The following reports are available:
Line 139: Line 121:
 =====  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 174: Line 156:
  
 =====  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.
  
-=====  Suggest price list additions... =====+=====  Suggest price list additions =====
  
 Note: the price list menu items are for those organisations that produce a price list or price indicator. (It is useful to call your publication a "price indicator", as it implies the published price is a guide, and not a fixed price). You are asked to specify the number of transactions and the number of months (e.g. 2 transactions in the last 3 months) that would make an item eligible for inclusion in the price list. A search is performed using the criteria you enter, and a list of items is shown that meet the criteria but are marked as not being in your price list. You can double-click on items in the list and click their "price list" check box to add them to the price list. Note: the price list menu items are for those organisations that produce a price list or price indicator. (It is useful to call your publication a "price indicator", as it implies the published price is a guide, and not a fixed price). You are asked to specify the number of transactions and the number of months (e.g. 2 transactions in the last 3 months) that would make an item eligible for inclusion in the price list. A search is performed using the criteria you enter, and a list of items is shown that meet the criteria but are marked as not being in your price list. You can double-click on items in the list and click their "price list" check box to add them to the price list.
  
 =====  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 =====
Line 285: Line 274:
 All reports are automatically saved by mSupply in the default folder. There may be occasions when you wish to save one or more reports on a removable storage medium - e.g. a pen drive - and this button allows you to do this; a window appears allowing you to specify the location in which you wish to save the selected reports. All reports are automatically saved by mSupply in the default folder. There may be occasions when you wish to save one or more reports on a removable storage medium - e.g. a pen drive - and this button allows you to do this; a window appears allowing you to specify the location in which you wish to save the selected reports.
  
-// Previous:  [[reports:atc_reports|16.07. ATC and DDD code based reports]]    Next: [[reports:manage_reports|16.09. Manage Reports]]//+\\ 
 +\\ 
 +|  //  Previous:  **[[reports:atc_reports]]** | | Next: **[[reports:manage_reports]]** //  |
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2019/10/16 18:43
  • by Emily Porrello