cats:procedures:reports:inventoryreport

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
cats:procedures:reports:inventoryreport [2016/04/04 14:32] jencats:procedures:reports:inventoryreport [2022/10/05 17:09] (current) jen
Line 1: Line 1:
 =====Inventory Reports===== =====Inventory Reports=====
-{{entry>0;Inventory Report;-}} +{{entry>0;Inventory Report;-}} Inventory reports show material that is in inventory - the number of units or weight on a contract item that has a purchase invoice but does not have a sale invoice. To print this report, go to **Position Reports > Inventory**.\\  
-Inventory reports show material that is in inventory - the number of units or weight on a contract item that has a purchase invoice but does not have a sale invoice. The Inventory report can also be printed from the Open position report area, and this is essentially the same set of data as that available from the Open position report, with one difference: the Inventory report will not show you open sales contracts.  +[{{:cats:procedures:reports:inventoryreports_mainmenu.png?|Inventory Reports Main Menu}}]
- +
-You do not need to create a separate inventory report in this area, but can use an Open Position report with the Inventory filter set and excluding Open Sales to get the same set of data as an Inventory report.+
  
 +Select report format and pick **Modify**.\\ 
  
 +[{{:cats:procedures:reports:inventoryreport_selectformat.png?|Select Format Report}}]
  
 +The Inventory report can also be printed from the [[cats:procedures:reports:openpositionreport|Open Position Report]] area, and this is essentially the same set of data as that available from the Open position report, with one difference: the Inventory report will not show you open sales contracts. 
 +You do not need to create a separate inventory report in this area, but can use an Open Position report with the Inventory filter set and excluding Open Sales to get the same set of data as an Inventory report.
  
-Here are several types of contracts you can view on inventory reports: +Here are several types of contracts you can view on inventory reports:\\ 
-Inventory - For the purposes of this report, inventory units are units with a purchase invoice but no sales invoice.  +  Inventory - For the purposes of this report, inventory units are units with a purchase invoice but no sales invoice.\\  
-Billed Out - No longer in inventory, with sales invoiced units matching contract units.  +  Billed Out - No longer in inventory, with sales invoiced units matching contract units.\\  
-Open/Inventory - Discussed in open position section above, shows both open and inventory items.  +  Open/Inventory - Discussed in open position section above, shows both open and inventory items.\\  
-Open/Inventory/TBF - Includes the open and inventory with unfixed items. +  Open/Inventory/TBF - Includes the open and inventory with unfixed items.\\ 
-Provisional Invoiced +  Provisional Invoiced.\\ 
-Unfixed - Items that have not been fully price-fixed. +  Unfixed - Items that have not been fully price-fixed.\\  
-All - Open, Unfixed, Inventory, etc.  +  All - Open, Unfixed, Inventory, etc.\\ 
-Open - All items that have no sale invoice, regardless of purchase invoice status.  +  Open - All items that have no sale invoice, regardless of purchase invoice status.\\ 
-Unallocated - Unallocated units on the contract items.+  Unallocated - Unallocated units on the contract items.\\
 ...and more options.  ...and more options. 
  
-A basic inventory report would have the following options selected: +A basic inventory report would have the following options selected:\\  
-Active - Active +  Active - Active\\  
-Minimum - units (1.00 units).  +  Minimum - units (1.00 units).\\  
-Contracts - Inventory. +  * Item Contracts - Inventory.\\  
-Screen 3: Negative Inventory - Do Not show. This option will prevent the report from showing items that have been overbilled or underbooked. You can choose show to see these items and fix them, but for a clear number of inventory units, select Do Not show. +  Negative Inventory - Do Not show.\\  
 +This option will prevent the report from showing items that have been overbilled or underbooked. You can choose show to see these items and fix them, but for a clear number of inventory units, select Do Not show.\\ 
 +[{{:cats:procedures:reports:inventoryreport_filters.png?|Inventory Report Filters}}]
  
 +Select **Continue** and select the print format. Below is a sample inventory report in HTML.\\ 
 +[{{:cats:procedures:reports:inventoryreports_basicreporthtml.png?|Basic Inventory Report}}]
 +{{tag>"Inventory Reports"}}
  • cats/procedures/reports/inventoryreport.1459780370.txt.gz
  • Last modified: 2017/12/19 03:21
  • (external edit)