1.第一步:查找组合拆分单中父商品数量为0的情况或者数量为小数的组合拆分单
select * from bi_t_item_unitbom where mult_bnum =0 or mult_bnum<1 or mult_num=0 or mult_num<1
2.第二步:检查,组合拆分单的有没有商品数量是有小数的;
select * from bi_t_item_unitbom order by mult_num
3.第三步:检查是否存在商品拆分父子组合为1:1的商品拆分单
select * from bi_t_item_unitbom where combsplit_type='U' and mult_num=1
4.第四步:看下销售流水数据里面的销售数量有没有是负数的,有的话修改为正确数值。
select * from pos_t_saleflow where sale_qnty<0
5.第五步:看下库存商品有没有是负数的,是的话就通过盘点等方式恢复库存为正常。
select * from ic_t_branch_stock where item_no in (select itemno_sunit from bi_t_item_unitbom ) and stock_qty<0 order by stock_qty
6.日结操作:
exec pr_jxc_daysum_amt '20170311','20170313'
解决方法:日结报错:3607:发生以0作除数错误
1.先删除这个组合拆分单
delete from bi_t_item_unitbom where sheet_no='CS001704090259'
2.然后删除ic_t_flow中组合拆分单做错的导致的数据
delete from ic_t_flow where voucher_no='CS001704090259' or memo='CS001704090259'
3.日结
exec pr_jxc_daysum_amt '20170413','20170414'