问题现象: | 由t6升级工具将帐套输出为U8帐套后,导入U810.0进行升级提示错误如下: “数据库名: UFDATA_004_2009 C:U8SOFTADMINSQLFILE8610MainUfdatadataNLData_Upda_OM_mix_NL.sql 错误信息: -2147217900 列名 'irdsid' 不明确。 执行如下语句时出错: /*升级设置委外材料出库单的参与结算次数ibillsettlecount字段 黄朝阳*/ /*生成每行委外入库单参与结算的次数*/ --必须执行的脚本策略相关 select irdsid, count(irdsid) as settlecount into #BillSettleCount from (select distinct PurSettleVouch.psvid,irdsid from PurSettleVouch inner join PurSettleVouchs on PurSettleVouch.psvid=PurSettleVouchs.psvid inner join PurBillVouchs ON PurSettleVouchs.ibsid=PurBillVouchs.ID AND PurBillVouchs.bExbill=0) A group by irdsid /*计算对应委外材料出库单的参与结算次数并更新材料出库单*/ update rdrecords set iBillSettleCount=isnull(billsettlecount,0) from (select B.irdsid,sum(#BillSettleCount.settlecount) as billsettlecount from #BillSettleCount inner join OM_MatSettleVouchs A on #BillSettleCount.irdsid =A.irdsid and A.cvouchtype=N'01' inner join OM_MatSettleVouchs B on B.msid = A.msid and B.cvouchtype=N'11' group by B.irdsid) C inner join rdrecords on rdrecords.autoid=C.irdsid drop table #BillSettleCount” |
问题原因: | |
解决方案: | 您好,irdsid字段只能存在于pursettlevouch表中,若在PurSettleVouchs和PurBillVouchs表中存在该字段请删除。 如有问题,请及时反馈! U8/CRM/PLM |
相关补丁: | |
版本: | U8 V10.0 |
模块: | 总账 |
产品: | 财务会计 |
问题名称: | 通10.2升级U8V10.0错误 |
最后更新: | 2011-07-11 23:04:52 |