问题现象: | 查询应收发票列表本币余额与应收核销明细帐中的余额不一致,发票列表还与单据核销中的余额不一致。查询后发现是salebillvouchs表中的iMoneySum ,iExchSum字段上下年不一致造成。举例客户编码1110109,400001,还有其他客户余额不一致问题,希望集团同事能找出问题原因,并帮忙全部解决。谢谢! 数据已经上传到ftp 名字为:壳牌 |
问题原因: | |
解决方案: | 您好, 此问题【经查看数据/测试】现做如下分析与答复: 这些发票都是以前年度的,结转过来累计核销金额就不对,现在也重现不了问题,没法找原因, 先执行下面的脚本调整对了,让用户打上最新补丁,看看以后还会不会出现这类问题 update salebillvouchs set iexchsum=isum-iamount_f,imoneysum=inatsum-iamount from salebillvouchs a inner join (select ibvid,sum(idamount_f-icamount_f) as iamount_f,sum(idamount-icamount) as iamount from ap_detail where ccovouchtype like '2%' and iflag<3 group by ibvid) b on a.autoid=b.ibvid update purbillvouchs set ioritotal=iorisum-iamount_f,itotal=isum-iamount from purbillvouchs a inner join (select ibvid,sum(icamount_f-idamount_f) as iamount_f,sum(icamount-idamount) as iamount from ap_detail where ccovouchtype like '0%' and iflag<3 group by ibvid) b on a.id=b.ibvid 如有问题,敬请及时邮件联系,无需反馈问题! |
相关补丁: | |
版本: | 8.90 |
模块: | 应收应付 |
产品: | 财务会计 |
问题名称: | 壳牌--发票与核销后余额不一致 |
最后更新: | 2011-08-24 16:46:53 |