Additional Financial Data

Definition

Information that is required in addition to or instead of the data in the totals database (meaning in addition to or instead of the balance sheet, income statement, and so on).

For the Elimination of Interunit Profit/Loss in Transferred Inventory, the additional financial data is data on the interunit delivery of goods and services:

  • Inventory data

  • Supplier data

  • Supplier share

    Note Note

    As an alternative, you can have the system also read the inventory data from the totals database. See the section Location of Inventory Data.

    End of the note.

Use

In the Elimination of Interunit Profit/Loss in Transferred Inventory, the additional financial data is used to determine

  • the book value and

  • the group cost of goods manufactured

of an asset. This calculation is based on the standardized financial data that considers the incidental acquisition costs that must be capitalized.

Structure

Inventory Data

The inventory data includes:

  • Versions

  • Fiscal year and period

  • Consolidation unit (here: inventory-managing consolidation unit)

  • Partner unit (here: supplying consolidation unit; optional for postings at posting level 30; if no partner unit is specified in the additional financial data, the system determines this from the supplier share)

  • Product group

  • Balance sheet item

  • Book value in the reporting period

  • Valuation allowances (allowing losses)

    This includes non-permanent valuation allowances (for example, non-permanent lump sum valuation allowances for spare parts).

  • Valuation allowances (disallowing losses)

    A valuation allowance disallowing losses is a permanent valuation allowance that must not convert a positive gross interunit profit/loss (gross interunit profit/loss = book value in reporting period - group cost of goods manufactured) to an interunit loss, so as not to violate a principle of prudence and lowest value applied in the individual financial statements. The interunit profit and loss to be eliminated is not negative.

  • Inventory quantity

  • Incidental acquisition costs

    The incidental acquisition costs are incidental acquisition costs that must be capitalized from the group's perspective, which increase or reduce the group cost of goods manufactured. From the perspective of the consolidation units, these incidental costs would be posted successfully with an effect on net income as soon as they are incurred.

  • If necessary, percentage rate of incidental costs

Supplier data

The supplier data includes:

  • Versions

  • Starting year and starting period

  • Consolidation unit (here: supplying consolidation unit)

  • Partner unit (here: inventory-managing consolidation unit; entry always optional)

  • Product group

  • IPI (as markup or gross margin)

  • Rate of distribution costs of sales

  • Rate of cost of goods manufactured per unit of measure or of sales

The supplier data is valid in all subsequent periods after the starting period, meaning that you do not need to reenter it if the supplier data has not changed. This minimizes the data entry effort.

IPI Variants

Profit percentage

20

Sales at supplier

300

  • Profit if "IPI markup" is used for the calculation

    300 * 20/120 = 50

  • Profit if "IPI gross margin" is used for the calculation

    300 * 20/100 = 60

Supplier Share

The system needs the supplier share if you want to map supply chains. The supplier share includes:

  • Versions

  • Starting year and starting period

  • Consolidation unit (here: inventory-managing consolidation unit)

  • Partner unit (here: supplying consolidation unit)

  • Product group

  • Supplier share in percent

    The supplier share defines the percentage of inventory that the relevant consolidation unit delivers.

    If you specify the supplier share, the system calculates supply chains.

    However, the supplier share is taken into account only when the execution of elimination of interunit profit/loss in transferred inventory is group-based (that is, when posting level 30 is used).

    Example Example

    Inventory data: consolidation unit A, partner unit initial, book value USD 1000, meaning that consolidation unit A has an inventory of USD 1000

    Supplier share data: consolidation unit A, partner unit B, supplier share 50%, meaning that 50% of the inventory of consolidation unit A was delivered by B

    End of the example.

  • Percentage rate of incidental costs

See Also