入库核算-异常单据维护,查询时报空指针
金蝶云社区-云社区用户895N1234
云社区用户895N1234
0人赞赏了该文章 1,941次浏览 未经作者许可,禁止转载编辑于2014年05月16日 15:17:55
请哪位大侠帮忙看下啊,入库核算里面,异常单据维护界面,查询时报空指针。是哪个字段有问题啊?
错误信息:null
Caused exception message is: SQL: SELECT '' AS SELECTED,T1.FBillTypeName,T1.FTransactionName,T1.FBillNumber,T1.FBizDate,T1.FMaterialNumber,T1.FMaterialName,T1.FModel,T1.FUnitName,T1.FQty,CASE WHEN T1.FUnitId = T1.FBaseUnitId THEN T1.FActualBaseUnitCost ELSE case when T1.FQty = 0 then 0 Round(To_decimal(To_decimal(T1.FActualCost,17,4)/T1.FQty, 21,8),T1.FPricePrecision) END end as FActualBaseUnitCost, T1.FActualCost,T1.FUnitStandardCost,T1.FStandardCost,T1.FBaseUnitName,T1.FBaseQty,T1.FMaterialId,T1.FUnitId,T1.FQtyPrecision,T1.FPricePrecision,T1.FBillTypeId,T1.FBillId,T1.FLocalCurrencyPrecision, T1.FCompanyOrgUnitID,T1.FBaseUnitId,T1.FEntryID
FROM VT8SR60N1S7X921QMXFVI1Y0S2 AS T1
ORDER BY T1.FBizDate,T1.FBILLTYPENAME
错误详细堆栈信息:com.kingdee.bos.SQLDataException: null
Caused exception message is: SQL: SELECT '' AS SELECTED,T1.FBillTypeName,T1.FTransactionName,T1.FBillNumber,T1.FBizDate,T1.FMaterialNumber,T1.FMaterialName,T1.FModel,T1.FUnitName,T1.FQty,CASE WHEN T1.FUnitId = T1.FBaseUnitId THEN T1.FActualBaseUnitCost ELSE case when T1.FQty = 0 then 0 Round(To_decimal(To_decimal(T1.FActualCost,17,4)/T1.FQty, 21,8),T1.FPricePrecision) END end as FActualBaseUnitCost, T1.FActualCost,T1.FUnitStandardCost,T1.FStandardCost,T1.FBaseUnitName,T1.FBaseQty,T1.FMaterialId,T1.FUnitId,T1.FQtyPrecision,T1.FPricePrecision,T1.FBillTypeId,T1.FBillId,T1.FLocalCurrencyPrecision, T1.FCompanyOrgUnitID,T1.FBaseUnitId,T1.FEntryID
FROM VT8SR60N1S7X921QMXFVI1Y0S2 AS T1
ORDER BY T1.FBizDate,T1.FBILLTYPENAME
at com.kingdee.eas.framework.report.app.CommRptBaseControllerBean.executeQuery(CommRptBaseControllerBean.java:183)
at com.kingdee.eas.scm.cal.app.ExceptionBillQueryFacadeControllerBean._query(ExceptionBillQueryFacadeControllerBean.java:104)
at com.kingdee.eas.framework.report.app.AbstractCommRptBaseControllerBean.query(AbstractCommRptBaseControllerBean.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:61)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy610.query(Unknown Source)
at com.kingdee.eas.framework.report.CommRptBase.query(CommRptBase.java:80)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_cal_1_IExceptionBillQueryFacade.pi4(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_cal_1_IExceptionBillQueryFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
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)
Caused by: java.sql.SQLException: SQL: SELECT '' AS SELECTED,T1.FBillTypeName,T1.FTransactionName,T1.FBillNumber,T1.FBizDate,T1.FMaterialNumber,T1.FMaterialName,T1.FModel,T1.FUnitName,T1.FQty,CASE WHEN T1.FUnitId = T1.FBaseUnitId THEN T1.FActualBaseUnitCost ELSE case when T1.FQty = 0 then 0 Round(To_decimal(To_decimal(T1.FActualCost,17,4)/T1.FQty, 21,8),T1.FPricePrecision) END end as FActualBaseUnitCost, T1.FActualCost,T1.FUnitStandardCost,T1.FStandardCost,T1.FBaseUnitName,T1.FBaseQty,T1.FMaterialId,T1.FUnitId,T1.FQtyPrecision,T1.FPricePrecision,T1.FBillTypeId,T1.FBillId,T1.FLocalCurrencyPrecision, T1.FCompanyOrgUnitID,T1.FBaseUnitId,T1.FEntryID
FROM VT8SR60N1S7X921QMXFVI1Y0S2 AS T1
ORDER BY T1.FBizDate,T1.FBILLTYPENAME
at com.kingdee.eas.framework.report.app.CommRptBaseControllerBean.executeQuery(CommRptBaseControllerBean.java:182)
... 21 more
Caused by: java.sql.SQLException
java.sql.SQLException: SQL: SELECT '' AS SELECTED,T1.FBillTypeName,T1.FTransactionName,T1.FBillNumber,T1.FBizDate,T1.FMaterialNumber,T1.FMaterialName,T1.FModel,T1.FUnitName,T1.FQty,CASE WHEN T1.FUnitId = T1.FBaseUnitId THEN T1.FActualBaseUnitCost ELSE case when T1.FQty = 0 then 0 Round(To_decimal(To_decimal(T1.FActualCost,17,4)/T1.FQty, 21,8),T1.FPricePrecision) END end as FActualBaseUnitCost, T1.FActualCost,T1.FUnitStandardCost,T1.FStandardCost,T1.FBaseUnitName,T1.FBaseQty,T1.FMaterialId,T1.FUnitId,T1.FQtyPrecision,T1.FPricePrecision,T1.FBillTypeId,T1.FBillId,T1.FLocalCurrencyPrecision, T1.FCompanyOrgUnitID,T1.FBaseUnitId,T1.FEntryID
FROM VT8SR60N1S7X921QMXFVI1Y0S2 AS T1
ORDER BY T1.FBizDate,T1.FBILLTYPENAME
at com.kingdee.eas.framework.report.app.CommRptBaseControllerBean.executeQuery(CommRptBaseControllerBean.java:182)
at com.kingdee.eas.scm.cal.app.ExceptionBillQueryFacadeControllerBean._query(ExceptionBillQueryFacadeControllerBean.java:104)
at com.kingdee.eas.framework.report.app.AbstractCommRptBaseControllerBean.query(AbstractCommRptBaseControllerBean.java:92)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:61)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy610.query(Unknown Source)
at com.kingdee.eas.framework.report.CommRptBase.query(CommRptBase.java:80)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_cal_1_IExceptionBillQueryFacade.pi4(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_cal_1_IExceptionBillQueryFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
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)