Differences

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

--- autocount_accounting:deleteautocounttintaxnumber [2025/04/04 04:57] – 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 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;