【问题描述】
医药之星10怎么批量修改税率?
【问题答案】
上述情况软件中暂无直接功能批量调整商品进项税和销项税,可通过以下语句按类别或品牌进行调整。
–备份表
select * into t_bd_item_info_bak20220419 from t_bd_item_info
—按类别修改商品purchase_tax 进项税 sale_tax 销项税
UPDATE t_bd_item_info SET purchase_tax = 0.17, sale_tax = 0.17 where item_clsno='类别编码'
—按品牌修改商品purchase_tax 进项税 sale_tax 销项税
UPDATE t_bd_item_info SET purchase_tax = 0.17, sale_tax = 0.17 where item_brand ='品牌编码'
Awsome post and right to the point. I don’t know if this is in fact the best place to ask but
do you folks have any thoughts on where to hire some professional writers?
Thank you 🙂 Escape room lista
Very interesting details you have observed, thank you for putting up.!
Very interesting info!Perfect just what I was searching for!
Euro travel