18721107673
18721107673
金蝶kis专业版/旗舰版/k3更新损益类的凭证
将汇兑损益类的凭证原币更新为零
当执行汇兑损益时,虽然科目挂了外币,但是外币的金额为零,只根据汇率计算人民币的金额
可以通过sql语句,将外币金额更新为零
---------------------------------
update t_VoucherEntry
set t_VoucherEntry.FAmountFor = 0.00
where t_VoucherEntry.FExplanation like '%原币为零%' and ( t_VoucherEntry.FAmountFor = 1 or t_VoucherEntry.FAmountFor = -1)
---------------------------------