Printing the Item Valuation Report

The Item Valuation report shows the value of inventory quantities on hand, calculated for the items, locations, costs, or optional fields you select for the report.

For more information on the contents of this report, see I/C Item Valuation Report.

Run Day End Processing if you want to include the latest costing information in the report.

To print the Item Valuation report:

  1. Open Inventory Control > I/C Stock Control Reports > Item Valuation.

  2. Specify the type of valuation report that you want to print.

    • Select Location Detail Costs to print the current value of your inventory using all data stored in costing buckets.
    • Select Transaction Costs to print all transactions and item costs for the period you specify (from receipts, shipments, transfers). For each item, the report includes opening inventory costs, transaction amounts and costs, and closing inventory costs.

  3. Make your selections in the following fields:

    Select Transactions by Cutoff Date or Fiscal Year/Period. If you select Transaction Costs, you also select the date range or period range for printing transaction information.

    Print [ ] in [ ]. Select the method of presenting the information on the report.

    Print Transaction Details (if using transaction costs). If you selected Transaction Costs instead of Location Details Costs in the first field, you can print the details for all of the transactions in the range that you specified.

    Include [ ] Quantities and Costs. Select which quantities and costs to print.

    From Account Set [ ] to [ ]. Enter a range or use the Finder to select a range of account sets by which to select items for the report.

    From Location [ ] to [ ]. Enter a range or use the Finder to select a range of locations from which to include items on the report.

    Sort by. Specify how you want item records sorted.

    From [ ] to [ ]. Specify the range of item numbers, categories, segments, or optional field entries to include in the report.

    Select up to 4 Costing Methods for Valuation. Each costing method you select adds a column to the report.

  4. Click Print.

    • If you are printing to a physical printer, the Print window appears. Confirm your printer selection and the number of copies to print, and then click OK. Otherwise, click Cancel or Setup.
    • If you are printing to the screen (preview), the report appears in a new window. You can print the report or export it to a file.

      Note: For Web-based clients, the preview screen appears first when you click the Print button.

    • If you are printing to a file, the Export window appears. Specify the file format (for example, PDF, DOC, or XLS). Also, specify a destination for the file:

      • Application. View the report in an application that can open files of the specified format (for example, if you specify PDF as the file format, the report opens in Adobe Acrobat). You can then save the file.
      • Disk file. Save the report to a location you specify.
      • Microsoft Mail. Send the report as an e-mail attachment.

      You can enter the name of a non-existent file or directory to be created by the system when you print. When you print to a file, the report is assigned a unique name, for example, CS1000.TXT.

    • If you are printing to e-mail, an e-mail message appears with the report attached.