用友软件股份有限公司84号工程师--fjx库存与存货对账不平---2010-04维护案例【问题来源】热线问题【问题描述】全月平均法，业务日期为3月份。目前存货核算所有仓库已经期末处理完毕，并且已经全部制单处理，财务报表已经出了，现在进行‘库存与存货对账’，发现对账不平，相差的都是数量的小数尾差，为什么？如何调整？【参见截图】【问题分析】首先，库存和存货对的是数量。其次，看下两个模块的取数来源，参见语句如下：库存：SELECTRdRecord.cWhCode,RdRecords.cInvCode,Inventory.cInvName,Inventory.cInvStd,Str(Sum(CaseWhendDate>='2010-04-01'AnddDate<='2010-04-30'AndbRdFlag<>0AndIsNull(bIsSTQc,0)=0Thenconvert(dec(38,6),RdRecords.iQuantity)Else0End),30,4)ASiIQuantity,Str(Sum(CaseWhendDate>='2010-04-01'AnddDate<='2010-04-30'AndbRdFlag<>1AndIsNull(bIsSTQc,0)=0Thenconvert(dec(38,6),RdRecords.iQuantity)Else0End),30,4)AsiOQuantity,Str((SUM((CaseWhenIsNull(bIsSTQc,0)=1ORdDate<'2010-04-01'Then((CASEWHENbRdFlag<>0then1else-1end)*convert(dec(38,6),RdRecords.iQuantity))ELSE0END)))+(SUM(CaseWhendDate>='2010-04-01'AnddDate<='2010-04-30'AndbRdFlag<>0AndIsNull(bIsSTQc,0)=0Thenconvert(dec(38,6),RdRecords.iQuantity)Else0End))-(SUM(CaseWhendDate>='2010-04-01'AnddDate<='2010-04-30'AndbRdFlag<>1AndIsNull(bIsSTQc,0)=0Thenconvert(dec(38,6),RdRecords.iQuantity)Else0End)),30,4)ASiBQuantityINTO#qdfTotal_UFIDA_FANG_0FROMRdRecordINNERJOINRdRecordsONRdRecord.Id=RdRecords.IdINNERJOINInventoryONRdRecords.cInvCode=Inventory.cInvCodeinnerjoinwarehousewonw.cwhcode=rdrecord.cwhcodeWHERE((RdRecord.dDate<'2010-04-01'AndIsNull(RdRecord.bIsSTQc,0)=1)Or(RdRecord.dDate>='2010-04-01'AndIsNull(RdRecord.bPUFirst,0)=0AndIsNull(RdRecord.bIAFirst,0)=0AndIsNull(RdRecord.bOMFirst,0)=0And(not(RdRecord.cBusType='假退料'andRdRecord.cVouchType=11))))and(RdRecords.bCosting=1orRdRecord.bisstqc=1)andisnull(w.bproxywh,0)<>1GROUPBYRdRecord.cWhCode,RdRecords.cInvCode,Inventory.cInvName,Inventory.cInvStd存货：SELECTIA_Summary.cWhCode,IA_Summary.cInvCode,Inventory.cInvName,Inventory.cInvStd,Str(isnull(sum(IA_Summary.iINum),0),30,4)ASiIncomeQuantity,Str(isnull(sum(IA_Summary.iONum),0),30,4)ASiSentOutQuantity,Str(isnull(sum(iNum),0),30,4)ASiBeginQuantityINTO#qdfRds_UFIDA_FANG_0FROMIA_SummaryINNERJOINInventoryONIA_Summary.cInvCode=Inventory.cInvCodeLeftjoinwarehousewonw.cwhcode=IA_Summary.cwhcodeWhereiMonth=4and(w.cwhcodeisnullor(isnull(w.bproxywh,0)<>1andisnull(w.bincost,0)=1))GROUPBYIA_Summary.cWhCode,IA_Summary.cInvCode,Inventory.cInvName,Inventory.cInvStd可见，库存的数量取自rdrecords，存货核算的数量取自ia_summary。而rdrecord/s的记录是在单据保存时写入的，ia_summary的数据是在单据记账后写入的。【分析问题产生的原因】库存和存货处理数据时，数据精度不一致所致【两种处理方法】1、以存货的数量为准，调整库存的记录参见语句如下：Updaterdrecordssetiquantity=ia_subsidiary.iainquantityFromrdrecordsjoinia_subsidiaryonrdrecords.autoid=ia_subsidiary.idWhereia_subsidiary.brdflag=‘1’Updaterdrecordssetrdrecords.iquantity=ia_subsidiary.iaoutquantityFromrdrecordsjoinia_subsidiaryonrdrecords.autoid=ia_subsidiary.idWhereia_subsidiary.brdflag=‘2’2、以库存核算的数量为准，来调整存货的记录参考语句如下：updateia_subsidiarysetiainquantity=rdrecords.iquantityfromia_subsidiaryjoinrdrecordsonia_subsidiary.id=rdrecords.autoidwhereia_subsidiary.brdflag='1'updateia_subsidiarysetiainquantity=rdrecords.iquantityfromia_subsidiaryjoinrdrecordsonia_subsidiary.id=rdrecords.autoidwhereia_subsidiary.brdflag=‘0'注意：1）因为单据已经生成了凭证，且已经生成了财务报表，故需要保证存货金额前后不能有出入。故为了保证数量*单价=金额，还需要调整单价列。参见语句如下：Updateia_subsidiarysetiInCost=iainprice/iaquantityUpdateia_subsidiarysetioutCost=iaoutprice/iaquantity然后，用总账工具重算总账数据！又因为已经做了期末处理，故需要修改ia_summary.iperiod=1。参见语句如下：Updateia_summarysetiperiod=‘1’whereimonth=’03’为了避免以后月份有类似问题产生，建议客户修改数据精度设置。【补充】1）若计价方法为先进先出、后进先出、个别计价法等，除ia_subsidiary、ia_summary外，还需调整：IA_ValuationAss等。2）需考虑销售成本的核算方式谢谢大家！
