on 07-31-2011 7:05 PM
Hi Experts,
I am developing smart form for invoice.In output it is displaying amount field like this
123.44,65 instead of 123,44.65.(I.e full stop is coming in place of comma and vice versa).
please help me.
Thanks,
Santosh
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
May be you are using the some hard code . (Full stop sign) after the variable printing. SAY: &v_invamount& .
Just check and remove that dot. yr problem get resolved.
Regards,
Akg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
In order to convert the amount field we need to check first user settings . Even though the User setting value is 'X' .
The amount will not display correclt .
For this proper soultion is change the format according to country settings .
for that we need to give the syntax set country countryid.
this syntax will look into T005X if the country id is avaliable it will fetch the decimal notation provided.
if not provided you need to provide the syntax
SET COUTNRY SPACE . Here space will check the user settings and change the correct settings.
Please provide the SET COUNTRY SPACE before where you are trying to display . ie using flow logic -> program lines
or in driver program where you are trying to calculate .
I have done the same thing when i had this problem for Purchase order smartform.
Thanks
Hariharan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
just goto system in application toolbar,
navigate to user profile,
select owndata,
under defaults tab,
in decimal notification click on drop down ment and select your required format,
as you need in 12,23 format so please select X 1,234,567.89
this will solve your purpose.
regards,
koolspy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Santosh,
Give below code in a line above the text using program lines:
set country space.
Regards,
Dep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check your System User Setting
Jshree
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you are writing Curr to Curr or Curr to Char, use WRITE instead of MOVE.
If you are moving Char/String to Curr go for EDIT MASK.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi santosh_varmat19,
Check user settings - you can set your default.
In some cases the amount representation folows the country default settings of the addressee, i.e. custoner who receives the invoice.
If you do not find out, give name of smartform, node and field.
Regards
Clemens
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.