Format of Amount In Words

Hi,

Can anyone help me in changing the format of “Amount In Words” Field.

Example.

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?

Yes.

Hi mohana,

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

then

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

txt4:= UPPERCASE(txt2);

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:

  1. changes the ConstValue of each TextConstatnt to lower caps (make sure you do that for the language you are working with) OR
  2. 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]