CLOUD 5.0
通过智能会计平台生成“生产入库单”的凭证报错,截图如下:
报错代码:
[url=]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,t1.FAMOUNT AS FAmount,st05_L.FNAME AS FPrdOrgId_FName,st127_O.FNAME AS FMaterialId_FCategoryID,st126.FCATEGORYID AS FMaterialId_FCategoryID_Id,st012_L.FNAME AS FWorkShopId_FName,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_INSTOCK t0 LEFT JOIN T_PRD_INSTOCKENTRY t1
ON (t0.FID = t1.FID ) LEFT JOIN
T_ORG_Organizations_L st05_L ON (t0.FPRDORGID=st05_L.FOrgID AND st05_L.FLocaleId=2052) LEFT JOIN
T_BD_MATERIAL st11 ON (t1.FMATERIALID=st11.FMATERIALID) LEFT JOIN
T_BD_MATERIAL st11_O ON (st11.FMasterId=st11_O.FMasterId AND ( st11_O.FUseOrgId = 0 OR st11_O.FUseOrgId=100003)) LEFT JOIN
t_BD_MaterialBase st126_O ON (st11_O.FMATERIALID=st126_O.FMATERIALID) LEFT JOIN
T_BD_MATERIALCATEGORY_L st127_O ON (st126_O.FCATEGORYID=st127_O.FCATEGORYID AND st127_O.FLocaleId=2052) LEFT JOIN
t_BD_MaterialBase st126 ON (t1.FMATERIALID=st126.FMATERIALID) LEFT JOIN
T_BD_DEPARTMENT_L st012_L ON (t0.=st012_L.FDEPTID AND st012_L.FLocaleId=2052) INNER JOIN table(fn_StrSplit(@PKValue, ',', 1)) sp ON (sp.FId=t0.FID)
Left Outer Join T_PRD_INSTOCKENTRY_CE As T250 On T250.FEntryID = t1.FEntryID And T250.FDIMENSIONID = 4 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_INSTOCK'[/url]