EAS销售出库单与销售订单税率不同步问题修复
eas销售出库单与销售订单税率不同步问题修复,如果销售出库单的税率错了,可以从销售订单带价格和税率过来重新计算一遍,特别是有港澳台组织的,可能会遇到这个问题
--eas销售出库单税率修复 update t_im_saleissueentry t set (t.fsaleprice, t.FActualPrice, t.ftaxprice, t.ftaxrate, t.fprice, t.ftax, t.flocaltax, t.flocalamount, t.famount, t.flocalprice) = (select x.fprice, nvl(x.fprice, 0), x.ftaxprice, x.ftaxrate, x.ftaxprice, x.fqty * (x.ftaxprice - x.fprice), t.fqty * (x.ftaxprice - x.fprice), x.ftaxprice * t.fqty, x.ftaxprice * t.fqty, x.fprice from t_sd_saleorderentry x where x.fparentid = t.fsourcebillid and x.fmaterialid = t.fmaterialid and x.fid = t.fsourcebillentryid and x.fseq = t.fsourcebillentryseq) where t.fparentid in (select xx.fid from t_im_saleissuebill xx where xx.fnumber in ('xxxx')) ) and t.fispresent = 0;
EAS销售出库单与销售订单税率不同步问题修复
eas销售出库单与销售订单税率不同步问题修复,如果销售出库单的税率错了,可以从销售订单带价格和税率过来重新计算一遍,特别是有港澳台组...
点击下载文档
本文2024-09-16 22:38:16发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-49391.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章