Need help of query

[Former Member]

Hi experts,

I need vendors tax information like tin no, service tax no, pan no, cst no in the user query report, Please do needful,

Thanks

J.vigneshwaran

[Former Member · Accepted solution]

Hi Vignesg,

Try By using below query:

SELECT T0.[CardCode], T0.[CardName], T1.[TaxId0] as 'PAN No.' , T1.[TaxId1] as 'CST No', T1.[TaxId2] as 'VAT No', T1.[TaxId3] as 'SERVICE TAX No', T1.[TaxId6] as 'TAN No', T1.[TaxId11] as 'TIN No' FROM OCRD T0 INNER JOIN CRD7 T1 ON T0.[CardCode] = T1.[CardCode] WHERE T1.[CardCode] = [%0]

Regards,

Bhushan Verma

[Former Member]

Hi sir,

Thanks for both.

[kothandaraman_nagarajan]

Hi,

Please assign correct answer to Bhushan Verma and assign helpful answer to me.

Thanks.

[Former Member]

Thank you Nagarajan, and Thank you Vignesg.

Regards,

Bhushan Verma

[kothandaraman_nagarajan]

Hi,

Small change in above query:

SELECT T0.[CardCode], T0.[CardName], T1.[TaxId0] as 'PAN No.' , T1.[TaxId1] as 'CST No', T1.[TaxId2] as 'VAT No', T1.[TaxId3] as 'SERVICE TAX No', T1.[TaxId6] as 'TAN No', T1.[TaxId11] as 'TIN No'

FROM OCRD T0 INNER JOIN CRD7 T1 ON T0.[CardCode] = T1.[CardCode]

WHERE T0.[CardCode] = [%0]

Thanks.