问题描述:D9单据过账提示:将 numeric 转换为数据类型 numeric 时出现算术溢出错误
问题原因:软件里面存在超大金额,超过了软件限制导致
处理方法:
如果客户本身不关心成本,执行下面的脚本处理:
update PD_GoodsStock set Price=0 where Price>=100000 OR Price<=-100000
update PD_GoodsStock set total=0 where total>=1000000 OR total<=-1000000
update PD_SellDetail set CostPrice=0 where Price>=100000 OR Price<=-100000
update PD_SellDetail set GoodsCostTotal=0 where GoodsCostTotal>=1000000 OR GoodsCostTotal<=-1000000
update PD_ListTable SET JTotal=0 WHERE (JTotal>=1000000 or DTotal<=-1000000) and FinanceID=11
update PD_ListTable SET DTotal=0 WHERE (JTotal>=1000000 or DTotal<=-1000000) and FinanceID=35
update BD_Funds set QmBalances=0 where (QmBalances>=1000000 OR QmBalances<=-1000000) and FinanceID in (11,35)