Report painter question regarding amounts in different currencies
2015-10-11 Views:1
Hi, I have a report created in GRR2 using library 1VK. We display the total costs SWOG here but have the request to see in addition these costs in USD simulteanously. For that I included the basic key figure SWZG. When executing the report there is n
I have a report created in GRR2 using library 1VK. We display the total costs SWOG here but have the request to see in addition these costs in USD simulteanously. For that I included the basic key figure SWZG. When executing the report there is now a new selection parameter Target currency, Exchange rate date and Exchange rate type. I can see a new column with USD values, so far so good. But when I check the calculation I find that it can't be right, it differs from what it should calculate.
If I execute the report and select currency tranlsation of the key figure SWOG with exactly the same exchange parameters as above I'm getting different values in USD which match my manual calculation.
Any idea why this happens? What do you recommend to have both currencies ate the same time on the screen?
Thank you
Exberliner
try this,
FM - > spell_amount
OR
data: words(50) type c.
call function 'HR_IN_CHG_INR_WRDS'
exporting
amt_in_num = '100000'
importing
amt_in_words = words.
write:/ words.
OR
RF_SPELL
rgds
anver
Report painter question regarding amounts in different currencies
Category:DefaultRelease time:2015-10-11Views:130
Hi, I have a report created in GRR2 using library 1VK. We display the total costs SWOG here but have the request to see in addition these costs in USD simulteanously. For that I included the basic key figure SWZG. When executing the report there is n[More]
Report Painter - new Basic Key Figure for Currency Translation
Category:DefaultRelease time:2015-10-11Views:130
Hi, I need a report painter report which allows to translate the company code currency HSL in GLPCT into several target currencies. Theoretically I need to translate each month with an own translation rate and possible different translation keys. In[More]
Including Second Local currency in Report Painter
Category:DefaultRelease time:2015-10-11Views:130
Hi there, My client is using parallel currency and their LC2 is USD. I am trying to create a Cost centre report using report painter and want to add LC2 amounts in this report. Is it possible to add LC2 using report painter? The following is some a[More]
Parallel currency in Report painter
Category:DefaultRelease time:2015-10-11Views:130
Hi I need help around the Report Painter report. One of our company code is located in Hong Kong and there are three currencies set-up for this entity. Local currency is CNY, Group currency is in USD, and Third currency is in HKD. Our report painter[More]
Display the values in Docment Currency in Report Painter-FDI4
Category:DefaultRelease time:2015-10-11Views:130
Hi, Am new to report painter. i created report painter in FDI4. this report is to display the due amount. when i click on table cell, which is amount field . Am chosen cell type as 'Select with Key figure' option . After then i try to select key figu[More]
Currency in Report painter
Category:DefaultRelease time:2015-10-11Views:130
Hi, I have a question about report painter. Is it possible to create a report with report painter that displays the information in a currency different from operating concern currency? For example, in KE24 I can display the value fields in the entry[More]
Report painter- Amount in Document currecy instead of LC
Category:DefaultRelease time:2015-10-11Views:130
Hi, Am new to report painter. i created report painter in FDI4. this report is to display the due amount. when i click on table cell, which is amount field . Am chosen cell type as 'Select with Key figure' option . After then i try to selec[More]
- 1 Expired Sites in Creative Cloud for Teams
- 2 My windows computer died,it now has linux mint 9.I installed itunes on a new windows computer.Purchased new songs but it wont let me download or dispaly my old music.But it did transfer 3 movies over to new itunes account.
- 3 ICM 7.5 Agent Password change utility/interface
- 4 Why does Firefox (3.6.12) try to access the Net as it starts, but before the Ffx window first shows & once more when the window opens, if I've set updates to manual and "about:blank" as my home page?
- 5 Oracle 9 and XA transaction recovery
- 6 I have deleted all my videos songs and photos from my iphone 4 but when i connect to itunes it still shows 17gb free. how can I solve this issue without restore. Total storage of my iphone is 32 gb.
- 7 Why is Family Sharing not allowing me to ask for purchases from my mom?
- 8 Help my daughter did something really bad to my Mactop while playing a game.
- 9 Travel time not showing on iPhone
- 10 Reset Cleared document for multiple docs
- Couldn't verify 'C:\Windows\ccmsetup\ccmsetup.cab' authenticode signature. Return code 0x80096001 - SCCM 2012 R2 Client Deployment
- How to find ssid number on ipad 3 to connect hp Photosmart 6510 B211a
- Problem with CS4 Master Collection Install
- Why won't some music sync from iTunes to my iPhone 5?
- Delete apps from ipod touch with ios6
- Tcode to look for a transport request number
- Options in Publishing Discoverer Report output
- Itunes Match: Two users on one computer.
- Cannot connect to internet with firefox. Microsoft Explorer gives me an error message. I know my computer is connect, because I keep getting updates on the weather. What's up?
- Writing a class to provide Self ID capability in a JAR file.