Currency Format Problem

[Former Member]

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

[Former Member]

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

Will solve ur problem.

[Former Member]

Hi,

Check for the User Settings In SU01 T Code.

You can change the format.

Also check for the Country specific settings.

Regards,

Anji

[Former Member]

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.

[Former Member]

Hello,

Go to System->UserProfile->Own Data

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

Regards,

Shehryar

[Former Member]

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

[Former Member]

Hello,

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

Regards,

Shehryar Dahar

[Former Member]

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

[anversha_s]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

Will solve ur problem.