问题现象: | 成本模块,喷漆车间的共用材料连续4.5.6三个月有一个原材料重取了2遍数据,材料编码 12302042 数据路径:ftp://125.35.5.138/u8jilin/新立德9990630 |
问题原因: | |
解决方案: | 您好, 此问题【经查看数据/测试】现做如下分析与答复: 【注意事项】修改前请务必做好数据备份; 【问题原因】 bas_part表中存货12302042有两个id,删除一个即可 【解决方案】 查看对应的id select A.autoid as [A.autoid],B.cinvcode as [B.cinvcode],B.cinvname as [B.cinvname],B.cinvm_unit as [B.cinvm_unit],B.cinvstd as [B.cinvstd],B.free1 as [B.free1],B.free2 as [B.free2],B.free3 as [B.free3],B.free4 as [B.free4],B.free5 as [B.free5],B.free6 as [B.free6],B.free7 as [B.free7],B.free8 as [B.free8],B.free9 as [B.free9],B.free10 as [B.free10],isnull(A.iprice,0) as [A.iprice],isnull(A.iqua,0) as [A.iqua],isnull(A.imatqua,0) as [A.imatqua],isnull(A.irdcode,0) as [isnull(A.irdcode,0)],B.ipartid as [B.ipartid],isnull(A.badjust,0) as [isnull(A.badjust,0)] from ca_inventory B inner join ca_mabsw A on B.iPartid = A.cMatID where A.cppid is null and A.cdeptid =N'105' and A.cbatch =N'' and A.iperiod =N'4' and b.cinvcode='12302042' 本地环境删除了第二条。 delete bas_part where invcode='12302042' and partid=9512 |
相关补丁: | |
版本: | 8.72sp1 |
模块: | 成本管理 |
产品: | 管理会计 |
问题名称: | 共用材料成本取2遍数 |
最后更新: | 2011-07-12 08:01:46 |