Topic overview

You can use the Output item period values application to output the inventory valuations of selected items for a specific posting period and a specific valuation method. The ouput inventory values correspond to those of the Item values periodic view in the Inventory value query application.

You must enter at least the posting period and the valuation method as search criteria. Optionally, you can also enter a warehouse or several items as additional search criteria.

This article informs you in particular about the parameters of the application with which you define what the report document to be output contains. You will also find information about the output result. The possible output settings in this application correspond to the setting options in the dialog window for any output. You will find a description of the possible output settings in the Operating guidelines.

The procedures for using the application can be found in the article Procedures: Output report documents.

Definitions of terms

Inventory valuation
Inventory valuation is an ongoing calculation of the corresponding value for item inventory available in the warehouse. The value is expressed in monetary units in the corresponding internal currencies. All inventory postings that cause changes to the quantity or value of inventoried items are documented in various valuation processes. In the course of generating the inventory postings, the inventory and its valuation is updated on the basis of the floating average price method. The full sequence of dated inventory valuations, such as FIFO (first in/first out) or LIFO (last in/first out), can only be identified after the posting period has been closed.

Report document
A voucher document or report document is generated when a report is output to an output device, such as a printer or to a file. The report document contains a list of objects, e.g., a list of addresses. A voucher document always concerns one object—a sales order, for example. The documents may be archived or forwarded to a partner, for example, as a fax or by e-mail.

Application description

You can use the Output item period values application to output the inventory valuations of selected items for a specific posting period and a specific valuation method. The displayed inventory values correspond to those of the Item values periodic view in the Inventory value query application.

You must enter at least the posting period and the valuation method as search criteria. Optionally, you can also enter a warehouse or several items as additional search criteria.

Parameters section

Use the parameters to define the search criteria and, as a result, the output result. Parameters are therefore used for data set selection.

The parameters available in the Output item period values application are explained below:

Report title – this parameter contains the title of the report document. The default value is usually the name of the underlying report. The title can be defined individually. Enter the desired title or change the default value.

Inventory item – this parameter determines for which items the inventory values are output. Enter the identification of the desired items. If you do not enter a search criterion, all items with inventory values will be output.

Period – this parameter defines a posting period. Only the inventory values from this period are output. This parameter is mandatory.

Warehouse – this parameter restricts the inventory values issued to one warehouse. To do this, enter the identification of the warehouse in this parameter. If you do not specify a warehouse, the inventory values are totaled.

Optional valuation method – with this parameter you can define the valuation method used to determine the issued inventory values. The following methods are available:

• Moving average price
• FIFO
• LIFO
• Annual LIFO

The specification of a valuation method is mandatory.

Inventory owner – in a multisite environment, the company of the inventory owner is displayed in this field.

Output result

The report shows the period results in a table. A line is displayed for each item or, if applicable, item/warehouse.

The table rows contain the following columns:

Item – the identification and description of the item is displayed.

Inventory quantity – the inventory quantity of the item at the end of the posting period is displayed.

Price – the quotient of inventory value / inventory quantity is calculated and displayed.

Inventory value – the inventory value of the item at the end of the posting period is displayed.

Customizing

No settings need to be defined for the Output item period values application in the Customizing application.

Of the settings for the Financials framework in the Customizing application, the following fields in the Valuation function are relevant for the Output item period values application:

Valuation level – in this field, you define which valuation levels are available in the applications Calculate inventory values, Inventory postings and Inventory value query and at which level the average price is calculated. Two levels are available:

• Item
• Item/warehouse

Optional valuation method – in this field, you specify which valuation methods are available in the Calculate inventory values and Inventory value query applications.

Report

The following report is relevant for the Output item period values application, which you use, for example, to assign authorizations.

Item period values: com.cisag.app.inventory.rpt.PeriodValuesByItem

Authorizations

Authorizations can be assigned both with the help of authorization roles and by assigning an organization. The authorization concept can be found in the technical article Authorizations.

Special capabilities

There are no special capabilities for the Output item period values application.

Organization assignments

For a person to be able to use the Output item period values application, they must be assigned an organization in the partner master data that is integrated into at least one of the following organizational structures:

• Financials

Special features

There are no special features for the Output item period values application.

Authorizations for business partners

The Output item period values application is not released for business partners.