|
|
U8问题库
| 问题名称: |
共用材料成本取2遍数 |
| 问题号: |
201107070012 |
| 软件版本: |
8.72sp1 |
| 适用产品: |
管理会计 |
| 软件模块: |
成本管理 |
| 最后更新时间: |
2011-7-12 8:01:46 |
| 问题现象: |
成本模块，喷漆车间的共用材料连续4.5.6三个月有一个原材料重取了2遍数据，材料编码 12302042
数据路径：ftp:/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 |
马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。
您需要 登录 才可以下载或查看，没有账号？注册账号
×
成本模块，喷漆车间的共用材料连续4.5.6三个月有一个原材料重取了2遍数据，材料编码 12302042<br />
数据路径：ftp://125.35.5.138/u8jilin/新立德9990630 |
|
|站长微信|Archiver|手机版|小黑屋|用友之家
( 蜀ICP备07505338号|
51072502110008 )
IP卡
狗仔卡
发表于 2011-10-25 12:28:02
提升卡
置顶卡
变色卡
千斤顶
显身卡