现金流量表查询报错
现金流量表查询报错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
现金流量表查询报错
本文2024-09-22 18:28:30发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-101008.html