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

[Former Member]

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]

Hi Sridharan.R ,

For this you have to create UDF For Excise, Cess & SHE &

Try This Query

declare @Doc_total numeric (19,6)

set @Doc_total=$[OPOR.DocTotal]

select dbo.fNumToWords (@Doc_total)

Update query as per your requirment,

Thanks

Srujal Patel

[former_member206488]

Hi,

Did you created AmtWords function in SQL.

IF not, check thread.

Thanks,

Neetu

[Former Member]

Dear Neetu,

I done amtword sql function. is it possible to print Excise duty in indian standards.

thank u

sridharan.r

[former_member206488]

Create User defined field to get ampunt in words. Check the thread I mentioned in above reply for formatted search to get amt in words.

[former_member1269712]

Hi Sridharan,

In PLD there is bit difficult your requirement, but yes in crystal report you can do it easily so try crystal for A/R Invoice layout report.

Regards,

Sachin