Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Print Excise Duty10% amount in words(indian standards) in A/R invoice PLD

Dear Expert,

I want to print exice duty amount in indian standard words for example

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.

thank you

sridharan.

Former Member
Not what you were looking for? View more on this topic or Ask a question