菜单

导入博浩附加税,不含税的设置

27/03/2018 - TPV, 疑难杂症

1.导出客户资料到excel

2.不含税列*100 + 附加税列 ,复制结果到新列,放到o列更新到备注。

3.执行以下sql语句

update [Customers] set
[TaxType]=case when cast(remark as varchar(4))=’-100′ then 4 else 2 end
,[AttachTax] =case when cast(remark as varchar(4))=’-1′ then 1 else 0 end
where remark is not null