Difference between revisions of "Inventory Value Detail Report"

From Opentaps Wiki
Jump to navigationJump to search
(New page: This screen allows you to run an inventory valuation report with a greater level a detail. You may run the report for a specific inventory item by entering the internal product ID (or sea...)
 
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
This screen allows you to run an inventory valuation report with a greater level a detail.  You may run the report for a specific inventory item by entering the internal product ID (or search for it using the [[lookup widget]]), or for all items in your inventory by leaving the "Product ID" field blank and clicking the [Run] button.  The report will be as of the current date and time.
+
This screen allows you to run an inventory valuation report based on the actual inventory items owned by your company.  You may run the report for a specific inventory product by entering the internal product ID (or search for it using the [[lookup widget]]), or for all product in your inventory by leaving the "Product ID" field blank and clicking the [Run] button.  The report will be as of the current date and time.
  
 
The report will contain the following information:
 
The report will contain the following information:
  
* '''Inventory Item''' - This is the internal ID number for the item in the inventory.
+
* '''Inventory Item''' - This is the internal ID number for the product in the inventory.
* '''Product''' - This is the internal product number for the item.
+
* '''Product''' - This is the internal product number for the product.
 
* '''Serial No.''' - This is the serial number of the item (if none is specified this will display "Non-Serialized").
 
* '''Serial No.''' - This is the serial number of the item (if none is specified this will display "Non-Serialized").
* '''QOH Quantity''' - This is the Quantity on Hand  
+
* '''QOH''' - This is the Quantity on Hand value, and is the number of units currently in your inventory.
* '''Unit Cost Value'''
+
* '''Unit Cost''' - This is how much each unit costs to manufacture or purchase from the vendor.
* '''Cuml'''  
+
* ''' Value''' - This is the product's sale value.
* '''Value'''
+
* '''Cuml Value''' - This is the cumulative value of inventory products as listed.
 +
 
 +
The inventory value detail report will calculate the subtotal of your inventory.  It will also display any adjustments relevant to your inventory (for example, inventory products currently being manufactured or scheduled to be ordered from a vendor).  The Total Inventory Value is displayed at the bottom of the report.

Latest revision as of 16:22, 14 December 2007

This screen allows you to run an inventory valuation report based on the actual inventory items owned by your company. You may run the report for a specific inventory product by entering the internal product ID (or search for it using the lookup widget), or for all product in your inventory by leaving the "Product ID" field blank and clicking the [Run] button. The report will be as of the current date and time.

The report will contain the following information:

  • Inventory Item - This is the internal ID number for the product in the inventory.
  • Product - This is the internal product number for the product.
  • Serial No. - This is the serial number of the item (if none is specified this will display "Non-Serialized").
  • QOH - This is the Quantity on Hand value, and is the number of units currently in your inventory.
  • Unit Cost - This is how much each unit costs to manufacture or purchase from the vendor.
  • Value - This is the product's sale value.
  • Cuml Value - This is the cumulative value of inventory products as listed.

The inventory value detail report will calculate the subtotal of your inventory. It will also display any adjustments relevant to your inventory (for example, inventory products currently being manufactured or scheduled to be ordered from a vendor). The Total Inventory Value is displayed at the bottom of the report.