用友-知识库

应收应付结转 : 结转发票时失败,原因为[类型不匹配]

  • 问题描述:应收应付结转 : 结转发票时失败,原因为[类型不匹配]
  • 问题原因:跟踪发现如下语句出错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 浏览