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 [2021/08/19 13:43] (current) – [Backorder report] 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 156: 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.
Line 166: Line 165:
  
 =====  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