Example: Elim. of IU Pay./Rec. with Splitting of Differences

Initial Situation

You want to perform for consolidation group CG1 an elimination of interunit payables/receivables with the splitting of differences.

You have collected the following reported financial data, which has breakdowns by transaction currency:

Reported Data

Cons Unit

Item

Partner Unit

Posting Level

Value in TC

Value in GC

A

Receivables

B

00

100  ARP

120  USD

B

Payables

A

00

80- ARP

100- USD

A

Receivables

B

00

100  JOD

200  USD

B

Payables

A

00

80- JOD

150- USD

The exchange rates for translating transaction currency to group currency are as follows:

  • 1.3 for translating ARP into USD

  • 2.5 for translating JOD into USD

A. Customizing of Interunit Elimination

Define tasks and document type

  1. Define a task for the elimination of interunit payables/receivables.

  2. Define a document type for the elimination of interunit payables/receivables, or use an existing one with the following properties:

  • Posting level 20 (two-sided elimination entry)

  • Automatic posting

  • Posting in group currency and transaction currency

Define method layout

Create a new method layout or use an existing one, which can look like this:

Define in ...

Strategy for Differences

Selection 1

Selection 2

Other Diffs

Crcy-related Diffs

... the method

         

Visibility

X

¯

¯

¯

¯

Detail Screen

 

Item

Item

Item

Item

Fast Entry

         

You do not need steps (hence no entry for fast entry), nor do you need substeps.

Define method

Create a new method, or use an existing one. Do the following if you create a new method:

  1. Define the following in the general settings :

  • Two-Sided Elimination

  • Differences are determined per transaction currency

  • Exchange rate indicator (for example, current exchange rate)

  • No limits

  1. In the selections determine the FS items to be eliminated:

  2. Selection 1

    Characteristic

     

    Selection 1

    Item

    =

    Receivables

    Selection 2

    Characteristic

     

    Selection 1

    Item

    =

    Payables

  3. For the elimination differences define the following:

  • Differences are posted to the Unit from selection 1

  • Key figure: total in group currency

Items for other differences

Characteristic

Debit

Credit

Default

Item

Other Operating Expenses

Other Operating Revenue

Items for currency-related differences

Characteristic

Debit

Credit

Default

Item

Loss from Currency Translation

Gain from Currency Translation

Assign method and document type

Assign the document type and the method to the task for eliminating interunit payables/receivables.

B. Execution of the Interunit Elimination

Execute the task in the consolidation monitor.

  1. Place the cursor at the intersection between interunit payables/receivables and consolidation group CG1 .

  2. Choose Update Run .

Result

The system clears the selections with each other and posts the elimination difference to the differential accounting objects.

Note Note

The system does not post the last line item (which is written in italics). It is only shown here for informational purposes.

End of the note.

Cons Unit

Item

Partner Unit

Posting Level

Value in TC

Translation TC to GC

Value in GC

A

Receivables

B

20

100- ARP

(130-)

120- USD

B

Payables

A

20

80  ARP

(104 )

100  USD

A

Other Oper. Expenses

B

20

20  ARP

(26 )

26  USD

A

Gain from C/T

B

20

0  ARP

(0 )

6- USD

A

Receivables

B

20

100- JOD

(250-)

200- USD

B

Payables

A

20

80  JOD

(200 )

150  USD

A

Other Oper. Expenses

B

20

20  JOD

(50 )

50  USD

A

Loss from C/T

B

20

0  JOD

(0 )

0  USD