有问题文章留言 看内容决定收费与免费
另外接收数据库质疑 勒索病毒数据恢复等项目。

医药之星10怎么批量修改税率?

【问题描述】

医药之星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 ='品牌编码'



赞(4)
未经允许不得转载:思迅软件知识库 » 医药之星10怎么批量修改税率?
分享到: 更多 (0)

评论 3

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址
  1. #1

    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

    Emerson1个月前 (07-05)回复
  2. #2

    Very interesting details you have observed, thank you for putting up.!

    DanieleO1个月前 (07-07)回复
  3. #3

    Very interesting info!Perfect just what I was searching for!
    Euro travel