The I/C 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.
Before you start
Run Day End Processing to include the latest costing information in the report.
To print the I/C Item Valuation report:
-
Inventory Control > I/C Stock Control Reports > Item Valuation.
- In the I/C Item Valuation Report screen for Use, select 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 (not just the items that had transactions).
- Select Transaction Costs to print all transactions and item costs for the period you specify (from receipts, shipments, transfers). If you pick a detailed report, the report includes opening inventory costs, transaction amounts and costs, and closing inventory costs for each item that had a transaction.
- If you selected Transaction Costs:
- Choose to select transactions by cutoff date or by fiscal year/period.
- Specify the date or period range.
- If you want the report to include details for all of the transactions in the specified range, select the Print Transaction Details option.
- Select how to group the location information and whether to generate a detail or summary report.
- For Include Quantities and Include Costs, select whether to include positive, negative, and/or zero quantities and costs in the report.
- If you want to limit the report to a range of account sets or inventory locations, enter the ranges in the table. You can click
, and then select an account set or location. - For Sort By, select the sort order for the report, which can be by item number, category, item segment, or an optional field value. If you want to limit the report to a range of values for the sort field, enter the range for From and To.
- For Include , select up to four costing methods for the valuation. Each costing method you select adds a column to the report.
- Click Print.
The report appears in a new window. You can print the report or export it to a file.