英文界面下打开明细账报错
金蝶云社区-云社区用户BQ201456
云社区用户BQ201456
0人赞赏了该文章 760次浏览 未经作者许可,禁止转载编辑于2017年02月24日 00:54:42

英文界面下打开明细账时报错
http://village.ik3cloud.com/K3cloud

Insert Into #TM_GL_AccountDataForPag(FACCTID,FNUMBER,FNAME,FFULLNAME,FISDETAIL,
FCURRENCYID,FBEGINBALANCEFOR,FDEBITFOR,FCREDITFOR,FENDBALANCEFOR)
Select a.FACCTID,a.FNumber,a.FName,a.FFULLNAME,a.FISDETAIL,
a.FCURRENCYID,
Sum(FBeginBalanceFor) FBeginBalanceFor,
Sum(FDebitFor) FDebitFor,
Sum(FCreditFor) FCreditFor,
Sum(FEndBalanceFor) FEndBalanceFor
from (
select FACCTID,FNumber,FName,FFULLNAME,FISDETAIL,
FCURRENCYID,FBeginBalanceFor,FDebitFor,FCreditFor,FEndBalanceFor from (
Select a.FACCTID,a.FNumber,acct_l.FName,acct_l.FFullName,
a.FISDETAIL,
b.FCurrencyID,
Sum(ABS(b.FBeginBalanceFor)) FBeginBalanceFor,
Sum(ABS(b.FDebitFor)) FDebitFor,
Sum(ABS(b.FCreditFor)) FCreditFor,
Sum(ABS(b.FEndBalanceFor)) FEndBalanceFor
From T_BD_Account a
left join T_GL_BALANCE b on b.FACCOUNTID=a.FACCTID left join T_BD_Account_L acct_l on a.FACCTID=acct_l.FACCTID and acct_l.FLOCALEID=1033 where b.FACCOUNTBOOKID=100057 And FDETAILID=0
AND b.FCurrencyID=1 AND a.FLEVE

224.png(30.79KB)

224.png(30.79KB)