Function documentationLocation of Inventory Data

 

You can specify that inventory data is read from the totals database or from additional financial data.

Features

When inventory data is read from the totals database, you are spared the extra effort in entering additional financial data and validating that data.

The system can read the following inventory data from the totals database:

  • Gross book value and inventory quantity

  • Valuation allowance allowing losses

  • Valuation allowance disallowing losses

  • Incidental costs or percentage rate of incidental costs

Customizing

Customizing settings are dependent on the consolidation area. They belong to the special version for elimination of interunit profit/loss in transferred inventory, but they are not time-dependent.

You define single selections to have the system read the relevant totals data. The selections are comprised of inventory items, product groups, and subassignments. If you define a single selection with a combination of inventory items and product groups, the system automatically reads the related subassignments according to the breakdown categories that are shared between the different inventory items. Subassignments can be, for example, custom subassignments, transaction types, subitems, or subitem categories. However, subassignments cannot be product groups, partner units, investor units, or investee units. Once the definitions are complete you can specify the desired values for the subassignments.

Note Note

If you use the transaction type as a subassignment for gross book value, valuation allowances, or incidental costs, you also need to specify the value for the carry-forward transaction type.

End of the note.

You use the values for the subassignments to determine the gross book value or inventory quantity, valuation allowances, and incidental costs.

The following conditions must be met for single selections:

  • Single selections of inventory items and product groups may not overlap.

  • Single selections for the respective subassignments (for gross book value, valuation allowances, and incidental costs) also may not overlap.

When you save your Customizing settings, the system checks that the following requirements are fulfilled:

  • All inventory items require breakdowns by product group, partner unit, and one or more additional subassignments.

  • At least some of the breakdown categories of the inventory items of a single selection must have the same subassignments; only then is the system able to determine the subassignments.

  • If a single selection contains transaction types, the carryforward transaction type must be contained in the same single selection as the transaction type of the original document. If it is not, the data that is carried forward can no longer be found once the balances have been carried forward. (See also the note shown above.)

  • The single selections may not overlap (see earlier).

If any of these requirements are not fulfilled, the system issues an error message.

Currency Translation

When additional financial data is read, the system translates data recorded in local currency for the elimination of interunit profit/loss in transferred inventory using both the exchange rate indicator and the comparative exchange rate indicator of the task. The system uses the comparative exchange rate indicator to determine and record currency translation differences (see Recording of Currency Translation Differences).

When totals data is read, the system translates the totals data in the currency translation task prior to the task for elimination of IU profit/loss in transferred inventory (IPI). In this case, the system uses the comparative exchange rate indicator of the IPI task as well to record currency translation differences.

Database Lists

When the system reads the inventory data from the totals database, the database list displays the data in both local currency and group currency.

When the system reads the inventory data from the totals database, the selection screen for listing inventory data provides the following option:

You can determine whether the system should read the logical or the physical data stream. If the system reads the data from the totals database, you must choose the option for the logical data stream; only if you choose this option does the system use special logic when reading from the totals database. (If you choose the physical data stream when data is read from the totals database, the physical data stream does not provide any data because it is intended for additional financial data only.)

Activities

Customizing

Prerequisite:

If you want to choose additional financial data as the data source for inventory data, the data basis needs to contain the InfoProvider for inventory data. This is not necessary if you want to read the inventory data from the totals database.

Procedure:

  1. In the process view of the consolidation workbench, choose Start of the navigation path Consolidation Functions Next navigation step Elimination of IU Profit/Loss in Transferred Inventory Next navigation step Settings Next navigation step Location of Values End of the navigation path.

  2. Go to the General tab page and specify the location from where the inventory data is to be read (totals database or additional financial data).

  3. If you specify the totals database, also go to the Inventory Data tab page and specify the single selections, which should consist of inventory items and product groups.

  4. Follow these steps for each single selection:

    1. Go to the detail view for the single selection by choosing the navigation arrow.

      The detail view shows the subassignments for gross book value, valuation allowance allowing losses, valuation allowance disallowing losses, and incidental costs (see earlier).

    2. Specify the appropriate values for each subassignment.

  5. Save your entries.