Parts&Vendors provides two separate methods of calculating the value of your inventory. Both are described on this page. Click one of the links below to jump to the instructions.
From the Item Master / Inventory grid, choose File...Print or File...Print Preview.
From the this grid only, after prompting for the report title, you will be prompted to print a normal (tabular) listing, or to print the Valuation Summary . Choose 'No.'
To identify items that do not have valid cost information, you can cause the report to list these items below the summary section.
The report below lists items with incomplete cost data. If the user had selected 'No', then only the header information would have printed.
A valuation of inventory can also be calculated from the Item Master / Inventory grid.
Select the fields that are to be displayed, making sure that Cur/Assy/MFExtCost is visible on screen.
NOTE: Not being "inventory software," Parts&Vendors does not keep an average cost for each item in the database. The value associated with an item is generally the last cost. This is based upon the most recent refresh of costs from making a Purchase List (on the Buy page). For these values to be realistic, be sure to have the cost Update options (on the Buy page) turned on when making "real" Purchase Lists, and turned off when making Purchase Lists for hypothetical or "blue sky" costing scenarios.
You can optionally filter the grid to exclude items whose Status = Obsolete.
On the Inventory grid, right-click in the Cur/Assy/MFExtCost column (not on the column header) to open the popup menu.
Choose the Sum of Column item.
The following prompt will appear. Since the Cur/Assy/MFExtCost column is already extended by the value of the Stock field for each P/N, choose 'Yes' for straight Sum.
The sum of the column will appear at the bottom of the grid.
If a report is printed from this grid (before it is refreshed), the report will look similar to that below, with the Sum appearing on the last page of the report.
End of document