Delete Autocount Tin tax number

This is an old revision of the document!


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;

autocount_accounting/deleteautocounttintaxnumber.1743742743.txt.gz · Last modified: 2025/04/04 04:59
CC Attribution-Share Alike 4.0 International Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International