The Inventory Value Report allows you to view the total inventory value for a selected group of products. You can choose to print a Detail or Summary version of the report, depending on the amount of information you want to view.
Since the Inventory Value Report can only be printed to measure the current value of your inventory, and not a past value, you should save this report as a Hold File each time you run it so that you can access the value in the future. This is especially important when you print the report as part of the End of Month Closing process.
You may want to match this report to your General Ledger Inventory amount - if these amounts do not match, see the General Ledger Troubleshooting page for possible causes of the discrepancy.
To print the Inventory Value Report follow the easy steps below. You can also click on any field in the screen image shown for more information. As this is a printed report, be sure that your printer is turned on and connected, and that you have inserted a sufficient amount of paper into the correct printer tray before you begin. You can also choose to view the report on screen.
1.Starting from the main screen, select Inventory > Inventory Value Report.
2.The Selection Criteria window will pop-up. Use this window to select the group of products that you want to include in the report. For more information about selection options, see the Selection Criteria page.
3.Once you have selected your products, click the OK button to go to the Inventory Value Report screen (shown below).
4.Enter the warehouse that you would like to view inventory information for in the Warehouse field. Leave this field blank to include all warehouses.
5.Select the cost column that you want to use to calculate the value of the inventory from the drop down menu in the Cost Column field.
6.In the Detail/Summary field, select the degree of detail that you would like to include in the report.
7.Then choose any additional options for the report. Click on any of the options in the example screen shown above for more information. Additionally, if you are printing the report to reconcile with your General Ledger Inventory figures, you may want to print the Reconciliation Summary, which includes figures like your total uninvoiced Purchase Orders, Inventory Average Cost Variance, and negative inventory amounts. When you have selected all of the necessary options, click the OK button in the bottom toolbar.
Now you will need to save the report as a Hold File. Once it is saved, it can be printed, faxed, or emailed at any time in the future. In the printer window, click on the Hold button. A window will pop-up asking you to name the file. The file will also be saved with the date and time that the report was run, and the user initials of the person who ran it. Enter a name for the file and click the OK button. Now to print a hard copy of the report, click on the name of the report you just saved and click the Print button in the window. The printer window will pop-up so that you can select the appropriate printer and number of copies, then click the Print button to print a copy of the report.
You may also fax or email this report by clicking the Fax/Email button. For more help faxing or emailing the report, see the Fax/Email Reports page.
