====Delete Autocount Tin tax number==== update ARInvoice set TaxEntityID=null \\ update APInvoice set TaxEntityID=null \\ update IV set TaxEntityID=null \\ update TaxTransAuditDTL set TaxEntityID=null \\ update GR set TaxEntityID=null \\ update ARCN set TaxEntityID=null \\ update QT set TaxEntityID=null \\ update ARDN set TaxEntityID=null \\ update PO set TaxEntityID=null \\ update PI set TaxEntityID=null \\ update TaxTrans set TaxEntityID=null \\ update JEDTL set TaxEntityID=null \\ update Debtor set TaxEntityID = null where tin = update Creditor set TaxEntityID = null \\ update CB set TaxEntityID=null \\ update SO set TaxEntityID=null \\ update XS set TaxEntityID=null \\ update CN set TaxEntityID=null \\ update APCN set TaxEntityID = null \\ update PR set TaxEntityID = null \\ update XP set TaxEntityID = null \\ update RQ set TaxEntityID = null \\ update GT set TaxEntityID = null \\ UPDATE [dbo].[ConsignmentReturn] SET taxEntityID = NULL; \\ UPDATE [dbo].[PurchaseConsignment] SET taxEntityID = NULL; \\ UPDATE [dbo].[PurchaseConsignmentReturn] SET taxEntityID = NULL; \\ UPDATE [dbo].PaymentMethod SET BankChargeTaxEntityID = NULL;