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.
  1. Inventory Valuation Summary Report

  2. Sum of Column on Inventory Grid

 

Inventory Valuation Summary Report:

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.'

Inventory page printing selection

To identify items that do not have valid cost information, you can cause the report to list these items below the summary section.

Inventory Valuation report can include items with incomplete sourcing or costs.

The report below lists items with incomplete cost data. If the user had selected 'No', then only the header information would have printed.

Sample printing of the Parts&Vendors Inventory Valuation report.

 

Inventory Grid - Sum of Column

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.

The Cur/Assy/MFExtCost is a special composite field, meaning that it gets the values from different places depending on the nature of the part.

  • Cur comes from CurrentCost for items that are PS/DWG and not Made From parts.
  • Assy comes from the Last Calculated Assy Cost (under the Assy Cost tab on the Item Master) for items of Type=CAT or Type=PL. This value is set by the program when a Purchase List is generated on the Buy page for this P/N or a higher level assembly.
  • MF comes from the Last Calculated Made From Cost on the M/F Cost tab on the Item Master for PS/DWG parts that are Made Froms. This is generated by the program when a Purchase List is generated on the Buy page for an assembly that includes this P/N.
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.

The Filter By dialog lets you select or omit items based on your criteria.

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.

Summing columns can be done by right clicking in the appropriate data field.

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.
Tehe Sum of Column feature allows you to extend (multiply) by another column.
The sum of the column will appear at the bottom of the grid.

Example of the Sum of a field on the screen. The report will also display the sum data.

 

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.

Sample of Inventory List printed with summed column.

End of document 
Home