直接SQL语句测试不通过，请帮看看什么问题？

select
t11.FNAME as 结算组织,
t1.FBILLNO as 发票号码,
convert(char(10),t1.FDATE,120) as 日期,
convert(char(10),t1.FINVOICEDATE,120) as 发票日期,
t2.FSEQ as 行号,
t8.FNUMBER as 物料代码,
t10.FNAME as 物料名称,
t10.FSPECIFICATION as 规格型号,
t2.FBASICUNITQTY as 基本单位数量,
sum(isnull(t5.FCOSTPRICE,isnull(t6.FCOSTPRICE,t7.FCOSTPRICE)) *t2.FBASICUNITQTY) as 成本,
t12.FBILLNO as 应收单编号,
convert(char(10),t12.FDATE,120) as 应收单业务日期,
t13.FNUMBER as 应收单客户代码,
t14.FNAME as 应收单客户名称,
t3.FTAXPRICE as 应收单含税单价,
t3.FALLAMOUNT as 应收单价税合计本位币,
t3.FSOURCEBILLNO as 应收单源单编号,
t3.FORDERNUMBER as 应收单销售订单号,
t3.FCOMMENT as 应收单备注,
t15.FNAME as 应收单销售部门,
t16.FNAME as 应收单销售员
from T_IV_SALESIC t1
join T_IV_SALESICENTRY t2 on t1.FID=t2.FID
join T_IV_SALESICENTRY_LK T9 ON t2.FENTRYID=T9.FENTRYID
left join T_AR_RECEIVABLEENTRY t3 on t9.FSBILLID=t3.FID and t9.FSID=t3.FENTRYID
left join T_AR_RECEIVABLE t12 on t12.FID=t3.FID
left join T_AR_RECEIVABLEENTRY_LK t4 on t3.FENTRYID=t4.FENTRYID
left join T_SAL_OUTSTOCKENTRY_F t5 on t4.FSTABLENAME='T_SAL_OUTSTOCKENTRY' and t5.FID=t4.FSBILLID and t5.FENTRYID=t4.FSID
left join T_SAL_RETURNSTOCKENTRY_F t6 on t4.FSTABLENAME='T_SAL_RETURNSTOCKENTRY' and t6.FID=t4.FSBILLID and t6.FENTRYID=t4.FSID
left join T_SAL_INITOUTSTOCKENTRY_F t7 on t4.FSTABLENAME='T_SAL_INITOUTSTOCKENTRY' and t7.FID=t4.FSBILLID and t7.FENTRYID=t4.FSID
left join T_BD_MATERIAL t8 on t2.FMATERIALID=t8.FMATERIALID
left join T_BD_MATERIAL_L t10 on t2.FMATERIALID=t10.FMATERIALID
left join T_ORG_ORGANIZATIONS_L t11 on t1.FSETTLEORGID=t11.FORGID
left join T_BD_CUSTOMER t13 on t12.FCUSTOMERID=t13.FCUSTID
left join T_BD_CUSTOMER_L t14 on t12.FCUSTOMERID=t14.FCUSTID
left join T_BD_DEPARTMENT_L t15 on t15.FDEPTID=t12.FSALEDEPTID
left join V_BD_SALESMAN_L t16 on t16.fid=t12.FSALEERID
where t1.FDATE>='2017-07-01 00:00:00.000' and t1.FDATE<='2017-10-31 00:00:00.000'
group by t11.FNAME,t1.FBILLNO,t1.FDATE,t1.FINVOICEDATE,t2.FSEQ,t8.FNUMBER,t10.FNAME,
t10.FSPECIFICATION,t2.FBASICUNITQTY,t12.FBILLNO,t12.FDATE,t13.FNUMBER,t14.FNAME,t3.FTAXPRICE,t3.FALLAMOUNT,t3.FSOURCEBILLNO,t3.FORDERNUMBER,t3.FCOMMENT,t15.FNAME,t16.FNAME