Dividing GC results by Thousands and Rounding

[Eyal_Feiler]

Hi all - is there a solution within GR for dividing and rounding thousands? I didn't see one.

I recall with BCS it was a step in translation as part of rounding. Otherwise the rounding work shifts to the report presentation and messy balancing due to rounding diffs.

In implementation where the financial booklet is used we can change the scaling for presentation - at least for viewing without rounding.

Thank you in advance.

Regards

Eyal

[Harish_Vatsa]

Hello eyal.feiler2,

This can be achieved by using the CO-PA (Profitability Analysis) valuation method, where you can define a currency translation factor that divides the value of a controlling area currency by a specific factor (e.g. 1,000).

The system will then automatically round the result based on the number of decimal places defined in the valuation method. This can be set up in transaction KEPM or the Customizing for CO-PA (transaction SPRO).

--

Kind Regards.

[Eyal_Feiler]

Thanks Florian,

We would like to implement a solution based on LC in Group Reporting using CT.

Could you clarify re "The CT approach would apply the factor as part of the translation, i.e. the exchange rate would contain the factor"?

With BCS we used the rounding feature (I see the last step it in the best practice - for us to test and understand).

What we would do - is create a Thousands currency for the gorup currency e.g. "TEUR" and define the ratio between the LC and TEUR as 1000:1 so that the amounts would divide.

The idea was to try and do this together with the rounding feature in CT.

Regards,

Eyal

[FlorianRoll]

Hi Eyal,

beside the already mentioned option to divide in analytics you could also use the currency translation (CT) in group reporting. I would assume this approach would be very similar to the BCS approach you mentioned.

The main differences would be
- analytics solution does not change the numbers on the database, i.e. in case there is the need for a higher precision the division can be removed. The CT approach would apply the factor as part of the translation, i.e. the exchange rate would contain the factor. With this the result is stored on the database and there is no option to get back to a higher precision.

- rounding is part of the CT. Selections can be defined, compared, and the difference can be posted to an FS item being part of one selection's data range, achieving a rounded result. The prerequisite for this is that the rounding condition is met in local currency.

- analytics is based on GC, whereas CT is based on LC. Hence adjustment postings in GC would need to be done in thousands, and again the precision is lost.

Hope this helps.

Kind regards,

Florian

[Eyal_Feiler]

Hi Florian,

Returning to the question – I created a translation ratio for 2 currencies of 1000:1 (AVG and CLO exchange Rates 1:1) so that the GC result includes the decimal.

If we want a rounded result like column F from currency translation or another Group Reporting solution is that possible?

I reviewed the 3 rounding steps and they make sense but they don’t activate in this example since the translation result coming into GC is balanced. Thanks in advance.

Regards

Eyal