topic Re: Currency Format Problem in Application Development and Automation Discussions

Currency Format Problem

Former Member — Mon, 26 Feb 2007 10:47:16 GMT

Hi folks,

In Smartform, when i am displaying the amount it is coming as 10.000 instead of 10,000. I want the same in the second format. Please help me for the same.

Thanks in advance

Siddarth Jain

Re: Currency Format Problem

Former Member — Mon, 26 Feb 2007 10:48:27 GMT

Hi,

Check for the User Settings In SU01 T Code.

You can change the format.

Also check for the Country specific settings.

Regards,

Anji

Re: Currency Format Problem

Former Member — Mon, 26 Feb 2007 10:49:07 GMT

Change the user settings.

<b>System > User profile > own data > default tab > change it to second option.</b>

This will solve ur problem, reward points if thsi helps.

Re: Currency Format Problem

Former Member — Mon, 26 Feb 2007 10:51:20 GMT

Hello,

Go to System->UserProfile->Own Data

change the decimal notation in the 'Default's tab.relogin and check the change.

Regards,

Shehryar

Re: Currency Format Problem

Former Member — Mon, 26 Feb 2007 10:52:37 GMT

u have declared the field which is currency type filed, there u can also define currecy field in smartform...asiign related curreny reference field.....

( in global declaration threre is one more colom at the declaration....assign threre...

)

smartforms->ur smartform->change mode->Global definations->go to tabstrip Currency/Quantity field..

give ur field name which is already assigned and give reference field name and check currency...

Ramesh.

Message was edited by:

Ramesh

Re: Currency Format Problem

Former Member — Mon, 26 Feb 2007 10:59:02 GMT

Hello,

in addition to my thread, you can use the respective correct currency key.

Regards,

Shehryar Dahar

Re: Currency Format Problem

Former Member — Mon, 26 Feb 2007 11:19:32 GMT

Hi folks,

First of all thanks for your reply. Current settings for the user 1,234,567.89 but still it is showing in 1.234.567,89.

thanks in advance

Siddarth

Re: Currency Format Problem

anversha_s — Mon, 26 Feb 2007 11:23:55 GMT

hi,

try this.


 1.234.567,89 => 1,234,567.89 .


data: l_amnt(100) type c.

l_amnt = your_value

replace all occurrences of '.' in l_amnt with '#'.

replace all occurrences of ',' in l_amnt with '.'.

replace all occurrences of '#' in l_amnt with ','.

write : l_amnt.

Regards,

Anver

Re: Currency Format Problem

Former Member — Mon, 26 Feb 2007 11:36:23 GMT

Hi Folks,

Problem is something different. I just now debugged the program and got that in the field of intenal table it is showing in proper format i.e. 1,234,567.89 but when I drag that field and put it on the smartform then the format changes to 1.234.567,89. That is what happening which i don't want. So please help me for the same.

Thanks in advance.

Siddarth.

Re: Currency Format Problem

Former Member — Mon, 26 Feb 2007 11:41:32 GMT

do like this

Go to System->UserProfile->Own Data

change the decimal notation in the 'Default's tab.relogin and check the change.

Restart the system and u ll get the required result..

Re: Currency Format Problem

Former Member — Mon, 26 Feb 2007 11:43:29 GMT

The problem is with ur settings only, please change the same and save it. Login againa nd check.

Will solve ur problem.