on 06-07-2011 6:34 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.