Removing sales tax overrides from customer records


This article outlines how to remove sales tax overrides from multiple customer records through a bulk operation in the database.



Execute the following queries on the database:

  1. Backup the records to be updated by executing the following SQL query:
    select c.cust_code,, list_name, c.billcode, a.addr_code, a.custchar8, a.custchar9
    into zd2266225_addr
    from cust c inner join address a on c.BILLCODE = a.addr_code and c.cust_code = a.CUST_CODE
    inner join zd2266225_list x on c.cust_code = x.cust_code
  2. Execute the following update statement to remove the sales tax overrides and commit the changes:
    begin transaction
    update address set custchar8 = null, custchar9 = null from zd2266225_addr x
    where address.addr_code = x.ADDR_CODE
    and address.CUST_CODE= x.CUST_CODE and x.custchar8 = ADDRESS.custchar8 and x.custchar9 = address.custchar9
    commit transaction


The updated customer records should have the sales tax overrides removed.

Back to top



Please sign in to leave a comment.