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
Next revisionBoth sides next revision
reports:transactions [2023/01/31 04:04] – [Type of report] Mark Gloverreports:transactions [2023/05/10 08:03] – [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 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 differences in stock transfers between stock sent on a customer invoice from the issuing store and what was received on the supplier invoice in the receiving store |  |
 | 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 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 === === Transaction type ===
 In the first drop down list, you can choose to report on: In the first drop down list, you can choose to report on:
  • Last modified: 2023/05/10 08:27
  • by Gary Willetts