V3.0升级V5.0后凭证无法过账
stormvc
954次浏览
编辑于2014年12月08日 09:50:52
1.凭证过不了账，过账时出现以下错误
虽然状态是成功，但是实际上并未成功、
错误提示：
parse error. detail message is :
unexcept token. token is : ')', at line 2 column 937, token type is 'Punctuation'
source sql is :
insert into #TM_GL_BROKENVCHNO(FYEAR,FPeriod,FName,FVOUCHERGROUPNO) Select a.FYEAR,a.FPeriod,c.FName,a.FVOUCHERGROUPNO
From T_GL_VOUCHER a Inner Join T_bd_VoucherGroup b On a.FVOUCHERGROUPID= b.FVchGroupID Inner Join T_bd_VoucherGroup_L c On b.FVchGroupID= c.FVchGroupID And c.FLocaleID=2052 where a.FACCOUNTBOOKID=108127 and (a.FVoucherID in (100619,100578,100579,100580,100581,100582,100584,100585,100586,100587,100588,100589,100590,100591,100592,100593,100594,100595,100596,100597,100598,100599,100600,100601,100602,100603,100604,100605,100606,100607,100608,100609,100610,100611,100612,100613,100614,100615,100616,100617,100648,100622,100624,100633) and a.FPERIOD=(select top 1 FPERIOD from t_GL_Voucher where FVoucherID in (100619,100578,100579,100580,100581,100582,100584,100585,100586,100587,100588,100589,100590,100591,100592,100593,100594,100595,100596,100597,100598,100599,100600,100601,100602,100603,100604,100605,100606,100607,100608,100609,100610,100611,100612,100613,100614,100615,100616,100617,100648,100622,100624,100633)) and FPOSTED='1'))
order by FName,FVOUCHERGROUPNO
虽然状态是成功，但是实际上并未成功、
错误提示：
parse error. detail message is :
unexcept token. token is : ')', at line 2 column 937, token type is 'Punctuation'
source sql is :
insert into #TM_GL_BROKENVCHNO(FYEAR,FPeriod,FName,FVOUCHERGROUPNO) Select a.FYEAR,a.FPeriod,c.FName,a.FVOUCHERGROUPNO
From T_GL_VOUCHER a Inner Join T_bd_VoucherGroup b On a.FVOUCHERGROUPID= b.FVchGroupID Inner Join T_bd_VoucherGroup_L c On b.FVchGroupID= c.FVchGroupID And c.FLocaleID=2052 where a.FACCOUNTBOOKID=108127 and (a.FVoucherID in (100619,100578,100579,100580,100581,100582,100584,100585,100586,100587,100588,100589,100590,100591,100592,100593,100594,100595,100596,100597,100598,100599,100600,100601,100602,100603,100604,100605,100606,100607,100608,100609,100610,100611,100612,100613,100614,100615,100616,100617,100648,100622,100624,100633) and a.FPERIOD=(select top 1 FPERIOD from t_GL_Voucher where FVoucherID in (100619,100578,100579,100580,100581,100582,100584,100585,100586,100587,100588,100589,100590,100591,100592,100593,100594,100595,100596,100597,100598,100599,100600,100601,100602,100603,100604,100605,100606,100607,100608,100609,100610,100611,100612,100613,100614,100615,100616,100617,100648,100622,100624,100633)) and FPOSTED='1'))
order by FName,FVOUCHERGROUPNO
推荐阅读