凭证过账功能报错
金蝶云社区-逐浪
逐浪
0人赞赏了该文章 371次浏览 未经作者许可,禁止转载编辑于2015年05月14日 14:52:38

金蝶K3Cloud5.0 打过5-8补丁 联系QQ:1744881734

凭证过账功能报错


parse error. detail message is :
unexcept token. token is : ')', at line 2 column 335, 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=139808 and (a.FVoucherID in (108387) and a.FPERIOD=(select top 1 FPERIOD from t_GL_Voucher where FVoucherID in (108387)) and FPOSTED='1'))

order by FName,FVOUCHERGROUPNO


多了一个)号