问题现象: | 8.90SP1 产品成本汇总表本期投入1257979.29 , 材料及外购半成品汇总材料费1258049.03(与存货出库汇总数据相同) 相差69.74 安装最新IA 和CA补丁重新卷积数据还是不正确相差72.57 产品成本汇总表与产品成本明细表数据相同 数据上传位置u8suzhou华旃890sp1sql2005苏分.rar |
问题原因: | |
解决方案: | 您好, 该问题,经查看数据,现做如下答复: 原因:是生产订单mom_orderdetail表中 PartID 和 InvCode 对应错误,可能是后台做过数据的调整; 如下语句可以查看到具体的订单号及对应的行号: select cmocode,* from ca_batchmap where irealcoid in ('3052','2965') 即:订单号:A11030253 行号:4 订单号:A11040212 行号:4 以下语句查出的partid,invcode不对应; select partid,invcode,b.* from mom_order a join mom_orderdetail b on a.moid=b.moid where mocode='A11030253' and sortseq=4 select partid,invcode,b.* from mom_order a join mom_orderdetail b on a.moid=b.moid where mocode='A11040212' and sortseq=4 与 select partid,invcode,* from bas_part where invcode='31030160019' select partid,invcode,* from bas_part where invcode='31030110028' 材料出库单等取数,是通过生产订单:mom_orderdetail,从而造成其在卷积的取不到数,没有分配; select cppid,ionptotalamo,* from ca_amoct where camoid='2209' and iperiod=3 and cppid='3052' and ionptotalamo<>0 select * from ca_mabsw where cmatid='2209' and cppid='3052' and iperiod=4 select cppid,itotalamo,* from ca_amoct where camoid='2209' and cppid='3052' and iperiod=4 and itotalamo<>0 select cppid,ionptotalamo ,*from ca_amoct where camoid='11929' and cppid='2965' and iperiod=3 and ionptotalamo<>0 select * from ca_mabsw where cmatid='11929' and cppid = '2965' and iperiod=4 select cppid,itotalamo,* from ca_amoct where camoid='11929' and cppid='2965' and iperiod=4 and itotalamo<>0 解决方法: 因中间涉及的表比较多,从后台更改会存在一定的风险性;建议生产订单重新删除重做; 【注意事项】修改前请务必做好数据备份; |
相关补丁: | |
版本: | 8.90 |
模块: | 成本管理 |
产品: | 管理会计 |
问题名称: | 产品成本汇总表数据不正确 |
最后更新: | 2011-06-23 23:04:39 |