-----收运入库单
---- 重新计算不含税金额
update CT_HW_TempInWarehsBillEntry set CFExclTaxMoney= Round( CFAmount/1.06,2) where fparentid ='hdAAAABSHr2z2FIW'
----计算税额
update CT_HW_TempInWarehsBillEntry set CFTax=CFAmount- CFExclTaxMoney where fparentid ='hdAAAABSHr2z2FIW'
---处置出库单
---- 重新计算不含税金额
update CT_HW_TempIssueBillEntry set CFExclTaxMoney= Round( CFAmount/1.06,2)
----计算税额
update CT_HW_TempIssueBillEntry set CFTax=CFAmount- CFExclTaxMoney
Sqlsever 字段相乘后保留2位小数
最新推荐文章于 2023-02-10 08:38:25 发布