问题现象: | 此客户实际为:“深圳市沈氏飞达实业有限公司” 做调拨单后,对其他入库单记账后,单价为0.其他出库单正常。不管是特殊单据记账还是正常单据记账。测试直接往其他入库单手工输入单价,记账后依然为0,申请集团专家明天上午远程支持 客户联系方式:范先生15218736289 075529752839-515 QQ:29187195 分公司联系人 江彬彬 13826597708 |
问题原因: | |
解决方案: | 您好,此问题【经远程查看数据】现做如下分析与答复: 【问题原因】 调拨单生成的其他入库单上的itrids丢失,目前导致该问题原因不清。建议做好数据备份后执行如下脚本并打上871后续最新库存补丁进行跟踪测试。【解决方案】 use UFDATA_132_2011 update rdrecords set rdrecords.itrids=rd.iTrIds from rdrecord join rdrecords on rdrecord.id=rdrecords.id join (select cbuscode,iTrIds,cinvcode,iquantity,cbatch from rdrecord join rdrecords on rdrecord.id=rdrecords.id where csource='调拨' and brdflag=0 )rd on rd.cinvcode=rdrecords.cinvcode and round(rd.iquantity,0)=round(rdrecords.iquantity,0) and rd.cbatch=rdrecords.cbatch and rd.cbuscode=rdrecord.cbuscode where cvouchtype in ('08','09') and csource='调拨' and rdrecords.itrids is null update rdrecords set rdrecords.itrids=rd.iTrIds from rdrecord join rdrecords on rdrecord.id=rdrecords.id join ( select cbuscode,iTrIds,cinvcode,iquantity,cbatch from rdrecord join rdrecords on rdrecord.id=rdrecords.id where csource='调拨' and brdflag=0 )rd on rd.cinvcode=rdrecords.cinvcode and round(rd.iquantity,0)=round(rdrecords.iquantity,0) --and rd.cbatch=rdrecords.cbatch and rd.cbuscode=rdrecord.cbuscode where cvouchtype in ('08','09') and csource='调拨' and rdrecords.itrids is null update rdrecords set itrids='199348' from rdrecord join rdrecords on rdrecord.id=rdrecords.id where cvouchtype in ('08','09') and ccode in('11070335','11070204') and cbuscode='11070176' 【注意事项】修改前请务必做好数据备份;可在测试环境下先行引入用户数据后执行脚本及打补丁测试验证 |
相关补丁: | |
版本: | 8.71 |
模块: | 存货管理 |
产品: | 供应链 |
问题名称: | 单据记账单价为0(申请集团远程) |
最后更新: | 2011-08-01 10:15:08 |