凭证过账功能报错
380次浏览
编辑于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
多了一个)号