| Both sides previous revision Previous revision Next revision | Previous revision |
| items:master_lists [2024/10/17 13:55] – [In use by] Gary Willetts | items:master_lists [2026/01/06 15:29] (current) – [Update prices to 12 month average] Gary Willetts |
|---|
| {{ :items:item_mstr_list.png?300 }} | {{ :items:item_mstr_list.png?300 }} |
| |
| If the list oif master lists is long, you can tyoe something in the //Search master lists// field and the list will only show master lists that contain what you have typed. | If the list of master lists is long, you can type something in the //Search master lists// field and the list will only show master lists that contain what you have typed. |
| |
| <WRAP center round important 60%> | <WRAP center round important 60%> |
| The master list is copied to the clipboard when this button is clicked so that you can paste it into other applications on your computer e.g. a word processor or spreadsheet application. | The master list is copied to the clipboard when this button is clicked so that you can paste it into other applications on your computer e.g. a word processor or spreadsheet application. |
| |
| == Update prices to 12 month average == | == Update price using monthly average == |
| | Also only visible if the **Use program pricing** preference is turned on (see the [[preferences:invoices#use_program_pricing|15.03. Invoice preferences]] page for details). When you click this button, mSupply calculates a weighted average price for each item from all the cost prices on all supplier invoice lines that were confirmed in the number of months previous to the current day for each item shown in the text box below the button (defaults to 12). That calculated price is then shown for each item in the //Price// column. When you click on the **OK** or **OK & Next** buttons these prices will be saved on the master list, if you click on the **Cancel** button the prices will revert to what they were before. mSupply will create a log record when the function is run so that you have a record of the old and new prices - see the [[admin:the_log|]] page for details on viewing the logs. |
| Also only visible if the **Use program pricing** preference is turned on (see the [[preferences:invoices#use_program_pricing|15.03. Invoice preferences]] page for details). When you click this button, mSupply calculates a weighted average price for each item from all the cost prices on all supplier invoice lines that were confirmed in the 12 months previous to the current day for each item. That calculated price is then shown for each item in the //Price// column. When you click on the **OK** or **OK & Next** buttons these prices will be saved on the master list, if you click on the **Cancel** button the prices will revert to what they were before. mSupply will create logs when the function is run so that you have a record of the old and new prices - see the [[admin:the_log|]] page for details on viewing the logs. | |
| |
| == Import item list == | == Import item list == |
| A temporary list is created for each store containing items that cannot be removed from visibility when the master list preference is activated, normally because there is stock of the item in the store. | A temporary list is created for each store containing items that cannot be removed from visibility when the master list preference is activated, normally because there is stock of the item in the store. |
| </WRAP> | </WRAP> |
| - Now whenever an item is added or removed from this master list, the preference will automatically update the visibility for all of the 100 stores, so that the items visible for each individual store matches the items included in the master list. | * Now whenever an item is added or removed from this master list, the preference will automatically update the visibility for all of the 100 stores, so that the items visible for each individual store matches the items included in the master list. |
| - Adding an item to a master list will automatically add that item to visibility for all stores using that master list | * Adding an item to a master list will automatically add that item to visibility for all stores using that master list |
| - Deleting an item from a master list will automatically remove that item from visibility for each store using that master list, given it is not included in another master list in use by each store respectively. | * Deleting an item from a master list will automatically remove that item from visibility for each store using that master list, provided that it is not included in //another// master list in use by each store respectively. |
| |
| <WRAP center round important 60%> | <WRAP center round important 60%> |