我在使用用友T6企业管理软件的T6委外管理模块中碰到了一个奇怪的问题:
T6年结数年报错:程序名: UFOMJ
具体的情况如下:
T6年结数年报错:程序名: UFOMJZ: Begin模块:委外管理:委外订单最后语句:Insert Into OM_POMain ( ivtid,mosubid,MainId, ID, cInvCode, dStartDate, dEndDate, cMemo, fQuantity,iDataFrom, cFree1, fInQuantity, cFree2, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10, bUsed,cClose,bCheck,fTotalCheck,iMakeCharge,iTookQuantity,iInvalidQuantity,iCodeFrom,bPutFromSO,cSOsIDs,cbomsocode,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27,cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,ipbvquantity,iblevel,bbexpandend,cycdmainid,iycdsubid,cwwjhmainid,iwwjhsubid,ifromtype,fincheckquantity,fhgquantity,fbhgquantity,fhgnum,fbhgnum,fybjsquantity,fybjsnum,fybjsinquan,fybjsinnum,fhginquan,fhginnum,fthquantity,fthnum,fbfquantity,fbfnum,bPutFromYC, iYCsIDs, cItem_class, cItemCode, cItemName, cunitid, fNum, fInNum, fTookNum, iInvalidNum, finchecknum, iRelationID,csocode,sosid,ycsid,irejid,irdautoid,fthinquantity,fthinnum, taxmakeprice,imaketaxprice,imaketaxrate,taxmakemny,kpnum,kpquantity,jsquantity,jsnum,hbquantity,hbnum ) select ivtid,mosubid,MainId, ID, cInvCode, dStartDate, dEndDate, cMemo, fQuantity,iDataFrom, cFree1, fInQuantity, cFree2, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10, bUsed,cClose,bCheck,fTotalCheck,iMakeCharge,iTookQuantity,iInvalidQuantity,iCodeFrom,bPutFromSO,cSOsIDs,cbomsocode,cdefine22,cdefine23,cdefine24,cdefine25,cdefine26,cdefine27,cdefine28,cdefine29,cdefine30,cdefine31,cdefine32,cdefine33,cdefine34,cdefine35,cdefine36,cdefine37,ipbvquantity,iblevel,bbexpandend, cycdmainid,null as iycdsubid,null as cwwjhmainid,null as iwwjhsubid,ifromtype,fincheckquantity,fhgquantity,fbhgquantity,fhgnum,fbhgnum,fybjsquantity,fybjsnum,fybjsinquan,fybjsinnum,fhginquan,fhginnum,fthquantity,fthnum,fbfquantity,fbfnum ,bPutFromYC, iYCsIDs, cItem_class, cItemCode, cItemName, cunitid, fNum, fInNum, fTookNum, iInvalidNum, finchecknum, iRelationID, csocode,sosid,ycsid,irejid,irdautoid,fthinquantity,fthinnum, taxmakeprice,imaketaxprice,imaketaxrate,taxmakemny,kpnum,kpquantity,jsquantity,jsnum,hbquantity,hbnum from UFDATA_001_2015..OM_POMain where id=342错误信息: INSERT 语句与 COLUMN FOREIGN KEY 约束 'FK_OM_POMain_Inventory' 冲突。该冲突发生于数据库 'UFDATA_001_2016',表 'Inventory', column 'cInvCode'。
请问用友软件售后服务,应该如何解决呢?注意以下内容来自网友提供的尝试性解决方案,操作前请务必参考用友软件备份账套数据教程备份数据,如果未能解决您的问题,可以点击并添加用友软件工程师微信号进行咨询。
谢谢
16年可以新增加,但是不能删除,你现在要对比15年度的,15年有的16年必须要有且编码一致
2016年新增加存货档,物料清单。
是的,哪我现在怎么操作
建立年度账后年度结转前是不是在16年删除或者修复了委外的存货档案,新旧年度的存货档案必须要保持完全一致再结转。