Print Summarized Inventory Value Report

Explanation

This activity is used to print a report that calculates a summarized inventory value. The summarized value is calculated by either selecting a cost type or a cost set (when IFS/Costing is installed) in the Summarized Inventory Value Report dialog box. The values for cost types and cost sets can be selected from the list of values available.

When ordering the report for a previous period using the cost type Inventory Value, the values will be calculated based on the historical inventory value for the given period. This is to enable reconciling the values against the general ledger based on criteria that can also be used as control types in posting control for the inventory, i.e. the M1 posting type. When ordering the report using any other cost type or any cost set for a previous period, the system will use the historical quantities but the current value for the respective cost type or cost set. 

You can choose to include or not, the details about the inventory parts which meet the specified selection criteria.

Prerequisites

• The statistical periods must have been defined in the Statistic Periods window.
• The inventory transactions must have been aggregated, (otherwise the report might show incomplete data. This can be performed as a background job.)
• When choosing to summarize by cost set, remember to have calculated the part costs in IFS/Costing

System Effects

As a result of this activity, the system will print a report.

Window

Inventory Value per Period

Related Window Descriptions

Inventory Value per Period

Procedure

1. Open the Inventory Value per Period window.
2. Populate or query for the required statistical period.
3. Right-click on the header and then click Summarized Inventory Value Report. The Summarized Inventory Value Report dialog box will appear.
4. By default, the selected statistical period will appear in Period area. If you want to change the period, you can do so by specifying the desired year, period and the site in the relevant fields.
5. Choose how you want to summarize the inventory value, based on cost types (inventory value, latest purchase price or average purchase price) or based on cost types defined in IFS/Costing (only available if this is installed).
6. If you wish to print the report with details for each specific part, select the Include parts in report check box.
7. Select at least one and up to five different criteria for presenting the inventory summarized value.
8. If you wish to print the report for a specific location group, indicate it in the Location Group field.
9. Click Preview to view the report prior to printing.
10. Click Print to print the report.