Three Part Blog. Part 2 – Inventory Stock Value Report
The following is a response to a customer question after attending out CMS Road Show in Denver, CO.
How do I get to these three reports?
1) A report of all our stock items, and how many of each we sold last year.
2) A list of what we have in stock, with quantity.
3) A report on items where our stock is low, according to the limits we have previously set.
This blog is going to cover report number 2.
2) Inventory Stock Value Report. The Inventory Stock Value Report reads the cost and quantity for each stock item and gives a total dollar amount of inventory for the current period. The condensed report shows the totals for each item, while the detailed report contains a separate line for each purchase of each item, detailing how many of each item is on hand at each cost.
The Stock Value Report shows the following for each selected item:
- Stock Number
- Item Description
- Product Type
- Location
- Date
- On Hand Quantity
- Unit package
- Method
- Weighted/Average cost
- Value
- You can also choose to print: Last Cost, and Skip Zero Quantity
To sort the report or filter data using one of the User-Defined Fields, select the field name from the Sort By or Additional Filter drop-down lists, and specify the range of values that you wish to include.
If you chose to run the detailed report, you will see a separate line for each date the item(s) were purchased, as well as the costs and values for each purchase date.
Check back with the CMS blog to find out about the last report:
3) Understock – A report on items where our stock is low, according to the limits we have previously set.
Leave a Comment