Differences

This shows you the differences between two versions of the page.

--- reports:transactions [2023/01/31 04:04] – [Type of report] Mark Glover
+++ reports:transactions [2023/05/10 08:27] (current) – [Type of report] Gary Willetts
@@ Line 76: / Line 76: @@
 | Customer trans line report 1 |  | {{ :reports:customer_trans_line_report1.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}} |
 | 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 weighted average price | Calculates the [[https://en.wikipedia.org/wiki/Weighted_arithmetic_mean|Volume weighted average]] price for all items on the catalogue in those stores (([item_store_join]include_on_price_list=True)) for all confirmed or finalised supplier invoices within dates provided by the user for all selected stores.\\ * 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.  |
+| 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 ===
 In the first drop down list, you can choose to report on: