问题现象: | 1)1月份结转发现发出商品和总帐不平,结转前是对的,库存和存货是对的,差异见excel表格 2)发出商品2011年和2012年都和销售未开票数量对不上,2011年初将核算成本方式由销售发票改为了销售出库单 |
问题原因: | |
解决方案: | 您好,已就该问题与一线温先生电话再次沟通,此问题【再次经查看数据】现做如下分析与答复: 【问题原因】 经过检查用户数据发现在发出商品明细帐中存在重复记录(包括发货单记录与发票记录均有该现象)导致,建议先做好数据备份后将用户数据引入到测试帐套中,将2012年清空年度数据后,在2011年执行如下脚本后重新做2012年年结后如附件截图,在用户帐套库中将2012年发出商品明细帐IA_EnSubsidiary表中imonth=0的记录删除,再将新帐套库中2012年发出商品明细帐IA_EnSubsidiary表中的记录拷贝或插入到用户帐套库中做进一步的测试。我处将结转过去的期初结存数据与所发差异表对比,全部正确。 【解决方案】 --删除上年重复记账的记录(相同记录重复的数大于2条),注意替换相应的帐套号! 执行脚本前请做好数据备份!!! delete from ufdata_186_2011..ia_ensubsidiary where brdflag=1 and iainprice is null and inid in(select InID from ufdata_186_2011..ia_ensubsidiary where brdflag=1 group by inid--,cinvcode having count(inid)>1) if exists(select * from sysobjects where name='fccf') drop table fccf if exists(select * from sysobjects where name='sz') drop table sz select * into fccf from ufdata_186_2011..ia_ensubsidiary where brdflag=0 and iaoutprice is not null and inid in( select inID from ufdata_186_2011..ia_ensubsidiary where brdflag=0 group by inid,cinvcode having count(inid)>1) delete from ufdata_186_2011..ia_ensubsidiary where brdflag=0 and iaoutprice is not null and inid in( select inID from ufdata_186_2011..ia_ensubsidiary where brdflag=0 group by inid,cinvcode having count(inid)>1) and autoid not in(select max(autoid) from fccf group by inid) select inid,sum(iainquantity)iainquantity,sum(iainprice)iainprice,sum(iaoutquantity)iaoutquantity,sum(iaoutprice)iaoutprice into sz from ia_ensubsidiary group by inid having (sum(isnull(iainquantity,0))<>sum(isnull(iaoutquantity,0)) or sum(isnull(iainprice,0))<>sum(isnull(iaoutprice,0))) and (sum(isnull(iaoutquantity,0))<>0) update ia_ensubsidiary set ioutcost=enfh.iainprice/iaoutquantity,iaoutprice=enfh.iainprice from ia_ensubsidiary join (select inid,cInvCode,iAInQuantity,iainprice from ia_ensubsidiary where InID in(select InID from sz) and bRdFlag=1 )enfh on ia_ensubsidiary.InID=enfh.inid and ia_ensubsidiary.cInvCode=enfh.cinvcode and enfh.iAInQuantity=ia_ensubsidiary.iaoutquantity where ia_ensubsidiary.InID in(select InID from sz) and bRdFlag=0 --查询脚本,返回为 空 即是正常 select inid,sum(iainquantity)iainquantity,sum(iainprice)iainprice,sum(iaoutquantity)iaoutquantity,sum(iaoutprice)iaoutprice from ia_ensubsidiary group by inid having( (sum(isnull(iainquantity,0))<>sum(isnull(iaoutquantity,0)) or sum(isnull(iainprice,0))<>sum(isnull(iaoutprice,0))) and (sum(isnull(iaoutquantity,0))<>0) ) 【注意事项】修改前请务必做好数据备份;可在测试环境下先行引入用户数据后打补丁测试验证 |
相关补丁: | |
版本: | 8.90 |
模块: | 存货管理 |
产品: | 供应链 |
问题名称: | 发出商品和销售不平麻烦转史忠老师 |
最后更新: | 2012-02-15 16:39:49 |