生产补料单 生产凭证报错
金蝶云社区-jason_wu
jason_wu
0人赞赏了该文章 554次浏览 未经作者许可,禁止转载编辑于2016年05月04日 16:22:12

K3Cloud 5.0最新补丁
parse error. detail message is :

[code]Error: expect token , but current token is , at line 6, column 33)
source sql is :
Select
t0.FID AS FID,t1.FENTRYID AS FEntity_FEntryID,t0.FBILLNO AS FBillNo,t0.FSTOCKORGID AS FSTOCKORGID,t0.FDATE AS FDate,t0.FPRDORGID AS FPrdOrgId,t0.FBILLTYPE AS FBillType,t0.FOWNERTYPEID AS FOwnerTypeId0,t1.FAMOUNT AS FAmount,st014_L.FDATAVALUE AS FWorkShopId_FDeptProperty,t1.FWORKSHOPID AS FEntryWorkShopId,st126_O.FNAME AS FMaterialId_FCategoryID,t1.FMATERIALGROUP AS FMaterialGroup,t1.FAMOUNT AS FAmount,T250.FAmount_LC As FXXX_FAmount ,T250.FExpenseID As FXXX_FExpenseID ,T252_L.FNAME AS FXXX_FExpenseID_FName
From
T_PRD_FEEDMTRL t0 LEFT JOIN T_PRD_FEEDMTRLDATA t1
ON (t0.FID = t1.FID ) LEFT JOIN
T_BD_DEPARTMENT st013 ON (t0.=st013.FDEPTID) LEFT JOIN
T_BAS_ASSISTANTDATAENTRY_L st014_L ON (st013.FDEPTPROPERTY=st014_L.FEntryID AND st014_L.FLocaleId=2052) LEFT JOIN
T_BD_MATERIAL st12 ON (t1.FMATERIALID=st12.FMATERIALID) LEFT JOIN
T_BD_MATERIAL st12_O ON (st12.FMasterId=st12_O.FMasterId AND ( st12_O.FUseOrgId = 0 OR st12_O.FUseOrgId=103538)) LEFT JOIN
t_BD_MaterialBase st125_O ON (st12_O.FMATERIALID=st125_O.FMATERIALID) LEFT JOIN
T_BD_MATERIALCATEGORY_L st126_O ON (st125_O.FCATEGORYID=st126_O.FCATEGORYID AND st126_O.FLocaleId=2052) INNER JOIN table(fn_StrSplit(@PKValue, ',', 1)) sp ON (sp.FId=t0.FID)
Left Outer Join T_PRD_FEEDMTRLDATA_CE As T250 On T250.FEntryID = t1.FEntryID And T250.FDIMENSIONID = 2 Left Join T_BD_EXPENSE T252 on T250.FExpenseID=T252.FExpID Left Join T_BD_EXPENSE_L T252_L on T252_L.FExpID=T252.FExpID And T252_L.FLOCALEID=2052
Where
t0.FFORMID = 'PRD_FeedMtrl'[/code]