cancel
Showing results for 
Search instead for 
Did you mean: 

EC-CS retained reanings roll

Former Member
0 Kudos

We changed a company from being a flexibale upload to EC-CS to uploading to FI. In this process we changed the consolidation unit master data from flexible upload to roll up. This change was made in Dec. of 2010 but our problem was not noticed until Jan 2011.

The problem is lthat the account for the current year earnings and the earnings account on the income section show transaction currency, local currency but no group currency with all the current month income change going to the translation adjustment 01. The company is a Mexico currency for local currency and USD for group.

When we carried into year 2011 we noticed the problem because the currency translation was getting the wrong value for Ref value (the value has not changed since we changed the upload methode) which made it out of balance and it did a rounding error for all the revenue from prior year.

I have been going over all the configuration and master data and do not see any differences from other consolidation units that are working

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member209721
Active Contributor
0 Kudos

Hi Dougs

I know very well BCS and ECCS, but your case is not very clear

Could you please re-phrase it in a more simple way, or with an example ?

Former Member
0 Kudos

Ok thanks for the response I will try again.

We changed a consolidation unit from being flexible upload to ec-cs to upload to FI and rollup to EC-CS.After doing this the accounts used in the RE/Item substitution process started to react differently.

What it shows for the current year retained earnings on the balance sheet is

Unit Item C Subitem PU PL Aptn Tran DT C Profit C TC TC value LC LC value GC value

1030 330003 00 9100 MXN 12,592,547.16 MXN 12,592,547.16 0.00

1030 330003 00 1 9100 MXN 0.00 MXN 0.00 1,014,819.24

  • 1030 MXN 12,592,547.16 MXN 12,592,547.16 1,014,819.24

The income satement side works the same. It appears to be rolling the transaction currency and local currency but not the group currency. On other consolidation units it shows the usd amount on the first line and the translation amount would be what shows in the income statemnt accounts. What is showing here looks to be a balancing entry.

Edited by: Dougs1 on Mar 16, 2011 8:58 PM

.

The spacing does not come out on the display

If I run CX34 for the two accounts used in the item substitution retained earnings one used for the balance sheet and the other for the income statement. I can drill down on the uploaded data posting level 00 or blank to get the monthly data it shows an amount for transaction currency, local currency and group currency for every month up to the change. After the change the group currency is zero.

Edited by: Dougs1 on Mar 16, 2011 9:47 PM