入库汇总表与收发存汇总表对账不平用友软件股份有限公司张学文2010年4月在热线中遇到一问题，890，某存货做的其它入库单，同样过滤条件，在入库汇总表可以查到，在收发存汇总表中查不到？此存货已记账，为二月份记录。入库汇总表过滤条件：过滤结果为收发存汇总表条件：过滤结果为：后查看其它单据正常，其它存货也正常，难道是收发存汇总表的问题？经过跟踪发现：Select6asi,cast(INVENTORY.cInvCCodeasnvarchar(12))asGrade,casewhen(ia_subsidiary.cWhCodeisnull)thenN''elseia_subsidiary.cWhCodeendascWhCode,casewhen(ia_subsidiary.cWhCodeisnull)thenN''elsecWhNameendascWhName,IA_Subsidiary.cInvCode,cInvAddCode,cInvName,cInvStd,ComputationUnit.CComUnitName,iInvWeight,cInvDefine1,cast(sum(ISNULL(Cast(iAInQuantityasdecimal(20,2)),0)-ISNULL(Cast(iAOutQuantityasdecimal(20,2)),0))asfloat)ASQcQuantity,cast(sum(ISNULL(cast(iAInPriceasdecimal(20,2)),0)-ISNULL(Cast(iAOutPriceasdecimal(20,2)),0))asdecimal(20,2))ASQcPrice,cast(sum(isnull(Cast(iDebitDifCostasdecimal(20,2)),0)-isnull(Cast(iCreditDifCostasdecimal(20,2)),0))asdecimal(20,2))asqcDif,cast(0asfloat)asInQuantity,cast(0asdecimal(20,2))asInPrice,CAST(0asdecimal(20,2))asInDif,cast(0asfloat)asOutQuantity,cast(0asdecimal(20,2))AsOutPrice,cast(0asdecimal(20,2))asOutDifintotempdb..[InOutSumTmpUF2005023271]fromIA_Subsidiarywith(nolock)leftjoinInventorywith(nolock)onIA_Subsidiary.cInvCode=Inventory.cInvCodeleftjoinComputationUnitwith(nolock)ONinventory.cComunitCode=ComputationUnit.ccomunitcodeleftjoinwarehousewith(nolock)onia_subsidiary.cWhCode=warehouse.cwhcodeWherecVouType<>N'33'andIA_Subsidiary.cInvCode>=N'0388'AndIA_Subsidiary.cInvCode<=N'0388'AndIA_SUBSIDIARY.cWhCodein(N'05')Andisnull(Inventory.dEDate,N'9999-12-31')>'2010-02-01'andInventory.dSDate<='2010-02-28'AND(WareHouse.bInCost=1orWareHouse.cwhcodeisnull)And(imonth=0or(dKeepDate0))groupbyia_subsidiary.cWhCode,cWhName,INVENTORY.cInvCCode,IA_Subsidiary.cInvCode,cInvName,cInvStd,CComUnitName,iInvWeight,cInvAddCode,cInvDefine1having(sum(ISNULL(iAInQuantity,0)-ISNULL(iAOutQuantity,0))<>0orsum(ISNULL(iAInPrice,0)-ISNULL(iAOutPrice,0))<>0orsum(isnull(iDebitDifCost,0)-isnull(iCreditDifCost,0))<>0)查看存货档案的启用日期：根据跟踪提示发现是存货档案的启用日期的问题，所以收发存汇总表日期以2010.2.1---2010.3.1号日期过滤，可以过滤出来了．总结：1.收发存汇总表过滤条件．2.存货档案的存货启用日期小于单据记账日期．3.仓库是否计入成本，不计入成本仓库在此表中不会显示．谢谢！
