存货核算-物料转换入库核算 报除0错误
金蝶云社区-华正科技_张华义
华正科技_张华义
0人赞赏了该文章 789次浏览 未经作者许可,禁止转载编辑于2015年11月10日 13:48:13

7.5版本,存货核算-物料转换入库核算 报除0错误,怎么解决?
详细报错信息如下:
错误信息:Sql1 execute exception : insert into VT152A83TRMQA0ISGJ1B21VRDP (FIssueEntryID, FEntryID, FSeq, FIssueActualCost, FInActualCost, FInUnitActualCost, FBaseQty, FQty, FPricePrecision) select inWarehs.FIssueEntryID,inWarehs.FEntryID,inWarehs.FSeq,inWarehs.FIssueActualCost, round(TO_DECIMAL(inWarehs.FIssueActualCost * round(inWarehs.FBaseQty / tmp.FTotalBaseQty, 10), 17, 4), 2) as FInActualCost, round(TO_DECIMAL(round(TO_DECIMAL(inWarehs.FIssueActualCost * round(inWarehs.FBaseQty / tmp.FTotalBaseQty, 10), 17, 4), 2) / inWarehs.FQty, 21, 8), inWarehs.FPricePrecision) as FInUnitActualCost, inWarehs.FBaseQty,inWarehs.FQty,inWarehs.FPricePrecision from (select noMoveAvgEntries.FIssueEntryID,noMoveAvgEntries.FEntryID,noMoveAvgEntries.FSeq, noMoveAvgEntries.FIssueActualCost - isnull(moveAvgEntries.FMoveAvgCostSum, 0) as FIssueActualCost, noMoveAvgEntries.FQty,noMoveAvgEntries.FBaseQty,noMoveAvgEntries.FPricePrecision from (select * from VT152A83TZ1I36I0XR5FTWG88OQO inWarehs where inWarehs.FAccountType <> 1) noMoveAvgEntries left join (select inWarehs.FIssueEntryID, sum(inWarehs.FOldInActualCost) as FMoveAvgCostSum from VT152A83TZ1I36I0XR5FTWG88OQO inWarehs where inWarehs.FAccountType = 1 group by inWarehs.FIssueEntryID) moveAvgEntries on noMoveAvgEntries.FIssueEntryID = moveAvgEntries.FIssueEntryID ) inWarehs inner join (select inWarehs.FIssueEntryID, TO_DECIMAL(sum(inWarehs.FBaseQty),21,8) as FTotalBaseQty from VT152A83TZ1I36I0XR5FTWG88OQO inWarehs where inWarehs.FAccountType <> 1 group by inWarehs.FIssueEntryID) tmp on inWarehs.FIssueEntryID = tmp.FIssueEntryID order by inWarehs.FIssueEntryID, inWarehs.FSeq
Caused exception message is: ORA-01476: divisor is equal to zero
错误详细堆栈信息:com.kingdee.bos.BOSException: Sql1 execute exception : insert into VT152A83TRMQA0ISGJ1B21VRDP (FIssueEntryID, FEntryID, FSeq, FIssueActualCost, FInActualCost, FInUnitActualCost, FBaseQty, FQty, FPricePrecision) select inWarehs.FIssueEntryID,inWarehs.FEntryID,inWarehs.FSeq,inWarehs.FIssueActualCost, round(TO_DECIMAL(inWarehs.FIssueActualCost * round(inWarehs.FBaseQty / tmp.FTotalBaseQty, 10), 17, 4), 2) as FInActualCost, round(TO_DECIMAL(round(TO_DECIMAL(inWarehs.FIssueActualCost * round(inWarehs.FBaseQty / tmp.FTotalBaseQty, 10), 17, 4), 2) / inWarehs.FQty, 21, 8), inWarehs.FPricePrecision) as FInUnitActualCost, inWarehs.FBaseQty,inWarehs.FQty,inWarehs.FPricePrecision from (select noMoveAvgEntries.FIssueEntryID,noMoveAvgEntries.FEntryID,noMoveAvgEntries.FSeq, noMoveAvgEntries.FIssueActualCost - isnull(moveAvgEntries.FMoveAvgCostSum, 0) as FIssueActualCost, noMoveAvgEntries.FQty,noMoveAvgEntries.FBaseQty,noMoveAvgEntries.FPricePrecision from (select * from VT152A83TZ1I36I0XR5FTWG88OQO inWarehs where inWarehs.FAccountType <> 1) noMoveAvgEntries left join (select inWarehs.FIssueEntryID, sum(inWarehs.FOldInActualCost) as FMoveAvgCostSum from VT152A83TZ1I36I0XR5FTWG88OQO inWarehs where inWarehs.FAccountType = 1 group by inWarehs.FIssueEntryID) moveAvgEntries on noMoveAvgEntries.FIssueEntryID = moveAvgEntries.FIssueEntryID ) inWarehs inner join (select inWarehs.FIssueEntryID, TO_DECIMAL(sum(inWarehs.FBaseQty),21,8) as FTotalBaseQty from VT152A83TZ1I36I0XR5FTWG88OQO inWarehs where inWarehs.FAccountType <> 1 group by inWarehs.FIssueEntryID) tmp on inWarehs.FIssueEntryID = tmp.FIssueEntryID order by inWarehs.FIssueEntryID, inWarehs.FSeq
Caused exception message is: ORA-01476: divisor is equal to zero
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:260)
at com.kingdee.eas.scm.cal.app.MatChangeCalculateFacadeControllerBean._costCalculate(MatChangeCalculateFacadeControllerBean.java:211)
at com.kingdee.eas.scm.cal.app.AbstractMatChangeCalculateFacadeControllerBean.costCalculate(AbstractMatChangeCalculateFacadeControllerBean.java:45)
at sun.reflect.GeneratedMethodAccessor4561.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:60)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:171)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy613.costCalculate(Unknown Source)
at com.kingdee.eas.scm.cal.MatChangeCalculateFacade.costCalculate(MatChangeCalculateFacade.java:44)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_cal_1_IMatChangeCalculateFacade.pi6(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_cal_1_IMatChangeCalculateFacade.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: ORA-01476: divisor is equal to zero
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:956)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1695)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1661)
at com.kingdee.bos.sql.shell.KDStatement.execute(KDStatement.java:470)
at com.apusic.jdbc.adapter.StatementHandle.execute(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:255)
... 20 more
Caused by: java.sql.SQLException
java.sql.SQLException: ORA-01476: divisor is equal to zero
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:956)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1695)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1661)
at com.kingdee.bos.sql.shell.KDStatement.execute(KDStatement.java:470)
at com.apusic.jdbc.adapter.StatementHandle.execute(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:255)
at com.kingdee.eas.scm.cal.app.MatChangeCalculateFacadeControllerBean._costCalculate(MatChangeCalculateFacadeControllerBean.java:211)
at com.kingdee.eas.scm.cal.app.AbstractMatChangeCalculateFacadeControllerBean.costCalculate(AbstractMatChangeCalculateFacadeControllerBean.java:45)
at sun.reflect.GeneratedMethodAccessor4561.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:60)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:171)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy613.costCalculate(Unknown Source)
at com.kingdee.eas.scm.cal.MatChangeCalculateFacade.costCalculate(MatChangeCalculateFacade.java:44)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_cal_1_IMatChangeCalculateFacade.pi6(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_scm_1_cal_1_IMatChangeCalculateFacade.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)