Print Excise Duty10% amount in words(indian standards) in A/R invoice PLD
I want to print exice duty amount in indian standard words for example
1.Excise Duty amount- Rs.1000
2.E_Cess on ED- Rs. 20
3.HSC_cess on ED- Rs. 10
For above i want to print like this
ED in words : Rupees One thousand only.
Cess : Rupees thirty only.
I have created UDF for both in A/R invoice table and i written FMS like this
SELECT dbo.AmtWords ( select T0.[TaxSum]
FROM INV4 T0 INNER JOIN OINV T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.[StaCode] = 'BED@10' and T0.[DocEntry] = $[OINV.DocNum])
but it is not working
please help me.