现金流量表查询报错

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-22浏览:1

现金流量表查询报错

现金流量表查询报错com.kingdee.bos.BOSException: Sql execute exception :  SELECT cfi.FId FidItem,  cfi.FLongNumber FLongNumber,
sum(cfit.FOriginalAmount) FOriginalAmount,  sum(cfit.FLocalAmount) FLocalAmount,  sum(cfit.FReportingAmount) FReportingAmount,  'y/8AAAAABkvM567U' FCompanyID
FROM T_BD_CashFlowItem cfi
inner join T_BD_CashFlowItem cfi0
on (charindex(cfi.FLongNumber || '!', cfi0.FLongNumber) = 1)
LEFT OUTER JOIN (
SELECT FCashflowItemID,
Fid,
FSeq,
FCurrencyID, FOriginalAmount, FLocalAmount, FReportingAmount,
FCompanyID
FROM T_GL_CashflowInit
WHERE FCurrencyID = ? AND FCompanyID = ?  ) cfit
ON cfi0.fid = cfit.FCashflowItemID
WHERE cfi.FType = 0
 and cfi0.Fisleaf =1  
 and cfi.FLevel <>1  
 GROUP BY cfi.FId,cfi.FLongNumber ,'y/8AAAAABkvM567U'
ORDER BY cfi.FLongNumber

Caused exception message is: 该游标未声明。
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:226)
at com.kingdee.eas.fi.gl.app.CashFlowRecordFacadeControllerBean.getInitAmountMap(CashFlowRecordFacadeControllerBean.java:501)
at com.kingdee.eas.fi.gl.app.CashFlowRecordFacadeControllerBean._genCashFlow(CashFlowRecordFacadeControllerBean.java:259)


解决方案:更新补丁PT117044

适用版本:EAS8.2

现金流量表查询报错

现金流量表查询报错com.kingdee.bos.BOSException: Sql execute exception : SELECT cfi.FId FidItem, cfi.FLongNumber FLon...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息