问题现象: | U890SP1 的环境,做年度结转时,做到销售发票的地方报错.跟踪后发现时执行下面语句是遇到错误,具体语句如下: select * from insert into SA_SNDetail_Bill (autoid, sbvid, iRowNO, cInvCode, cWhCode, cfree1, cfree2, cfree3, cfree4, cfree5, cfree6, cfree7, cfree8, cfree9, cfree10, cSNDefine1, cSNDefine2, cSNDefine3,cSNDefine4, cSNDefine5, cSNDefine6, cSNDefine7, cSNDefine8, cSNDefine9,cSNDefine10, iSNPreState, iSNOperateCount, cInCode, itrackid, cBatch, cVenCode, cInvSN, dmdate, dvdate, imassunit, imassdate, ipremassdate, cposition,cprePosition, cprewhcode, cpreBatch, cpreVenCode, ipretrackid, cpreincode,predmdate , predvdate, preimassunit, csnmemo, breturnflag, bused) select autoid, sbvid, iRowNO, cInvCode, cWhCode, cfree1, cfree2, cfree3, cfree4, cfree5, cfree6, cfree7, cfree8, cfree9, cfree10, cSNDefine1, cSNDefine2, cSNDefine3,cSNDefine4, cSNDefine5, cSNDefine6, cSNDefine7, cSNDefine8, cSNDefine9,cSNDefine10, iSNPreState, iSNOperateCount, cInCode, itrackid, cBatch, cVenCode, cInvSN, dmdate, dvdate, imassunit, imassdate, ipremassdate, cposition,cprePosition, cprewhcode, cpreBatch, cpreVenCode, ipretrackid, cpreincode,predmdate , predvdate, preimassunit, csnmemo, breturnflag, bused from UFDATA_006_2011..SA_SNDetail_Bill where sbvid in (select sbvid from UFDATA_006_2011..BSTmp) go |
问题原因: | |
解决方案: | 您好,此问题需查看具体数据,请将数据上传至集团提供的FTP目录: ftp://219.141.185.38/(外网);ftp://192.168.8.86/(内网); 代理上传数据账号为dlup,如不清楚密码则请咨询集团商业伙伴部李镜纮。 注:请将IE选项中,高级页签下的“使用被动FTP”的勾去掉 请注明上传的数据名称!!! 如有问题,请及时反馈! U8/CRM/PLM |
相关补丁: | |
版本: | 8.90 |
模块: | 系统管理 |
产品: | 公共平台 |
问题名称: | U890SP1年度结转问题 |
最后更新: | 2012-01-13 23:56:10 |