Topic overview

The Output item accounts application is used to output the quantities and values of inventory valuations relating to selected items using the floating average price valuation method.

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 also 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 Procedures: Output report documents article.

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 accounts application to output the quantities and values of inventory valuations relating to selected items using the floating average price valuation method.

The inventory values displayed correspond to the quantities and values totaled per day in the Item account view of the Inventory value query application. However, corrections without quantity transaction and values not to be displayed are ignored.

You must enter the posting period as a search criterion. Optionally, you can enter a warehouse or several items as additional search criteria. Floating average price is always used as the valuation method.

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 accounts 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.

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

Fiscal year/Period – these two parameters define a posting period. Only the inventory valuations from this period are output. Both parameters are mandatory.

Inventory item

Warehouse – this parameter restricts the inventory valuations 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 valuations are totaled.

Firm – in a multi-site environment, the selected firm for which the account assignments are valid is displayed in this field. Accounts and account assignments are firm-dependent.

Output result

At least three lines are displayed for each item for which there was an inventory valuation in the specified posting period. The first line shows the valuation quantity and value at the beginning of the posting period. The last line shows the valuation quantity and value at the end of the posting period. In between, a further line is displayed for each day on which an inventory valuation took place.

The table rows contain the following columns:

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

Posting date – the date of the inventory valuation.

Receipt quantity – the total receipt quantity of all inventory valuations on the posting date. Corrections without a quantity transaction are not taken into account.

Issue quantity – the accumulated issue quantity of all inventory valuations on the posting date.

Inventory quantity (begin) – the inventory quantity at the beginning of the period.

Inventory quantity (posting date) – the inventory quantity according to the inventory valuations of the day.

Inventory quantity (end) – the inventory quantity after all inventory valuations in the posting period.

Receipt value – the total receipt value of all inventory valuations on the posting date. Non-attributable values are not taken into account.

Issue value – the total issue value of all inventory valuations on the posting date. Non-attributable values are not taken into account.

Inventory value (begin) – the inventory value at the beginning of the period.

Inventory value (posting date) – the inventory value according to the inventory valuations of the day.

Inventory value (end) – the inventory value after all inventory valuations in the posting period.

Customizing

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

Report

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

Item account: com.cisag.app.inventory.rpt.TransactionValuesByItem

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 accounts application.

Organization assignments

For a person to be able to use the Output item accounts application, they must be assigned an organization in the partner master data that is included in the following organizational structures:

• Inventory management
• Financials

Special features

There are no special features for the Output item accounts application.

Authorizations for business partners

The Output item accounts application is not released for business partners.