Inventory Valuation Report

This report outputs on-hand quantities, unit costs (standard, last, and average), and extended inventory values (based on standard, last, and average unit costs) for inventory items included in the report selection criteria.

Header Details

• Report process date and time
• Period end date specified in the parameters
• Page number

Line Details

These details display for each item:

• Item code
• Item description
• Item serial/lot number, where item is serial/lot controlled
• Item dimension, where item is dimension controlled and option to output is selected
• Location (if the option to Print Location Detail is selected in the parameters)
• Unit of measure
• Closing quantity (based on period end date)
• Average cost
• Standard cost
• Last cost
• Inventory value (based on average cost)
• Inventory value (based on standard cost)
• Inventory value (based on last cost)

The items that print on the report will depend on the main tree that is selected in the parameters.

Grand totals for inventory values are printed at the end of the report.

If the item is dimension-controlled and the option to print dimension details is selected, quantities displayed at a dimensional level represent integer quantities, not stocking unit of measure quantities (applicable for dimensions with a conversion factor is not equal to 1).

Example

This example shows how dimension details print on this report:

Notes:

• If the item is also serial/lot controlled, dimension details print within the lot detail, as each dimension quantity is for a lot.
• S Dimension quantities represent integer values, not stocking unit of measure values (applicable for dimensions with a conversion factor is not equal to 1). Item and serial/lot quantities are represented as stocking unit of measure quantities.