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
- Open the Inventory Value per Period window.
- Populate or query for the required statistical period.
- Right-click on the header and then click Summarized Inventory Value Report.
The Summarized Inventory Value Report dialog box will appear.
- 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.
- 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).
- If you wish to print the report with details for
each specific part, select the Include parts in report check box.
- Select at least one and up to five different criteria
for presenting the inventory summarized value.
- If you wish to print the report for a specific location group, indicate
it in the Location Group field.
- Click Preview to view the report prior to printing.
- Click Print to print the report.