问题现象: | 890当时用户重新初始化。用实施工具导过存货档案,有的存货可能导过两遍,但当时软件并没有提示错误。但成本计算,材料及外购半成品取数。有的存货取过来的数据翻倍。特急。请求远程解决。QQ号为1009538747.谢谢。 [2011-11-30 9:03:10 补充] 电话刚刚关机,现在可以。 |
问题原因: | |
解决方案: | 您好, 此问题【经查看数据/测试】现做如下分析与答复: 【问题原因】 bas_part表同一物料存在多条记录 【解决方案】 【注意事项】修改前请务必做好数据备份; 脚本调整: select invcode into #tmp_inv from bas_part group by invcode having count(*) > 1 select a.invcode,Partid into #tmp_part from bas_part a,#tmp_inv t where a.invcode = t.invcode select invcode,Partid = min(partid) into #tmp_minpart from #tmp_part group by invcode select invcode,partid into #tmp_othpart from #tmp_part where not exists(select 1 from #tmp_minpart t where t.Partid = #tmp_part.partid) select zPartId = t1.Partid,tPartId = t2.Partid into #tmp_tt from #tmp_inv a,#tmp_minpart t1,#tmp_othpart t2 where a.invcode = t1.invcode and t1.invcode = t2.invcode order by a.invcode,t1.partid,t2.partid select name,id into #tmp_table from sysobjects where name like 'bom_%' or name like 'mom_%'or name like 'sfc_%'or name like 'mps_%'or name like 'ecn_%'or name like 'crp_%' select IDENTITY(int,1,1) as seq, tabname=object_name(a.id),colname=a.name Into #tmp_column from syscolumns a,#tmp_table b where object_name(a.id) = b.name and (a.name like '%AncestorId%' or a.name like '%ParentId%' or a.name like 'ComponentId%' or a.name like '%PartId%') and object_name(a.id) not in ('mps_currentstock','mps_currentstockbak','mps_currentstockdtl','mps_currentstockdtlbak','mps_temppart') order by object_name(a.id),a.name begin tran declare @l_i int,@l_tabname nvarchar(50),@l_colname nvarchar(50),@l_sql nvarchar(1000),@l_cnt int select @l_i = min(seq) from #tmp_column select @l_cnt = 1 while @l_cnt > 0 begin select @l_tabname = tabname,@l_colname = colname from #tmp_column where seq = @l_i select @l_cnt = @@rowcount select @l_sql = 'update a set a.' + @l_colname + '= t.zPartId from ' + @l_tabname + ' a,#tmp_tt t where a.' + @l_colname + ' = t.tPartId' select @l_i = @l_i + 1 exec ( @l_sql) end delete bas_part from bas_part , #tmp_othpart where #tmp_othpart.PartId = bas_part.PartId commit |
相关补丁: | |
版本: | 8.90 |
模块: | 成本管理 |
产品: | 管理会计 |
问题名称: | 890成本取存货的数据翻倍,特急,特急!!!!! |
最后更新: | 2011-12-07 23:40:55 |