Currency issue in S_ALR_87013558 report.

[former_member412338]

Hi Experts,

I have an issue here with 558 report, budgeting has been done in CAD currency and PR has been aslo made in CAD.

But when i run this report i get the main budget in CAD, while commitment, assigned and available shows in USD.

It should come in CAD, i also tried to change the currency in 558 report via currency symbol, that is converting USD to CAD but at the same time it converts main budget (which was already in CAD) again to another value based on that conversion rate its converting to commitment.

I have been through all the posts on SCN, but couldnt find any precise answer.

Please help me getting the uniform values in 558 report.

Thanks,

Vindhesh

[srinivasan_desingh]

Hi Vidhesh,

Go to transaction RPP0 and change the report currency to object currency or configure accordingly to your needs.

After that you run your report and check.

Just give a try and let me know.

Thanks

Regards

Srinivasan Desingh

[former_member195427]

Hi,

When you run S_ALR.. report it will be showing you data in TranCurrency(CAD).

After executing it , Select those individual columns manually or which you want to see figures in CAD, it will not touch you budget figures which are already there in S_alr report.

Thanks

[former_member412338]

Thanks for your reply Saurabh!!

But i have already tried this option and its not showing the correct values, let me explain you when i convert the available colomn it converts in CAD from USD but now this value is something different as per rule avail = budget - assigned.

And second thing suppose PR is done into CAD & in 558 report i get it in USD so when i convert it to CAD it takes the current (or any) conversion rate which makes a difference from the real value.

I want to see the uniform values in S_ALR_87013558 report as i have posted in CAD so same values should be displayed in report, suggest me how it is possible.

Thanks,

Vindhesh

[Former Member]

Hi Vindhesh,
Is it possible for you to take screen shot of the report without and with any conversion applied to it and send on this forum.  It will help understanding.

Regards,

Gireesh

[Former Member]

Hi Vindhesh,

Why dont you explore the option of Report Painter?

You can find more details on that here on SCN.

Regards,

Gokul

[former_member195427]

Hi Vindhesh,

I believe whenever you will use currency translation in S_ALR...58 report it will get exchange data from OB08/OB07.

If you want to get budget vs actual comparison in its original currency(values when you budgeted and actual)  then go with CN40 transaction.

Or

For hierarchy report go with report painter option as Gokul has suggested above and make you of 'Variable' Transaction currency to generate your report.

Regards

Saurabh