问题：应收系统期末结账报错
日志：错误信息：Sql3 execute exception : select FID from V_AR_CheckAuditedOrVouchered where (FCompanyID='4aafc657-0108-1000-e000-734585030146CCE7AED4') and FISCASH=0 and (FBillDate>={2015-06-01}) and (FBillDate<{2015-07-01}) and (FIsAudited = 0)
union all
select t1.FId
from (select distinct t1.FId, t1.FNumber
from T_CAS_RECEIVINGBILL t1
where t1.FCompanyId = '4aafc657-0108-1000-e000-734585030146CCE7AED4'
and t1.FunVerifiedAmt !=0
and t1.fpaymenttypeid ='cd54aa9f-03a4-459c-9c5a-5489dce5f0676BCA0AB5'
and (FBizDate >= {2015-06-01} and FBizDate < {2015-07-01}) T1)
union all
select t1.FId
from (select distinct t1.FId, t1.FNumber
from T_AR_OTHERBILL t1
where t1.FCompanyId = '4aafc657-0108-1000-e000-734585030146CCE7AED4'
and t1.FunVerifyAmount !=0
and t1.fpaymenttypeid ='cd54aa9f-03a4-459c-9c5a-5489dce5f0676BCA0AB5'
and (FBillDate >= {2015-06-01} and FBillDate < {2015-07-01}) T1)
union all
select distinct FId from V_AR_CheckAuditedOrVouchered
where FCompanyID='4aafc657-0108-1000-e000-734585030146CCE7AED4'
and FISCASH=1
and (FBillDate >= {2015-06-01} and FBillDate < {2015-07-01}) AND FIsAudited = 0
Caused exception message is: ORA-00904: "FISCASH": invalid identifier
解决方法：EAS服务器安装目录\Kingdee\eas\server\properties\upgradescript\eas\7_5_0to8_0_0\8_0_0_beta1\eas\scm\arap目录下的EAS800_fi_arap_update_data_view.ksql脚本 在eas管理控制台执行下 就可以解决结账报错的问题