Inventory Valuation Report

 

Window Details

 

How Do I...

Navigation

 

Create a Report Setting

Overview

 

Print a Report, Listing, or Form

Fields

 

E-mail, Fax, or Print a Report as a PDF

Report Sample

 

Enter Multiple Values Using Separators

 

Related Topics

 

 

Reconciling Inventory to the General Ledger

Item Maintenance

 

Navigation

Select Inventory Management Reports menu > Inventory Valuation Report.

Overview

Use Inventory Valuation Report to determine the value of the on-hand quantity of each item. The value is calculated by multiplying the unit cost (based on the valuation method established for the item in Item Maintenance) by the quantity on hand.

The report can be produced as a summary by item and/or warehouse or the report can include cost tier information for all FIFO, LIFO, lot, and serial items. Detail cost information for these items includes the receipt number and date, the quantity received on hand, the actual received unit cost, and the extended inventory value.

Lot and serial item detail also includes costing detail by lot and serial number. The inventory value for each receipt (cost tier) is calculated individually, based on the valuation method specified for that item.

You can enter a selection of item codes, product lines, primary vendor numbers, item descriptions, and warehouses to print. By entering these selections, you can obtain a list that allows you to identify pertinent information.

Note If you are using this report as an audit tool or for comparison purposes with general ledger balances, select the Print Inactive Items check box to include recorded history for any inactive items.

Note This report prints the item's primary vendor information and does not include other vendors associated with the item.

Fields

 

Report Setting

Procurement Types to Print

Description

Print Inactive Items

Type

Print Costing Detail

Default Report

Print Zero Quantity Cost Tiers

Print Report Settings

Print Zero Balances

Three Hole Punch

Operand

Number of Copies

Value

Collated

Printer/Output

Sort Report By

Keep Window Open After Print

Print Condensed

Keep Window Open After Preview

Product Types to Print

 

 

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks