Can anyone help me in changing the format of “Amount In Words” Field.
For me Rs. 21,000.00 got as “TWENTY ONE THOUSAND RUPEES AND ZERO PAISA ONLY”
but i want this one as Rs. 21,000/ and amount in word as “Twenty one thousand rupees and zero paisa only”
thanks in advance
Is the difference CAPS letters only?
Please help getting the solution for this.
I want “Amount In Words” as small letters. Only first letter in caps.
Thanks in advance…
first create four text variables, for example: txt1,txt2,txt3,txt4
write this code;
txt1:=LOWERCASE(string); //string is the TWENTY ONE THO…
txt2:=COPYSTR(txt1,1); //spliting the first letter
txt3:=COPYSTR(txt1,2,50) //spliting the remaining text
then whenever you want to use u can simply specify “(txt4+txt3)”
The wording is done by the FormatNoText function in Report 1401 (Check) and the words are stored in TextConstants. Have a look at these TextConstants Report 1401 and see that these are all in caps.
To get lower capitals you could either:
- changes the ConstValue of each TextConstatnt to lower caps (make sure you do that for the language you are working with) OR
- convert the content of the parameter NoText, before the function FormatNoText ends, so that it holds only lower caps, i.e. NoText := LOWERCASE(NoText)
I prefer the second option. The only thing you have to deal with is to have the first character in NoText in uppercase, for now I leave that to you to solve that.
Update: Amol was just a little ahead of my [Y]