reports:transactions

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:transactions [2020/05/05 14:37] – [Type of report] Gary Willettsreports:transactions [2023/05/10 08:27] (current) – [Type of report] Gary Willetts
Line 36: Line 36:
 | Each invoice grouped by name | The report will sort each invoice in the date range according to the name (Supplier or Customer) and give totals for each name. |{{ :reports:invoice_grouped_by_name.pdf|Sample }} | | Each invoice grouped by name | The report will sort each invoice in the date range according to the name (Supplier or Customer) and give totals for each name. |{{ :reports:invoice_grouped_by_name.pdf|Sample }} |
 | Each invoice grouped by date | As above, but totals given for each day. | {{ :reports:invoice_grouped_by_date.pdf |Sample}}   | | Each invoice grouped by date | As above, but totals given for each day. | {{ :reports:invoice_grouped_by_date.pdf |Sample}}   |
-| Each invoice line by item | Lists each item supplied or received, and the transactions for that item. This report can be very long | {{ :reports:invoice_grouped_by_item.pdf |Sample}} |+| Each invoice line by item | Lists each batch supplied or received, and the transactions for that item. This report can be very long | {{ :reports:invoice_grouped_by_item.pdf |Sample}} 
 +| Invoice line with donor | As above, but including the 'donor' field and formatted to be <wrap hi>most useful for analysis using Excel filtering and Pivot Tables.</wrap>  This report can be long. | |
 | Each invoice showing profit | The cost and selling price totals for each invoice are displayed. | {{ :reports:eachinvoiceshowingprofit_report.pdf |Sample}} | | Each invoice showing profit | The cost and selling price totals for each invoice are displayed. | {{ :reports:eachinvoiceshowingprofit_report.pdf |Sample}} |
-| Each invoice line grouped by item department then item | The invoices are grouped by the item department assigned to each item. Each item department is then sorted in alphabetical order by items | {{ :reports:invoice_line_grouped_itemdept_thenitem_report.pdf |Sample}} | +| Each invoice line grouped by item department then item | The invoice lines are grouped by item department assigned to each item. Each item department is then sorted in alphabetical order. Includes batch information. | {{ :reports:invoice_line_grouped_itemdept_thenitem_report.pdf |Sample}} | 
-| Each invoice line grouped by name | The total value of items received/supplied from/to each name | {{ :reports:invoice_line_grouped_by_name.pdf |Sample}} | +| Each invoice line grouped by name | The value of batches received/supplied from/to each name. Includes batch level information. | {{ :reports:invoice_line_grouped_by_name.pdf |Sample}} | 
-| Each invoice line grouped by item and then name | Invoice lines are all displayed, grouped by item and then, within those groups, by name. | {{ :reports:invoice_line_grouped_by_item_andthen_name.pdf |Sample}} |+| Each invoice line grouped by item and then name | Invoice lines are all displayed, grouped by item and then, within those groups, by name. Includes batch information. | {{ :reports:invoice_line_grouped_by_item_andthen_name.pdf |Sample}} |
 | Totals for each item category | The total value for each category will be displayed - each transaction will not be shown. | {{ :reports:total_for_each_item_category.pdf |Sample}} | | Totals for each item category | The total value for each category will be displayed - each transaction will not be shown. | {{ :reports:total_for_each_item_category.pdf |Sample}} |
 | Totals for each item | Each item that has been received (or issued) will be shown with the total quantity and value received/issued |{{ :reports:totals_for_each_item.pdf |Sample}} | | Totals for each item | Each item that has been received (or issued) will be shown with the total quantity and value received/issued |{{ :reports:totals_for_each_item.pdf |Sample}} |
Line 54: Line 55:
 | 2 period comparison by item category | User selects two periods, and the transactions for each period form a column. The rows are determined by the item category. This is a special report that has different input options. See entry below. | | | 2 period comparison by item category | User selects two periods, and the transactions for each period form a column. The rows are determined by the item category. This is a special report that has different input options. See entry below. | |
 | Totals for each item broken down by packsize |The packsize for each item and the number of packs issued. | {{ :reports:totals_each_item_brokendown_packsize.pdf |Sample}} | | Totals for each item broken down by packsize |The packsize for each item and the number of packs issued. | {{ :reports:totals_each_item_brokendown_packsize.pdf |Sample}} |
-| Prescription and general issues over time | This report shows the quanity of items given to patients and other customers over a period of time, separated by month. It exports to Excel only and has 2 tabs; the //By Item// tab shows which prescribers prescribed what items and the //By Customer// tab shows which items were issued to which customers | {{ :reports:prescriber_report.pdf |Sample}} |+| Prescription and general issues over time | This report shows the quanity of items given to patients and other customers over a period of time, separated by month. It exports to Excel only and has 2 tabs; the //By Item// tab shows which prescribers prescribed what items and the //By Customer// tab shows which items were issued to which customers | {{ :reports:prescription_overtime.xlsx |Sample}} |
 | Prescriber report | This report allows you to view the total value, mean item value and item count for prescriptions dispensed for each prescriber | {{ :reports:prescriber_report.pdf |Sample}} | | Prescriber report | This report allows you to view the total value, mean item value and item count for prescriptions dispensed for each prescriber | {{ :reports:prescriber_report.pdf |Sample}} |
 +| Dispensing with patient name and prescriber | This report shows who dispensed what to which patients with which directions | {{ :reports:dispensing_patient_and_prescriber_name_report.xlsx |Sample}} |
 +| Historic prices - Volume weight average price | This report produces a [[https://en.wikipedia.org/wiki/Volume-weighted_average_price|volume weighted average price]] for all transactions within the specified time period, for items that are [[items:item_basics:tab_misc#price_list|On the price list]] in the store that you are logged in to.\\ Transactions that have have no transactions or a Cost price of ''0'' are ignored.\\ Calculations are done on the basis of the Catalogue pack size (often be the same as the [[items:item_basics:tab_storage#default_section|Preferred pack size]]).  That is, transactions that are not in the Catalogue pack size will have their calculation adjusted accordingly. | |
 | Cross tab: items in rows, names in columns, quantity in cells | These reports are like Excel pivot tables. Warning: they can be slow to produce if you have a lot of data. Start with small date ranges until you are comfortable your machine can handle the load. Note that reports that produce a lot of columns won't print well - it is better to export them to a spreadsheet and print from there. | {{ :reports:cross_tab_items_in_rows_names_in_columns_quan_in_cells.xlsx |Sample}} | | Cross tab: items in rows, names in columns, quantity in cells | These reports are like Excel pivot tables. Warning: they can be slow to produce if you have a lot of data. Start with small date ranges until you are comfortable your machine can handle the load. Note that reports that produce a lot of columns won't print well - it is better to export them to a spreadsheet and print from there. | {{ :reports:cross_tab_items_in_rows_names_in_columns_quan_in_cells.xlsx |Sample}} |
 | Cross tab: items in rows, names in columns, value in cells | See above | {{ :reports:cross_tab_items_in_rows_names_in_columns_value_in_cells.xlsx |Sample}} | | Cross tab: items in rows, names in columns, value in cells | See above | {{ :reports:cross_tab_items_in_rows_names_in_columns_value_in_cells.xlsx |Sample}} |
Line 73: Line 76:
 | Customer trans line report 1 |  | {{ :reports:customer_trans_line_report1.pdf |Sample}} | | Customer trans line report 1 |  | {{ :reports:customer_trans_line_report1.pdf |Sample}} |
 | Customer trans line report 2 |  | {{ :reports:customer_trans_line_report2.pdf |Sample}} | | Customer trans line report 2 |  | {{ :reports:customer_trans_line_report2.pdf |Sample}} |
 +| Received vs. sent | Shows the difference between stock issues from a supplier and stock receipts for the same lines at the customer. If you choose //Purchases from suppliers// as the **Transaction type** then the report will run over supplier invoices and show differences between what the current store was sent from the supplying store (on customer invoices) and what the current store received on the corresponding supplier invoices. If you choose //Sales to customers// as the **Transaction type** then the report will run over customer invoices and show differences between what was sent from the current store (on customer invoices) and what was received on the corresponding supplier invoices in the receiving store. **WARNING:** any non stock-transfer transactions included in the report (if you select //Normal transactions// or //Both normal transactions and stock transfers// in the **Transaction type** section) will show a full difference because there is no corresponding customer or supplier invoice. So it is recommended to only choose the //Stock transfers// option in the **Transaction type** section for this report. | {{ :reports:received_v_sent.pdf |}} |
 | Months to expiry | | {{ :reports:months_to_expiry.pdf |Sample}} | | Months to expiry | | {{ :reports:months_to_expiry.pdf |Sample}} |
 | Order processing time | If you are filling out the order written date and order received date for incoming customer orders, then this report will show you how long it is taking for orders to reach the store, and how long it is taking to process orders from receipt to order entry and to order dispatch | | | Order processing time | If you are filling out the order written date and order received date for incoming customer orders, then this report will show you how long it is taking for orders to reach the store, and how long it is taking to process orders from receipt to order entry and to order dispatch | |
-| Historic prices  - Volume weight average price |  |+| Historic prices - Volume weighted average price | Calculates the [[https://en.wikipedia.org/wiki/Weighted_arithmetic_mean|Volume weighted average]] price for all items in the catalogue in those stores (i.e. where the item's **On price list** checkbox is ticked (see the [[items:item_basics:tab_misc#price_list|4.01.03. Items - Misc(ellaneous) tab]] page for details)) for all confirmed or finalised supplier invoices within dates provided by the user for all selected stores. Please note:\\ * Transactions where the stock has a cost price = ''0'' will not be included in the calculation.\\ * Items that have had no transactions within the selected period will not appear in the report.\\ * The **On price list** checkbox must be set for each store. This will be important if you're running the report over more than one store. |
 === Transaction type === === Transaction type ===
-You can choose to report on:+In the first drop down list, you can choose to report on:
  
-  * Sales to customers (customer invoicestype "ci") +  * **Sales to customers:** customer invoices i.e. transactions of type //ci// 
-  * Sales to and credits from customers (customer invoices & credits: type "ci" & "cc") +  * **Sales to and credits from customers:** customer invoices & customer credits i.e //ci// and //cc// transaction types 
-  * Purchases from suppliers (supplier invoicestype "si") +  * **Purchases from suppliers:** supplier invoices i.e. transactions of type //si// 
-  * Purchases from and credits to suppliers (supplier invoices & credits: type "si" & "sc")+  * **Purchases from and credits to suppliers:** supplier invoices & supplier credits i.e. //si// and //sc// transaction types
   * **Inventory adjustment - Add stock:** All inventory adjustment transactions that resulted in stock additions (e.g. when you did a stock take of an item and counted more on the shelf than the total shown in mSupply).   * **Inventory adjustment - Add stock:** All inventory adjustment transactions that resulted in stock additions (e.g. when you did a stock take of an item and counted more on the shelf than the total shown in mSupply).
   * **Inventory adjustment - Reduce stock:** All inventory adjustment transactions that resulted in stock reductions (e.g. discarding stock due to it being expired). Note that using a report that shows the total for each transaction category can give totals for expired/damaged etc.   * **Inventory adjustment - Reduce stock:** All inventory adjustment transactions that resulted in stock reductions (e.g. discarding stock due to it being expired). Note that using a report that shows the total for each transaction category can give totals for expired/damaged etc.
   * **Inventory adjustment - Net movement:** Taking into account both reductions and additions, the nett change in inventory due to adjustment transactions.   * **Inventory adjustment - Net movement:** Taking into account both reductions and additions, the nett change in inventory due to adjustment transactions.
   * **Customer invoice cancellations:** These are the "inverse" invoices created when a customer invoice is cancelled   * **Customer invoice cancellations:** These are the "inverse" invoices created when a customer invoice is cancelled
-  * **Credit to customers:** The credits applied to customers when invoices are cancelled +  * **Credits to customers:** The credits applied to customers when invoices are cancelled or when goods are returned. 
-  * **Payment cancellations:** The "inverse" payments created to reverse a payment made by a customer for a customer invoice that has a payment against it ans has been cancelled.+  * **Payment cancellations:** The "inverse" payments created to reverse a payment made by a customer for a customer invoice that has a payment against it and has been cancelled
 + 
 +In the second drop down list, you have the following options: 
 +  * **Both normal transactions and stock transfers**: this is the default option and means that both stock transfer and non-stock transfer transactions will be included in the report 
 +  * **Normal transactions**: all transactions that are **not** stock transfers will be included in the report 
 +  * **Stock transfers**: only stock transfers will be included in the report 
 + 
 +A stock transfer is a transaction made when the supplier or customer is another store in your datafile. A normal transaction is when the customer or supplier is a normal customer or supplier in your datafile, and not a store.
  
 === Date range === === Date range ===
Line 104: Line 115:
  
   * Transaction source: Options are "All", "Customers, Suppliers and Stores" or "Patients". This allows you to select the type of Name the transactions must belong to. If you select //Patients//, only transactions which have a name that is a patient will be inccluded in the results (e.g. prescriptions). If you select //Customers, Suppliers and Stores// then transactions that have a name which is a normal supplier (e.g. supplier invoice) or customer (e.g. customer invoice) or store (e.g. stock transfer) will be included in the report. If you select All then this filter is effectively not used and transactions with any name type are included in the report.   * Transaction source: Options are "All", "Customers, Suppliers and Stores" or "Patients". This allows you to select the type of Name the transactions must belong to. If you select //Patients//, only transactions which have a name that is a patient will be inccluded in the results (e.g. prescriptions). If you select //Customers, Suppliers and Stores// then transactions that have a name which is a normal supplier (e.g. supplier invoice) or customer (e.g. customer invoice) or store (e.g. stock transfer) will be included in the report. If you select All then this filter is effectively not used and transactions with any name type are included in the report.
-  * Transaction category: Use the magnifying glass to choose the categories transactions must belong to to be included in the report. Note that you can select more than one category. The types of categories offered in the list will match your selection in the Transaction type section. +  * Transaction category: Use the magnifying glass to choose the transactions categories to be included in the report. Note that you can select more than one category. The types of categories offered in the list will match your selection in the Transaction type section. 
-  * Master transaction category: If you prefer, you can choose to filter by master transaction category instead. Master transaction categories are used to group together transaction categories (so selecting one of these is like selecting multiple categories in the Transaction category filter - it's just more convenient to do it this way if you regularly need to choose several. We love to make things easier for you!). Again, see sectino [[other_stuff:transaction_categories|22.07. Transaction categories]] for details on setting them up.+  * Master transaction category: If you prefer, you can choose to filter by master transaction category instead. Master transaction categories are used to group together transaction categories (so selecting one of these is like selecting multiple categories in the Transaction category filter - it's just more convenient to do it this way if you regularly need to choose several. We love to make things easier for you!). Again, see [[other_stuff:transaction_categories|22.07. Transaction categories]] for details on setting them up.
 === Name filter === === Name filter ===
 You can enter a particular customer code or category of transactions to be displayed. You can enter a particular customer code or category of transactions to be displayed.
Line 129: Line 140:
 === Exclude transfers from calculations === === Exclude transfers from calculations ===
 This checkbox enables you to choose whether you include [[issuing_goods:transferring_goods_to_another_store|stock transfers]] (where stock is transferred from one store to another in mSupply) in the report calculations. If you want stock transfers to be included in your report then uncheck this checkbox. If you want stock transfers to be left out of the report then check this checkbox. This checkbox enables you to choose whether you include [[issuing_goods:transferring_goods_to_another_store|stock transfers]] (where stock is transferred from one store to another in mSupply) in the report calculations. If you want stock transfers to be included in your report then uncheck this checkbox. If you want stock transfers to be left out of the report then check this checkbox.
 +
 +<WRAP center round info 60%>
 +Excluding transfers is only really useful if mSupply is being used in your central and regional warehouses (between which 'transfers' are happening, and //none// of your customers of interest are using mSupply.
 +</WRAP>
 +
  
 === The 2 period comparison by item category report === === The 2 period comparison by item category report ===
Line 241: Line 257:
 |  //  Previous:  **[[reports:items_and_stock]]** | | Next: **[[reports:purchasing]]** //  | |  //  Previous:  **[[reports:items_and_stock]]** | | Next: **[[reports:purchasing]]** //  |
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2020/05/05 14:37
  • by Gary Willetts