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
Last revisionBoth sides next revision
reports:misc_built-in_reports [2020/10/27 21:50] – Mark Gloverreports:misc_built-in_reports [2021/08/12 13:44] – [Update price list] Gary Willetts
Line 1: Line 1:
 {{indexmenu_n>80}} {{indexmenu_n>80}}
-====== 13.08. Other reports ======+====== 13.09. Other reports ======
 =====  ABC analysis ===== =====  ABC analysis =====
 {{ :reports:reports2-2.png }} {{ :reports:reports2-2.png }}
Line 121: 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 166: Line 166:
  
 =====  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: 2021/08/19 13:43
  • by Gary Willetts