Description |
Ran this query and found the following customers did not have special taxing setup
select distinct(ptpdv_cus_no) from ptpdvmst
left outer join tblARCustomer on ptpdvmst.ptpdv_cus_no collate Latin1_General_CI_AS = tblARCustomer.strCustomerNumber
left outer join tblARCustomerTaxingTaxException on tblARCustomerTaxingTaxException.intEntityCustomerId = tblARCustomer.intEntityId
where ptpdv_cus_no collate Latin1_General_CI_AS not in (select strCustomerNumber from tblARCustomer
join tblARCustomerTaxingTaxException on tblARCustomerTaxingTaxException.intEntityCustomerId = tblARCustomer.intEntityId)
|