应收应付结转 : 结转发票时失败,原因为[类型不匹配] 问题描述:应收应付结转 : 结转发票时失败,原因为[类型不匹配] 问题原因:跟踪发现如下语句出错insert into purbillvouchs (ID, PBVID, cInvCode, bExBill, dInDate, iPBVQuantity, iNum, iOriCost, iOriMoney, iOriTaxPrice, iOriSum, iCost, iMoney, iTaxPrice, iSum, iExMoney, iLostQuan, iNLostQuan, iNLostMoney, iOriTotal, iTotal, cDebitHead, cTaxHead, cClue, dSignDate, cCorInvCode, cFree1, cFree2, iTaxRate, cDefine22, cDefine23, cDefine24, cDefine25,cDefine27, cDefine26, iPOsID, cItemCode, cItem_class, cNLostType, mNLostTax, cItemName, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10, dSDate,cUnitID, cDefine28, cDefine29, cDefine30, cDefine31, cDefine33, cDefine32, cDefine34, cDefine35, cDefine36, cDefine37, iSBsID, RdsId) SELECT UFDATA_020_2007..purbillvouchs.ID, PBVID, cInvCode, bExBill, dInDate, iPBVQuantity, iNum, iOriCost, iOriMoney, iOriTaxPrice, iOriSum, iCost, iMoney, iTaxPrice, iSum, iExMoney, iLostQuan, iNLostQuan, iNLostMoney, iOriTotal, iTotal, cDebitHead, cTaxHead, cClue, dSignDate, cCorInvCode, cFree1, cFree2, iTaxRate, cDefine22, cDefine23, cDefine24, cDefine25,cDefine27, cDefine26, iPOsID, UFDATA_020_2007..purbillvouchs.cItemCode, UFDATA_020_2007..purbillvouchs.cItem_class, cNLostType, mNLostTax, cItemName, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10, dSDate,cUnitID, cDefine28, cDefine29, cDefine30, cDefine31, cDefine33, cDefine32, cDefine34, cDefine35, cDefine36, cDefine37, iSBsID, RdsId FROM UFDATA_020_2007..purbillvouchs where pbvid=4 解决方案:游客无权查看 相关补丁:模块:系统管理产品:861问题名称:应收应付结转 : 结转发票时失败,原因为[类型不匹配]更新时间:2008-05-06 00:00:00 有用 没用95 浏览 分类 U8知识库用友U8知识库(旧)畅捷通知识库用友NC知识库用友U9知识库用友政务知识库致远OA知识库U8Cloud知识库