问题现象: | 3月的成本计算有4个错误,费用有发生没有耗用,是成本中心仓库组的四个品种, 希望明天能给客户做个远程看一下,客户的qq号为:253743632,手机是13950135908,卢经理,错误截图见附件汉京.rar。 |
问题原因: | |
解决方案: | 您好 该数据远程分析答复如下: 0203部门没有完工数量,却有共用材料数据造成该问题. 这些脚本能查出来成本取到数据对应的出库单,需要把出库类别改为成本不取的出库类别,重新检查或卷积即可. 1.02150100001 --3个 select bcosting,* from rdrecord inner join rdrecords on rdrecord.id=rdrecords.id where cinvcode='02150100001' and --cwhcode='01' and --ccode='10124972' and brdflag=0 and crdcode in (select coutid from CA_IDMAC where btype=0) And cVouchType <> '35' and isnull(cbustype,'') <> N'委外发料' and isnull(cbustype,'') <> N'委外倒冲' and isnull(cbustype,'') <> N'委外盘点补差' and ddate between '2011-3-1' and '2011-3-31' and cdepcode='0203' 2.02020800008 --744个 select bcosting,* from rdrecord inner join rdrecords on rdrecord.id=rdrecords.id where cinvcode='02020800008' and --cwhcode='01' and --ccode='10124972' and brdflag=0 and crdcode in (select coutid from CA_IDMAC where btype=0) And cVouchType <> '35' and isnull(cbustype,'') <> N'委外发料' and isnull(cbustype,'') <> N'委外倒冲' and isnull(cbustype,'') <> N'委外盘点补差' and ddate between '2011-3-1' and '2011-3-31' and cdepcode='0203' 3.02050100002 --12个 select bcosting,* from rdrecord inner join rdrecords on rdrecord.id=rdrecords.id where cinvcode='02050100002' and --cwhcode='01' and --ccode='10124972' and brdflag=0 and crdcode in (select coutid from CA_IDMAC where btype=0) And cVouchType <> '35' and isnull(cbustype,'') <> N'委外发料' and isnull(cbustype,'') <> N'委外倒冲' and isnull(cbustype,'') <> N'委外盘点补差' and ddate between '2011-3-1' and '2011-3-31' and cdepcode='0203' 4.02050100006 --40个 select bcosting,* from rdrecord inner join rdrecords on rdrecord.id=rdrecords.id where cinvcode='02050100006' and --cwhcode='01' and --ccode='10124972' and brdflag=0 and crdcode in (select coutid from CA_IDMAC where btype=0) And cVouchType <> '35' and isnull(cbustype,'') <> N'委外发料' and isnull(cbustype,'') <> N'委外倒冲' and isnull(cbustype,'') <> N'委外盘点补差' and ddate between '2011-3-1' and '2011-3-31' and cdepcode='0203' 如对问题答复有疑问敬请及时反馈 U8/CRM/PLM |
相关补丁: | |
版本: | 8.90 |
模块: | 成本管理 |
产品: | 管理会计 |
问题名称: | 成本计算 |
最后更新: | 2011-10-26 23:17:07 |