Differences

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

--- reports:requisitions [2019/09/19 08:00] – Gary Willetts
+++ reports:requisitions [2021/10/20 12:00] (current) – [Output] Gary Willetts
@@ Line 1: / Line 1: @@
-{{indexmenu_n>45}}
+{{indexmenu_n>50}}
-===== 16.05. Requisition reports =====
+====== 13.05. Requisition reports ======
 You can report on requisitions in 2 ways:
   * grouped by item, showing which customers the item was requisitioned by, what has been sent and what is outstanding or
@@ Line 13: / Line 13: @@
 {{ :reports:requisition_report_options.png?400 |}}
-Use the **Report type** drop down list to select which type of report you would like: Grouped by item or grouped by customer.
+Use the **Report type** drop down list to select which type of report you would like: //Grouped by item//, //Grouped by Item (Pivot table/Excel friendly)// or //Grouped by customer//.
+//Grouped by item// and //Grouped by Item (Pivot table/Excel friendly)// reports have the same contents, they are just formatted slightly differently. The //Grouped by Item (Pivot table/Excel friendly)// format is made to be immediately usable as a pivot table in Excel; a blank row between the column headers and the data, no gaps in the data and no total rows (see screenshots below).
 The **Requisition filter** settings enable you to select which requisitions you want to include in the reports, based on their entry date (this month so far is set by default but note the quick date selection drop down list and the date pickers to enable quick selection of reporting dates) or status.
@@ Line 23: / Line 25: @@
 Finally, the **Requisition customer filter** section allows you to select the customers whose requisitions will be included in the report. If you don't set anything in this section, requisitions for all customers will be included in the report.
-==== Example output ====
+==== Output ====
-These are examples of what the requisition reports like like:
+The Type column tells you what type of requisition the information came from:
+  * **response (from purchase order)**: a requisition created from a purchase order made in the customer's store.
+  * **response (from requisition)**: a requisition created from an internal order (request requisition) made in the customer's store.
+  * **response**: a requisition made for the customer in the supplier's store.
+The other fields are all self explanatory and are shown in the screenshots below.
+<WRAP info center round 90%>
+Note that all the columns that refer to a quantity of an item (e.g. //Their stock on hand//, //Quantity requested//, //Quantity already issued// and //To be supplied//) refer to the **number of units**, not the number of packs.
+</WRAP>
+=== Examples ===
+These are examples of what the requisition reports like like:
 **Grouped by item**
 {{ :reports:requisition_report_by_item.png?800 |}}
+**Grouped by item (Pivot table/Excel friendly))**
+{{ :reports:screenshot_2021-04-28_at_17.10.29.png?800 |}}
 **Grouped by customer**
 {{ :reports:requisition_report_by_name.png?800 |}}
+\\
+\\
+|  //  Previous:  **[[reports:purchasing]]** | | Next: **[[reports:dashboard]]** //  |
 ---- struct data ----
+pagestatus.status    :
 ----