on 02-01-2008 8:02 AM
hi friends,
i am using rlb_invoice(program) and lb_bil_invoice(form) for printing the billing information in message type rd00
when i am checking the print preview , amount is printing like 61.6545,00 rather than 61,6545.00
what i mean to say is comma(,) and decimal dot(.) are interchanged in the postions
how can we change these formats?
thanks in advance
srinivas
The tips given by other pals may not resolve your problem. I had to do for one of my develpment . What I did is?
copy that fields into a character string of smae length ( I mean including commas and points for reference see the output lenght) say that field as v_amount
Just check the below logic
data:v_amount type char19,(Say output lenght is 19characters)
v_amount type char3 (say decimals have 3characters)
v_amount type char15 (Before decimal its has 15 characters length)
say v_amount has value 61.6545,000
split v_amount at ',' into v_amount1
v_amount2.
now v_amount1 = 61.6545
and v_amount2 = .000
replace v_amount1 with all occurances of '.'.
now v_amount1 = 61,6545
now concatenate into another variable
concatenate v_amount1 '.' v_amount2 into v_amount3.
now v_amount v_amount will have your required value.
now move this value to your quantity field or you can print it directly.
Reward points if useful.
Regards,
Nageswar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In your Session Go to Menu list..
Select Session --> User Profile --> Own data
In the coming screen Goto Default Values Tab.
There you can select the Decimal format in whichever way u want !!
After saving the setting just log out once and then log in !!
The changes would be reflected in the output.
Regards
Sai Ramesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
try to search on Forum u will find solution , similar question has solved earlier.
regards
sachin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
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.