|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
t6年度结转出现如下错误
-----------------------------------------------------------------
时间:2012-01-11--9:41:11
帐套:111
年度:2012
程序名: JZSN: CarryPreYear
模块:供应链结转:
最后语句: INSERT INTO PO_Pomain (cPOID, dPODate, cVenCode, cDepCode, cPersonCode, cPTCode, cArrivalPlace, cSCCode, cexch_name, iTaxRate, nflat, cPayCode, iCost, iBargain, cMemo, cState, cPeriod, cMaker, cVerifier, cCloser, cDefine1, cDefine2, cDefine3, cDefine4, cDefine5, cDefine6, cDefine7, cDefine8, cDefine9, cDefine10, POID, iVTid, cChanger, cBusType, cDefine11, cDefine12, cDefine13, cDefine14, cDefine15, cDefine16 ,dharrivedate, cAccountPID, cAccountPDate) SELECT cPOID, dPODate, cVenCode, cDepCode, cPersonCode, cPTCode, cArrivalPlace, cSCCode, cexch_name, iTaxRate, nflat, cPayCode, iCost, iBargain, cMemo, cState, cPeriod, cMaker, cVerifier, cCloser, cDefine1, cDefine2, cDefine3, cDefine4, cDefine5, cDefine6, cDefine7, cDefine8, cDefine9, cDefine10, POID, iVTid, cChanger, cBusType, cDefine11, cDefine12, cDefine13, cDefine14, cDefine15, cDefine16 ,dharrivedate, cAccountPID, cAccountPDate From UFDATA_001_2011..PO_Pomain WHERE UFDATA_001_2011..PO_Pomain.cState<>2 or dpodate>='2012-01-01'
错误信息:
|
|