问题现象: | 发货统计表结转之后和上年数据不符,现在已经查出的存货有0204004-0070和0211016-0179,年转之后可能缺少记录,但是也有可能还有其他存货有此问题,希望集团老师帮助彻底排查一下,并请教一下出现此情况的原因是否是退货没有开票所致。另外还有问题是存货模块中有结存数量为负的存货,属于历史遗留问题,我建议客户以库存数量为准加上未开票数量手工调整,但是客户不认可,希望可以有脚本彻查这种情况,最好可以代为调整,请老师帮忙出一个好办法说服客户,谢谢!提交问题已经上传三国—天津分公司-890.rar |
问题原因: | |
解决方案: | 您好, 此问题【经查看数据/测试】现做如下分析与答复: 有四张退货单没有结转到下年 FJTH1101,CDTH1124,SH201107,CDTH0719 890已有年结补丁,可以请将此四张单据手工结到下年,打上其初标志,如果对应发货没有,可以清除关联关系 参考语句: insert into UFDATA_007_2012..dispatchlist (DLID, cDLCode, cVouchType, cSTCode, dDate, cRdCode, cDepCode, cPersonCode, SBVID, cSBVCode, cSOCode, cCusCode, cPayCode, cSCCode, cShipAddress, cexch_name, iExchRate, iTaxRate, bFirst, bReturnFlag, bSettleAll, cMemo, cSaleOut, cDefine1, cDefine2, cDefine3, cDefine4, cDefine5, cDefine6, cDefine7, cDefine8, cDefine9, cDefine10, cVerifier, cMaker, iNetLock, iSale, cCusName, iVTid, cBusType, cCloser, cAccounter, cCreChpName, cDefine11, cDefine12, cDefine13, cDefine14, cDefine15, cDefine16, bIAFirst, ioutgolden, cgatheringplan, dCreditStart, dGatheringDate, icreditdays, bCredit, caddcode, iverifystate, ireturncount, iswfcontrolled, icreditstate, bARFirst, cmodifier, dmoddate, dverifydate, ccusperson, dcreatesystime, dverifysystime, dmodifysystime, csvouchtype, iflowid, bsigncreate, bcashsale, cgathingcode, cChanger, cChangeMemo, outid) select DLID, cDLCode, cVouchType, cSTCode, dDate, cRdCode, cDepCode, cPersonCode, SBVID, cSBVCode, cSOCode, cCusCode, cPayCode, cSCCode, cShipAddress, cexch_name, iExchRate, iTaxRate, 1, bReturnFlag, bSettleAll, cMemo, cSaleOut, cDefine1, cDefine2, cDefine3, cDefine4, cDefine5, cDefine6, cDefine7, cDefine8, cDefine9, cDefine10, cVerifier, cMaker, iNetLock, iSale, cCusName, iVTid, cBusType, cCloser, cAccounter, cCreChpName, cDefine11, cDefine12, cDefine13, cDefine14, cDefine15, cDefine16, bIAFirst, ioutgolden, cgatheringplan, dCreditStart, dGatheringDate, icreditdays, bCredit, caddcode, iverifystate, ireturncount, iswfcontrolled, icreditstate, bARFirst, cmodifier, dmoddate, dverifydate, ccusperson, dcreatesystime, dverifysystime, dmodifysystime, csvouchtype, iflowid, bsigncreate, bcashsale, cgathingcode, cChanger, cChangeMemo, outid from UFDATA_007_2011..dispatchlist where cdlcode in ('FJTH1101','CDTH1124','SH201107','CDTH0719') insert into UFDATA_007_2012..dispatchlists ( DLID, iCorID, cWhCode, cInvCode, iQuantity, iNum, iQuotedPrice, iUnitPrice, iTaxUnitPrice, iMoney, iTax, iSum, iDisCount, iNatUnitPrice, iNatMoney, iNatTax, iNatSum, iNatDisCount, iSettleNum, iSettleQuantity, iBatch, cBatch, bSettleAll, cMemo, cFree1, cFree2, iTB, dvDate, TBQuantity, TBNum, iSOsID, iDLsID, KL, KL2, cInvName, iTaxRate, cDefine22, cDefine23, cDefine24, cDefine25, cDefine26, cDefine27, fOutQuantity, fOutNum, cItemCode, cItem_class, fSaleCost, fSalePrice, cVenAbbName, cItemName, cItem_CName, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10, bIsSTQc, iInvExchRate, cUnitID, cCode, iRetQuantity, fEnSettleQuan, fEnSettleSum, iSettlePrice, cDefine28, cDefine29, cDefine30, cDefine31, cDefine32, cDefine33, cDefine34, cDefine35, cDefine36, cDefine37, dMDate, bGsp, cGspState, cSoCode, cCorCode, iPPartSeqID, iPPartID, iPPartQty, cContractID, cContractTagCode, cContractRowGuid, iMassDate, cMassUnit, bQANeedCheck, bQAUrgency, bQAChecking, bQAChecked, iQAQuantity, iQANum, cCusInvCode, cCusInvName, fsumsignquantity, fsumsignnum, cbaccounter, bcosting, cordercode, iorderrowno, fcusminprice, icostquantity, icostsum, ispecialtype, cvmivencode, iexchsum, imoneysum, irowno, frettbquantity, fretsum, iExpiratDateCalcu, dExpirationdate, cExpirationdate, cbatchproperty1, cbatchproperty2, cbatchproperty3, cbatchproperty4, cbatchproperty5, cbatchproperty6, cbatchproperty7, cbatchproperty8, cbatchproperty9, cbatchproperty10, dblPreExchMomey, dblPreMomey, idemandtype, cdemandcode, cdemandmemo, cdemandid, idemandseq, cvencode, cReasonCode, cInvSN, iInvSNCount, bneedsign, bsignover, bneedloss, flossrate, frlossqty, fulossqty, isettletype, crelacuscode, cLossMaker, dLossDate, dLossTime, icoridlsid, fretoutqty, body_outid, cPosition) select DLID, iCorID, cWhCode, cInvCode, iQuantity, iNum, iQuotedPrice, iUnitPrice, iTaxUnitPrice, iMoney, iTax, iSum, iDisCount, iNatUnitPrice, iNatMoney, iNatTax, iNatSum, iNatDisCount, iSettleNum, iSettleQuantity, iBatch, cBatch, bSettleAll, cMemo, cFree1, cFree2, iTB, dvDate, TBQuantity, TBNum, iSOsID, iDLsID, KL, KL2, cInvName, iTaxRate, cDefine22, cDefine23, cDefine24, cDefine25, cDefine26, cDefine27, fOutQuantity, fOutNum, cItemCode, cItem_class, fSaleCost, fSalePrice, cVenAbbName, cItemName, cItem_CName, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10, bIsSTQc, iInvExchRate, cUnitID, cCode, iRetQuantity, fEnSettleQuan, fEnSettleSum, iSettlePrice, cDefine28, cDefine29, cDefine30, cDefine31, cDefine32, cDefine33, cDefine34, cDefine35, cDefine36, cDefine37, dMDate, bGsp, cGspState, cSoCode, cCorCode, iPPartSeqID, iPPartID, iPPartQty, cContractID, cContractTagCode, cContractRowGuid, iMassDate, cMassUnit, bQANeedCheck, bQAUrgency, bQAChecking, bQAChecked, iQAQuantity, iQANum, cCusInvCode, cCusInvName, fsumsignquantity, fsumsignnum, cbaccounter, bcosting, cordercode, iorderrowno, fcusminprice, icostquantity, icostsum, ispecialtype, cvmivencode, iexchsum, imoneysum, irowno, frettbquantity, fretsum, iExpiratDateCalcu, dExpirationdate, cExpirationdate, cbatchproperty1, cbatchproperty2, cbatchproperty3, cbatchproperty4, cbatchproperty5, cbatchproperty6, cbatchproperty7, cbatchproperty8, cbatchproperty9, cbatchproperty10, dblPreExchMomey, dblPreMomey, idemandtype, cdemandcode, cdemandmemo, cdemandid, idemandseq, cvencode, cReasonCode, cInvSN, iInvSNCount, bneedsign, bsignover, bneedloss, flossrate, frlossqty, fulossqty, isettletype, crelacuscode, cLossMaker, dLossDate, dLossTime, icoridlsid, fretoutqty, body_outid, cPosition from UFDATA_007_2011..dispatchlists where dlid in (select dlid from UFDATA_007_2011..dispatchlist where cdlcode in ('FJTH1101','CDTH1124','SH201107','CDTH0719')) update b set b.icorid=null from UFDATA_007_2012..dispatchlist a join UFDATA_007_2012..dispatchlists b on a.dlid=b.dlid where a.dlid=25826 and icorid not in (select idlsid from UFDATA_007_2012..dispatchlists) 【注意事项】修改前请务必做好数据备份;由于网站的关系,上述语句中的标点符号 ‘ % + 必需在输入法为英文的状态下重新录入后再执行 |
相关补丁: | |
版本: | 8.90 |
模块: | 销售管理 |
产品: | 供应链 |
问题名称: | 发货统计表期初数据与上年不符和存货数量为负问题 |
最后更新: | 2012-02-20 23:25:07 |