凭证过账报错
金蝶云社区-a745898009
a745898009
0人赞赏了该文章 814次浏览 未经作者许可,禁止转载编辑于2014年11月12日 16:24:03

parse error. detail message is :

Error: expect token , but current token is , at line 9, column 5)
source sql is :
Update T_GL_VOUCHERENTRY As T
Set (FDetailID) =( Select X.FNewID
from T_GL_VOUCHERENTRY a
Inner Join T_GL_VOUCHER b On a.FVoucherID=b.FVoucherID
Inner Join ( Select a.FID FOldID,b.FNewID
From T_BD_FLEXITEMDETAILV a
Inner Join (
Select Min(FID) FNewID,
a.,a.FF100002,a.FF100003,a.FF100004,a.FF100005,a.FF100006,a.FF100007,a.FFLEX10,a.FFLEX11,a.FFLEX4,a.FFLEX5,a.FFLEX6,a.FFLEX7,a.FFLEX9
From T_BD_FLEXITEMDETAILV a
Inner Join (
select Count(FID) FCount,
,FF100002,FF100003,FF100004,FF100005,FF100006,FF100007,FFLEX10,FFLEX11,FFLEX4,FFLEX5,FFLEX6,FFLEX7,FFLEX9
from T_BD_FLEXITEMDETAILV
Group By ,FF100002,FF100003,FF100004,FF100005,FF100006,FF100007,FFLEX10,FFLEX11,FFLEX4,FFLEX5,FFLEX6,FFLEX7,FFLEX9
Having Count(FID) >1
) b On
a.=b. And a.FF100002=b.FF100002 And a.FF100003=b.FF100003 And a.FF100004=b.FF100004 And a.FF100005=b.FF100005 And a.FF100006=b.FF100006 And a.FF100007=b.FF100007 And a.FFLEX10=b.FFLEX10 And a.FFLEX11=b.FFLEX11 And a.FFLEX4=b.FFLEX4 And a.FFLEX5=b.FFLEX5 And a.FFLEX6=b.FFLEX6 And a.FFLEX7=b.FFLEX7 And a.FFLEX9=b.FFLEX9
Group By a.,a.FF100002,a.FF100003,a.FF100004,a.FF100005,a.FF100006,a.FF100007,a.FFLEX10,a.FFLEX11,a.FFLEX4,a.FFLEX5,a.FFLEX6,a.FFLEX7,a.FFLEX9
) b On
a.=b. And a.FF100002=b.FF100002 And a.FF100003=b.FF100003 And a.FF100004=b.FF100004 And a.FF100005=b.FF100005 And a.FF100006=b.FF100006 And a.FF100007=b.FF100007 And a.FFLEX10=b.FFLEX10 And a.FFLEX11=b.FFLEX11 And a.FFLEX4=b.FFLEX4 And a.FFLEX5=b.FFLEX5 And a.FFLEX6=b.FFLEX6 And a.FFLEX7=b.FFLEX7 And a.FFLEX9=b.FFLEX9
) X On a.FDetailID = X.FOldID
Where T.FEntryID=a.FEntryID And a.fdetailid>0
and b.fposted='0'
)

进行 凭证过账 时,点击 过账 报这个错误。这是什么情况? 上午刚打了补丁PT092718,K3Cloud V3.0