Skip to Content
0
Jul 22, 2020 at 08:25 AM

Stored Procedure Required for to Block Duplicate vendor creation based on the GST No & PAN Matched

289 Views

Dear All

Stored Procedure Required for to Block Duplicate vendor creation based on the

T1.[GSTRegnNo] and T2.[TaxId0] matches ,

Kindly help to over come the issuse

Thanks for advance Help

SELECT T0.[CardCode], T1.[GSTRegnNo], T2.[TaxId0]
FROM OCRD T0 INNER JOIN
CRD1 T1 ON T0.[CardCode] = T1.[CardCode] INNER JOIN CRD7 T2 ON T0.[CardCode] = T2.[CardCode]