I/C Item Valuation Report

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

Printing the Item Valuation Report

Overview

The I/C Item Valuation report lists the value of inventory quantities on hand, calculated for the items, locations, costs, or optional amounts you select for the report.

When to Print

Print the report when you want to calculate inventory values.

Information Printed on This Report

The report includes different information, depending on the options you select:

  • Print Items by Location in Detail. If you select this option, the report includes:
    • The costing method that is assigned to the item by its account set.
    • The average unit value and the cost per costing unit for each costing method. If you include costs entered in the optional amount field, unit values in the optional amount column are expressed in stocking units.
    • A column in the "Valuation" section for each costing method you selected for the report, including any optional or alternate costing methods.
    • The totals for all items on the report.
    • Quantities and costs are separate options so that you can include any combination of quantity and cost values, such as positive quantities and negative costs, or zero quantities and positive or negative costs.
  • Print Items by Location in Summary. If you select this option, the report includes the totals for all items on the report.
  • Print Consolidated Locations in Detail. If you select this option, the report includes the item number, description, and costing method for each item across all locations. It also prints the quantity on hand and costing information totals for each item.
  • Print Consolidated Locations in Summary. If you select this option, the report consists of a single line showing the total costs for all inventory items included in the range of items and locations you select.
  • Print Separate Locations in Detail. If you select this option, the report includes:
    • The location code and location description.
    • The totals for all items at the location.
  • Print Separate Locations in Summary. If you select this option, the report includes the totals for all items at the location.
  • Default Item Price List. If you select this option, the report values inventory using the base price of the selected price list.

    The report starts a new page for each location you select.

  • Transaction Costs. If you select this option, the report includes:
    • The location code and location description.
    • The totals for all items at the location.