年度结转至存货失败-用友U8

对应版本:用友U8.51A对应产品线：公共平台对应模块：系统管理模块问题现象:年度结转至存货失败问题原因：同解决方案解决方案：存货结转失败，是由于数据本身的问题。先进先出算法的辅助记价表中，出现入库金额和出库金额同时为空的记录，需要修正，脚本如下：--1.可用如下语句检查：SELECTcount(*)FROM(IA_valuationassleftjoin(select*fromia_subsidiarywhere(isnull(iainquantity,0)-isnull(iaoutquantity,0))>0)IA_SubTabonIA_SubTab.id=IA_valuationass.inidleftjoinwarehouseonIA_SubTab.cwhcode=warehouse.cwhcode)WHEREIA_valuationass.dikeepdate=IA_SubTab.dkeepdateand(Warehouse.cWhvaluestyle=’先进先出法’orWarehouse.cWhvaluestyle=’后进先出法’)And(IA_SubTab.iMonth>0or(IA_SubTab.iMonth=0andIA_SubTab.cVouType=’34’))andIA_valuationass.cinvcode=IA_SubTab.cinvcodeand(IA_valuationass.dIKeepDateisnullOrIA_valuationass.dOKeepDateisnull)andioPriceisnullandiiPriceisnull--2.根据明细账，更新错误记录updateia_valuationassSetiIprice=iIquantity*Isnull(iinCost,ioutcost)fromia_valuationassleftjoinia_subsidiaryonia_valuationass.inid=ia_subsidiary.idandia_valuationass.cinvcode=ia_subsidiary.cinvcodeWhereiIpriceisnullupdateia_valuationassSetiOPrice=iOquantity*Isnull(iinCost,ioutcost)fromia_valuationassleftjoinia_subsidiaryonia_valuationass.Outid=ia_subsidiary.idandia_valuationass.cinvcode=ia_subsidiary.cinvcodeWhereiOPriceisnull

本文链接：http://www.bbsufida.com/u8/44963.html