Sitemap

Amicuk Programming Answers

Report painter question regarding amounts in different currencies

2015-10-11   Views:1

Advertisement

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

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 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

The replay answer
Advertisement
hii sanjeev.
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

Go to See the other 6 answers

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]

Hot
Hi Experts, I am facing with an issue where we found incosistencies with table ROOSPRMSF in R/3 system. In BW , we have done initializations based on fiscal period selections (none of the selections overlap) for data source 0FI_AP_4. We have done in [More]
Just got new air and trying to set up. When I put in my Apple ID and password it comes up with error message 'can't sign in because of server error. Try again signing on.' Trying again does not fix. I know my ID and PW are right as work on other appl [More]
i can not sign in with my skype and i can not log in even via the site here and i do not remember the email i used when i registered for the skype name it was more than 2 or 3 years ago and i can not recover it my skype name: [Redacted for privacy.] [More]
I have a MBP and I bought the Mini DVI to HDMI cable and it looks great on my HDTV. But I am wondering if there is a way to use the TV as a monitor and still use the laptop at the closed position?With a MacBook or MacBook Pro, if you connect an exter [More]
We have developed a large of Answers or BI Publisher report. If the width of a column, used in some of the reports, is changed, is there any way to find out / search the affected Answers or BI Publishers reports ? Or do I need to open each report to [More]
Using iPhone 4S, iOS 8 When we first got our iphones we set up to share our iTunes account so we only had to buy an app once.  Now with Family Sharing we want to separate into our own apple IDs.  We plan to get new iPhone 6 s soon and want to back up [More]
I have been using my apple id for both mine and my daughter's purchases, but now I want to separate hers into her own apple id. Can I transfer purchases?No, that's not possible unless Apple is willing to assist. You would need to open iTunes and clic [More]
I am trying to free up storage space on my imac hard drive.  I have one external hard drive with 500 GB storga and then another 2 TB external hard drive that I am using as my time machine back up of everything.  I moved my itunes library (approx. 70G [More]
I decided to write directly to both of the CEOs of RIM -- I sent it via fax and via mail.Direct you to the proper forum for MacBook : MacBook Series Forumshttps://discussions.apple.com/community/notebooks?view=discussions Mac OS X Forums https://disc [More]
Hi all, I am trying to Package and deploy Powerpivot Add-in for Excel 2010. I have the Powerpivot_X86_(11.1.329.0) .MSI which installs Unattended, but Uninstallation will not remove entry from COM ADD-IN list in Excel and at first re-launch (even aft [More]