Example: Elim. of IU Pay./Rec. with Splitting of DifferencesYou 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
Define a task for the elimination of interunit payables/receivables.
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:
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
In the selections determine the FS items to be eliminated:
Selection 1
Characteristic |
Selection 1 |
|
Item |
= |
Receivables |
Selection 2
Characteristic |
Selection 1 |
|
Item |
= |
Payables |
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.
Place the cursor at the intersection between
interunit payables/receivables
and
consolidation group CG1
.
Choose
Update Run
.
The system clears the selections with each other and posts the elimination difference to the differential accounting objects.
Note
The system does not post the last line item (which is written in italics). It is only shown here for informational purposes.
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 |
|
|
|
|
|
|
|