EAS7.5总账打了最新补丁8月17号的之后PT098231后往来帐查询报错
金蝶云社区-秦琴
秦琴
0人赞赏了该文章 1,998次浏览 未经作者许可,禁止转载编辑于2015年08月28日 12:11:46

根据报错信息,sql语句是错误的,少了from关键字,只有where关键字
由于暂时不能提单处理,所以放到这里来,希望总部的人员看一下
报错信息如下:
错误信息:Can't found propertyUnit: [accountTableID] in [com.kingdee.eas.fi.gl.app.AcctCussent]!, query : com.kingdee.eas.fi.gl.app.AcctCussentQuery, view :
SELECT id, period, bizDate, voucher.number, description, account.number, account.longName, measureUnit.name, endDate, quantity, verifiedQty, unVerifiedQty,
holdedQty, unHoldedQty, currency.name, currency.precision, originalAmount, verifiedAmtFor, unVerifiedAmtFor, holdedAmtFor, unHoldedAmtFor, localAmount,
verifiedAmtLocal, unVerifiedAmtLocal, holdedAmtLocal, unHoldedAmtLocal, reportingAmount, verifiedAmtRpt, unVerifiedAmtRpt, holdedAmtRpt, unHoldedAmtRpt, voucher.id, assGrp.customer.name, assGrp.provider.name, assGrp.companyOrg.name, assGrp.person.name, bizNumber, voucherType, accountTableID.id WHERE company.id = 'Ut4AAAAACgPM567U' AND (isinit = 0 OR isinit = 1 AND isinitclosed = 1) AND (period.periodYear = 2015 AND period.periodNumber = 1 AND (voucher.bizStatus IS NOT NULL) AND (voucher.bizStatus <> 0) AND (voucher.bizStatus <> 2) OR (voucher.bizStatus IS NULL)) AND (assGrp.customer.id IS NOT NULL) AND account.accountTableID.id = 'Ut4AAAAE+b0XaY5t' ORDER BY assGrp.customer.number ASC, VARBizDate ASC, id ASC
错误详细堆栈信息:com.kingdee.bos.BOSException: Can't found propertyUnit: [accountTableID] in [com.kingdee.eas.fi.gl.app.AcctCussent]!, query : com.kingdee.eas.fi.gl.app.AcctCussentQuery, view :

SELECT id, period, bizDate, voucher.number, description, account.number, account.longName, measureUnit.name, endDate, quantity, verifiedQty, unVerifiedQty, holdedQty, unHoldedQty, currency.name, currency.precision, originalAmount, verifiedAmtFor, unVerifiedAmtFor, holdedAmtFor, unHoldedAmtFor, localAmount, verifiedAmtLocal, unVerifiedAmtLocal, holdedAmtLocal, unHoldedAmtLocal, reportingAmount, verifiedAmtRpt, unVerifiedAmtRpt, holdedAmtRpt, unHoldedAmtRpt, voucher.id, assGrp.customer.name, assGrp.provider.name, assGrp.companyOrg.name, assGrp.person.name, bizNumber, voucherType, accountTableID.id
WHERE company.id = 'Ut4AAAAACgPM567U' AND (isinit = 0 OR isinit = 1 AND isinitclosed = 1) AND (period.periodYear = 2015 AND period.periodNumber = 1 AND (voucher.bizStatus IS NOT NULL) AND (voucher.bizStatus <> 0) AND (voucher.bizStatus <> 2) OR (voucher.bizStatus IS NULL)) AND (assGrp.customer.id IS NOT NULL) AND account.accountTableID.id = 'Ut4AAAAE+b0XaY5t' ORDER BY assGrp.customer.number ASC, VARBizDate ASC, id ASC

at com.kingdee.bos.metadata.query.util.QueryDeleUtil.processPropertyName(QueryDeleUtil.java:380)
at com.kingdee.bos.metadata.query.QueryDeleUpdater.updateQueryField(QueryDeleUpdater.java:97)
at com.kingdee.bos.metadata.query.QueryDeleUpdater.innerUpdateQuery(QueryDeleUpdater.java:70)
at com.kingdee.bos.metadata.query.QueryDeleUpdater.updateQuery(QueryDeleUpdater.java:39)
at com.kingdee.bos.metadata.query.util.QuerySqlAccessBase.init(QuerySqlAccessBase.java:103)
at com.kingdee.bos.dao.query.server.QueryContext.init(QueryContext.java:151)
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.innerOpenQuery(VirtualModeDataAccess.java:217)
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.innerOpenQuery(VirtualModeDataAccess.java:184)
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.openQuery(VirtualModeDataAccess.java:165)
at rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_IVirtualModeDataAccess.pi19(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_IVirtualModeDataAccess.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:611)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)