提示：“发货单未记帐”，而相应的发货单已经记帐-用友U8

对应版本:用友U8.52对应产品线：供应链对应模块：存货核算模块问题现象:852存货核算中，日常操作－>发出商品记帐:有几张发出商品结算单生成的销售发票无法记帐，提示：“发货单未记帐”，而相应的发货单已经记帐问题原因：由于结转过程中，发出商品明细账(IA_EnSubsidiary)中，丢失掉了一些数据，即与发票关联的期初发货单。解决方案：1.保留用户的数据，重新结转一个新的账套。用来获得正确的数据；2.将正确的数据，插入用户现在的账套中，具体脚本可参考如下(ufdata_300_2005是重新结转的正确账套)：--选择未被结转的数据，注意autoid字段未被选中，因为它是自增长字段SELECT[bRdFlag],[cBusType],[cBusCode],[cVouCode],[InID],[OutID],[dVouDate],[dKeepDate],[iMonth],[iPZID],[iPZDate],[cPZtype],[cPZdigest],[cOutHead],[cOppHead],[cVouType],[cSTCode],[cWhCode],[cAccDep],[cInvCode],[cRdCode],[cCusCode],[cBillCode],[cDLCode],[cDepCode],[cPersonCode],[cHandler],[iAInQuantity],[iAOutQuantity],[iInCost],[iOutCost],[iAInPrice],[isoutquantity],[isoutmoney],[iAOutPrice],[cBatchCode],[cAccounter],[cMaker],[bMoneyFlag],[bSale],[cMemo],[cDefine1],[cDefine2],[cDefine3],[cDefine4],[cDefine5],[cDefine6],[cDefine7],[cDefine8],[cDefine9],[cDefine10],[cFree1],[cFree2],[cPZID],[cDefine22],[cDefine23],[cDefine24],[cDefine25],[cDefine26],[cDefine27],[cItem_class],[cItemCode],[cName],[cItemCName],[cFree3],[cFree4],[cFree5],[cFree6],[cFree7],[cFree8],[cFree9],[cFree10],[cDefine11],[cDefine12],[cDefine13],[cDefine14],[cDefine15],[cDefine16],[cDefine28],[cDefine29],[cDefine30],[cDefine31],[cDefine32],[cDefine33],[cDefine34],[cDefine35],[cDefine36],[cDefine37],[iEnID]intoTempaaaFROM[UFDATA_300_2005].[dbo].[IA_EnSubsidiary]where(IA_EnSubsidiary.cBusType=’委托代销’OrIA_EnSubsidiary.cBusType=’委托’)ANDiMonth=0andinidnotin(selectinidfromufdata_200_2005..IA_EnSubsidiaryWhere(cBusType=’委托代销’OrcBusType=’委托’)ANDiMonth=0)--插入上一步中临时表的数据到用户账套INSERTINTO[UFDATA_200_2005].[dbo].[IA_EnSubsidiary]([bRdFlag],[cBusType],[cBusCode],[cVouCode],[InID],[OutID],[dVouDate],[dKeepDate],[iMonth],[iPZID],[iPZDate],[cPZtype],[cPZdigest],[cOutHead],[cOppHead],[cVouType],[cSTCode],[cWhCode],[cAccDep],[cInvCode],[cRdCode],[cCusCode],[cBillCode],[cDLCode],[cDepCode],[cPersonCode],[cHandler],[iAInQuantity],[iAOutQuantity],[iInCost],[iOutCost],[iAInPrice],[isoutquantity],[isoutmoney],[iAOutPrice],[cBatchCode],[cAccounter],[cMaker],[bMoneyFlag],[bSale],[cMemo],[cDefine1],[cDefine2],[cDefine3],[cDefine4],[cDefine5],[cDefine6],[cDefine7],[cDefine8],[cDefine9],[cDefine10],[cFree1],[cFree2],[cPZID],[cDefine22],[cDefine23],[cDefine24],[cDefine25],[cDefine26],[cDefine27],[cItem_class],[cItemCode],[cName],[cItemCName],[cFree3],[cFree4],[cFree5],[cFree6],[cFree7],[cFree8],[cFree9],[cFree10],[cDefine11],[cDefine12],[cDefine13],[cDefine14],[cDefine15],[cDefine16],[cDefine28],[cDefine29],[cDefine30],[cDefine31],[cDefine32],[cDefine33],[cDefine34],[cDefine35],[cDefine36],[cDefine37],[iEnID])select*fromtempaaa--删除临时表droptabletempaaa

本文链接：https://www.bbsufida.com/u8/42422.html