The Inventory Valuation Report provides a way to print a list of current values for the Inventory Items on-hand at each Warehouse based on the Receipt information for the items. The method (LIFO, FIFO, Average Cost) used for calculation depends on which method of inventory valuation that was selected in the Warehouse setup.

The report is available in Summary or Detail format.

• Summary - Shows one line for each Warehouse Item with a remaining quantity available.
• Detail - Shows each receipt/return transaction with remaining quantity available. Any shipments made after the Thru date are added back into the valuation amount for the Warehouse Item.

You can select the option to include or not include Unapproved transactions.

Permissions must be set in the System module to access the Valuation report.

System module—Security—Users—Inventory—Reports—Valuation

Select Warehouses (button)

Click the Select Warehouses button and then select the Warehouses for which you want to print the report.

From / Thru Item ID

To run the report for a specific Item IDs range, use the Lookup iconfor each field to select a starting and ending entry for the range or select the same entry for both to run the report for one Item ID.

Report Type

Select the report type you want to print: Summary or Detail.

Include Unapproved (check box)

Checked - The report includes unapproved transactions.

Unchecked - The report does not include unapproved transactions.

Report Format

PDF Format (default): Select this option to print the report in PDF format.

Create Spreadsheet: Select this option to print the report in an Excel spreadsheet.

1. From the Inventory menu, select Reports—Valuation.
2. Use the Field List for help selecting options.
3. Click Print.
4. If you selected Create Spreadsheet, you are prompted to open or save the report Excel file. Otherwise, the report opens in PDF format.