凭证生成报错
金蝶云社区-云社区用户V1L42042
云社区用户V1L42042
0人赞赏了该文章 783次浏览 未经作者许可,禁止转载编辑于2014年05月13日 17:14:04

生产入库单,生成凭证时报错。其他单据不会。

parse error. detail message is :

Error: expect token , but current token is , at line 9, column 36)
source sql is :
Select
t0.FID AS fid , t1.FENTRYID AS fentity_fentryid , t0.FDATE AS fdate , t0.FPRDORGID AS fprdorgid , t0.FOWNERTYPEID AS fownertypeid0 , t1.FAMOUNT AS famount , t05_L.FNAME AS fprdorgid_fname , t012_L.FNAME AS fworkshopid_fname , t1.FPRICE AS fprice , t1.FWORKSHOPID AS fworkshopid1 , t0.FBILLNO AS fbillno , t136_O.FNAME AS fmaterialid_fcategoryid , t138_O.FCATEGORYID AS fmaterialid_fcategoryid_id
,KSQL_SEQ FAutoIdentity
Into tmp997b0ec0da7e11e3a1f200a0d1e
From
T_PRD_INSTOCK t0 LEFT JOIN T_PRD_INSTOCKENTRY t1
ON (t0.FID = t1.FID ) LEFT JOIN
T_ORG_Organizations_L t05_L ON (t0.FPRDORGID=t05_L.FOrgID AND t05_L.FLocaleId=2052) LEFT JOIN
T_BD_DEPARTMENT_L t012_L ON (t0.=t012_L.FDEPTID AND t012_L.FLocaleId=2052) LEFT JOIN
T_BD_MATERIAL t11 ON (t1.FMATERIALID=t11.FMATERIALID) LEFT JOIN
T_BD_MATERIAL t11_O ON (t11.FMasterId=t11_O.FMasterId AND ( t11_O.FUseOrgId = 0 OR t11_O.FUseOrgId=100010)) LEFT JOIN