存货核算现存量出错问题
技术咨询，有偿服务！
复制微信号
原因分析：现存量出错
问题解答：请首先进行整理现存量的操作，如果不行，请使用以下语句，但前提是要保证明细帐是对的。/*********************************************************功 能：整理现存量，条件是当现存量不正确而明细账正确时执行整 理：赵政时 间：2005-5-25**********************************************************/if exists (select * from tempdb..sysobjects where type='u' and name='forcurrentsyz')drop table tempdb..forcurrentsyzgoselect a.cwhcode,a.cinvcode,sum(iquantity) as iquantity, sum(a.iquantity/Inventory.iInvExchRate) as inuminto tempdb..forcurrentsyz from (select cwhcode,cinvcode,iaInquantity as iquantity from ia_subsidiary where cvoutype='34'union allselect cwhcode,cinvcode,( case when brdflag=1 then iquantity else -1*(iquantity) end) as iquantity from rdrecord left join rdrecords on rdrecord.id=rdrecords.id ) a left join Inventoryon a.cinvcode=Inventory.cinvcodegroup by a.cwhcode,a.cinvcode godelete from currentstockGoinsert into currentstock (cwhcode,cinvcode,iquantity,inum) select cwhcode,cinvcode,iquantity,inum from tempdb..forcurrentsyzgo