Currency Conversion happend Record wise or on Aggregated Level

[Former Member]

Hi ,

Suppose we've currency converison applied on 0CALMONTH.

And suppose we've 5 records for a CALMONTH december. In the Report, we do not ahve Document No as part of rows, so in that case data for a CALMONTH will be aggregated.

So, in that case, whether the Currency Conversion happens on each record and then does the aggregation OR it will first do the aggregation for teh CALMONTH and then does the CURRENCY CONVERSION ?

Thanks & regards,

Jomy

[Former Member]

Hello Jomy,

Currency conversion would depend on how Conversion type is defined in the system.

Few of them are with ref. to current date, with ref. to date info object value, with ref. to specific date etc etc.

Hope that helps.

Regards

Mr Kapadia

[Former Member]

I think you did not get my query.

I've already created a Currency COnversion Type with Variable Time Reference with 0CALMONTH.

Thanks & regards,

jomy

[Former Member]

Hi,

In that case first amount in original currency would be aggregated by 0CALMONTH and then would be converted to target currency.

Hope that helps.

Regards

Mr Kapadia

[Former Member]

Hi,

Thats great but how can we verify that to just cross check.

Thanks & regards,

Jomy

[Former Member]

Hi,

You may try to put 0CALMONTH in rows and KFs of Amount in original currency as well as Converted amount into Columns.

First observe Total of converted amount by expanding to 0CALMONTH in rows then remove the characteristics 0CALMONTH from rows and then see Total of converted amount.

If there is no difference it means that our understanding for currency conversion is correct.

Hope that helps.

Regards

Mr Kapadia

[Former Member]

ok.

I agree to your point, but i'm not able to understand that if the values are same in both these approaches then it can also happen that-->

Internally it has done currency conversion for each record even without 0CALMONTH in rows and then aggregated, right?

Thanks & regards,

Jomy

[Former Member]

Hi Jomy,

Yes , system does the conversion for each record as per 0CALMON and then shows the report.

Hope that helps.

Regards

Mr Kapadia