问题现象: | 7月材料外购耗用表和材料出库单金额对不上 部门: cibf原材料仓库(05)。已安装所有补丁后重取。 数据已经上传u8hangzhou卡莱-u872-sql2005.rar |
问题原因: | |
解决方案: | 您好, 经查看数据,现做如下答复: 原因: 因有一些订单行被停用,在定义产品不能刷出来; 解决方法: 在定义产品刷新中选择全部,把停用的启用; 可以通过如下语句来查看: 1、通过如下语句来查看有那些存货在成本与库存中不相同的存货; select a.InvCode ,b.cInvCode,iMatQua,b.iprice, iMatQua - b.iprice as chaer into aaa from ( select InvCode, sum(iMatQua) as iMatQua from bas_part inner join CA_MaBSW on bas_part.partid =CA_MaBSW.cMatID where cDeptID = '05' and iPeriod =7 group by InvCode )a inner join ( select cInvCode,sum(iPrice) as iPrice from rdrecords where ID in ( select ID from rdrecord where cDepCode = '05' and dDate between '2011-07-01' and '2011-07-31' and cVouchType = '11' and cWhCode = '203' ) group by cInvCode ) b on a.InvCode = b.cInvCode where iMatQua - b.iprice <> 0 go select * from aaa 2、可以找到对应的编号 select * From CA_MaBSW where iperiod = 7 and cmatid = '5892' and cmatid in (select Partid From bas_part where InvCode in (aaa表中的存货)) 3、通过编号:找到对应的成本对象; select * from ca_batchmap_cur where irealcoid in (12696,13261) --第1个存货 select cmocode,* from ca_batchmap_cur where irealcoid in (12695,12701,12711,13252) --第2个存货 4、再在定义产品属性:把其全部选择出来,启用; 注:如有问题可以与邮件,我将尽快与您联系 【注意事项】修改前请务必做好数据备份; |
相关补丁: | |
版本: | 8.72sp1 |
模块: | 成本管理 |
产品: | 管理会计 |
问题名称: | 材料外购耗用和材料出库单金额对不上 |
最后更新: | 2011-08-31 23:24:45 |