Differences

This shows you the differences between two versions of the page.

--- autocount_accounting:deleteautocounttintaxnumber [2025/04/04 04:56] – created support
+++ autocount_accounting:deleteautocounttintaxnumber [2025/04/04 07:25] (current) – support
@@ Line 1: / Line 1: @@
 ====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;