问题现象: | 存货核算模块,暂估方式:单到回冲,成本核算方法:按仓库核算,存货编码:01020050022,09号仓库,9月份采购入库,数量1220,10月份冲估价入账数量为-1220,结转材料采购数量为840,期末处理没有生成暂估单,数量应该为:380,导致出现错误。另一个存货编号为:01010039990001,仓库为04仓库,3月份暂估出现问题。客户正在审计,急着出报表,客户数据无法上传,请集团远程协助。客户方联系人:李钰,联系方式:0391-2086850、13523365081,用友软件河南分公司联系人:石俊德,联系方式:18638157678 |
问题原因: | |
解决方案: | 您好, 此问题【经查看数据/测试】现做如下分析与答复: 【问题原因】 期末处理没有生成蓝字回冲单(暂估),需要从后台插入; 【解决方案】 insert into IA_Subsidiary (bRdFlag,cBusType,cBusCode,cVouCode,ID,ValueID,JustID,dVouDate,dKeepDate,iMonth,iPZID,iPZDate,cPZtype,cPZdigest,cInvHead,cDifHead,cOppHead,cVouType,cPTCode,cSTCode,cWhCode,cAccDep,cInvCode,cRdCode,cVenCode,cCusCode,cOrderCode,cARVCode,cBillCode,cDLCode,cPSPCode,cProCode,cDepCode,cPersonCode,cHandler,iAInQuantity,iAOutQuantity,iInCost,iOutCost,iAInPrice,iAOutPrice,cBatchCode,iDebitDifCost,iCreditDifCost,cAccounter,cMaker,bFlag,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,noJustQuantity,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,cDefine11,cDefine12,cDefine13,cDefine14,cDefine15,cDefine16,cDefine28,cDefine29,cDefine30,cDefine31,cDefine32,cDefine33,cDefine34,cDefine35,cDefine36,cDefine37,psvsid,cCXHDcode,cCXFScode,cBatchia,dMadeDateia,iMassDateia,cMassUnit,dVDateia,cproordercode,iproorderid,iproorderids,cworkprocode,cworkprocodedis,cworkcentercode,cworkcentername,cendcode,csaleordercode,isaleorderid,isaleordersid,isaleorderids,centrustordercode,ientrustorderid,ientrustordersid,cpurordercode,ipurordersid,idlsid,strContractCode,inum,cAssUnit,exoCode,iExRowno,consignMentCode,iconsignmentautoid,iTrans,iLevel,BakID,iBG_Ctrl,cIMOrdercode,imaterialfee,iProcessFee,cMaterialHead,cProcessHead,cSRcVoutype,fLaborStdCostE,fManuFixStdCostE,fManuVarStdCostE,fOmCostE,cdemandcode,cdemandmemo,imaterialfeeDif,fLaborCostEffRateDif,fLaborCostRateDif,fManuFixCostEffRateDif,fManuFixCostRateDif,fManuVarCostEffRateDif,fManuVarCostRateDif,fOmCostEDif,cbMemo,msdetailsid) select bRdFlag,cBusType,cBusCode,cVouCode,ID,ValueID,JustID,dVouDate,dKeepDate,iMonth,iPZID,null,NULL,null,null,null,null,'30',cPTCode,cSTCode,cWhCode,cAccDep,cInvCode,cRdCode,cVenCode,cCusCode,cOrderCode,cARVCode,cBillCode,cDLCode,cPSPCode,cProCode,cDepCode,cPersonCode,cHandler,380,iAOutQuantity,iInCost,iOutCost,77948.7179,iAOutPrice,cBatchCode,iDebitDifCost,iCreditDifCost,cAccounter,cMaker,bFlag,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,noJustQuantity,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,cDefine11,cDefine12,cDefine13,cDefine14,cDefine15,cDefine16,cDefine28,cDefine29,cDefine30,cDefine31,cDefine32,cDefine33,cDefine34,cDefine35,cDefine36,cDefine37,psvsid,cCXHDcode,cCXFScode,cBatchia,dMadeDateia,iMassDateia,cMassUnit,dVDateia,cproordercode,iproorderid,iproorderids,cworkprocode,cworkprocodedis,cworkcentercode,cworkcentername,cendcode,csaleordercode,isaleorderid,isaleordersid,isaleorderids,centrustordercode,ientrustorderid,ientrustordersid,cpurordercode,ipurordersid,idlsid,strContractCode,inum,cAssUnit,exoCode,iExRowno,consignMentCode,iconsignmentautoid,iTrans,iLevel,BakID,iBG_Ctrl,cIMOrdercode,imaterialfee,iProcessFee,cMaterialHead,cProcessHead,cSRcVoutype,fLaborStdCostE,fManuFixStdCostE,fManuVarStdCostE,fOmCostE,cdemandcode,cdemandmemo,imaterialfeeDif,fLaborCostEffRateDif,fLaborCostRateDif,fManuFixCostEffRateDif,fManuFixCostRateDif,fManuVarCostEffRateDif,fManuVarCostRateDif,fOmCostEDif,cbMemo,msdetailsid FROM IA_SUBSIDIARY WHERE AUTOID=36112; |
相关补丁: | |
版本: | 8.90 |
模块: | 存货管理 |
产品: | 供应链 |
问题名称: | 存货核算期末处理暂估不能自动回冲 |
最后更新: | 2011-12-16 23:32:53 |