cancel
Showing results for 
Search instead for 
Did you mean: 

amount in words

former_member799304
Participant
0 Kudos

Greetings of the day.

The grand total of the invoice value in figures is ok.

but when it comes into words, if the value is above one lakh, its showing one hundred thousand and for above ten lakhs it shows one million like in UK and US.

can we change this scenario? could u be of some help with some sql query or function?

thanks and regards.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Try This

declare @Doc_total numeric (19,6)
set @Doc_total=$[ORDR.DocTotal]
select  dbo.fNumToWords (@Doc_total)

Create UDF at Titel level

Type : Alphanumeric

Structure: Text

Change Table as per your requirement.

Thanks,

Srujal Patel

former_member799304
Participant
0 Kudos

greetings from India.

well can this be created in PLD?

cause v r using PO, AP and AR invoice in PLD and not in crystal reports.

and we need to have the words in Ten Lakhs, Lakhs,

suggestions pls

thanks and regards.

former_member206488
Active Contributor
0 Kudos

Hi,

This can be done in PLD.

Create functions mentioned in thread in Sql server.

then Create User defined field on marketing document header level.

Apply below formatted search on Header level UDF created earlier on AR Invoice:

declare @Doc_total numeric (19,0) set @Doc_total=$http://OINV.DocTotal select dbo.AmountToWords (@Doc_total)

Similarly change the table name in formatted search and apply to other documents.

Select this field in PLD.

Hope this will help.

Thanks,

Neetu

Former Member
0 Kudos

Hi

For this Query you have to pick Amount in Word maximum 1 crore

For all marketing document you have to just replace table name.

Thanks

Srujal Patel

former_member799304
Participant
0 Kudos

greetings of the day.

Thanks a lot Ms. Neetu Dhami and Srujal Patel 77 for guiding us in the whole process.

we did exactly as per what u explained in detail and we were successful in getting the results.

we have one small query, if possible, can u help us.

the rupees is coming at the end. for eg. One Lakh Forty Six Thousand Seven Hundred and Seven rupees Only.

Can it possibly come in front, before One Lakh, for eg. Rupees One Lakh......

Sorry to have asked for more and troubled u, hope u all understand.

thanks and regards.

former_member799304
Participant
0 Kudos

greetings of the day.

thanks for ur support and with the local help just did the same as mentioned.

deleted the 'rupees' in the last row of ur sql query no one.

then added another text field in PLD as Rupees.

in the settings in administration deleted the INR.

and hence i could get the Rupees in front of the figure in words.

thanks and lots of regards.

Vijay Patil.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You may check:

Thanks,

Gordon