问题现象: |
年度结转到存货-直运采购发票时提示:结转失败。 语句为: INSERT INTO PO_Pomain (POID, dPODate, cVenCode, cDepCode, cPersonCode, cPTCode, cArrivalPlace,cSCCode, nflat, cexch_name, iTaxRate, cPayCode, iCost, iBargain, cMemo, cPeriod,cState, cMaker, cVerifier, cCloser, cDefine1, cDefine2, cDefine3, cDefine4, cDefine5,cDefine6, cDefine7, cDefine8, cDefine9, cDefine10, POID, iVTid, cChanger,cBusType, cDefine11, cDefine12, cDefine13, cDefine14, cDefine15, cDefine16) SELECT POID, dPODate, cVenCode, cDepCode, cPersonCode, cPTCode, cArrivalPlace,cSCCode, nflat, cexch_name, iTaxRate, cPayCode, iCost, iBargain, cMemo, cPeriod,cState, cMaker, cVerifier, cCloser, cDefine1, cDefine2, cDefine3, cDefine4, cDefine5,cDefine6, cDefine7, cDefine8, cDefine9, cDefine10, POID, iVTid, cChanger,cBusType, cDefine11, cDefine12, cDefine13, cDefine14, cDefine15, cDefine16 From UFDATA_666_2004..PO_Pomain WHERE UFDATA_666_2004..PO_Pomain.POID=139 其中有两个POID,而第一个应为cPOID |