其他入库单提交报空指针异常
金蝶云社区-张勃_46907
张勃_46907
0人赞赏了该文章 718次浏览 未经作者许可,禁止转载编辑于2020年01月21日 17:40:14

1、问题现象:其他入库单提交报错


其他入库单提交前校验,报空指针异常

2、错误信息:null
错误详细堆栈信息:java.lang.NullPointerException: null

at: com.kingdee.eas.scm.im.inv.client.OtherInWarehsBillEditUI.beforeStoreFields(OtherInWarehsBillEditUI.java:2811)

at: com.kingdee.eas.framework.client.EditUI.verify(EditUI.java:897)

at: com.kingdee.eas.framework.client.EditUI.doBeforeSubmit(EditUI.java:1078)

at: com.kingdee.eas.framework.client.CoreBillEditUI.doBeforeSubmit(CoreBillEditUI.java:961)

at: com.kingdee.eas.scm.common.client.SCMBillEditUI.doBeforeSubmit(SCMBillEditUI.java:8183)

at: com.kingdee.eas.scm.common.client.SCMBillEditUI.beforeAction(SCMBillEditUI.java:7191)

at: com.kingdee.eas.scm.im.inv.client.OtherInWarehsBillEditUI.beforeAction(OtherInWarehsBillEditUI.java:5679)

错误代码at: com.kingdee.eas.scm.im.inv.client.OtherInWarehsBillEditUI.beforeStoreFields
原因:物料的财务资料没有维护。

代码错误:materialCompanyInfo对象没有判断是否为null!!!

3、查询语句
查询报错的分录:
select top 10 * -- 实际不用加 top 10from T_IM_OTHERINWAREHSBILLENTRY t1left join T_BD_MATERIAL t2 on t2.fid=t1.fmaterialid left join T_IM_OTHERINWAREHSBILL t3 on t3.fid=t1.fparentid where 1=1 and t2.fid in( select distinct FMATERIALID from T_BD_MATERIALCOMPANYINFO) and t3.fnumber='OTI2020000034' --其他入库单编码

查询该“其他入库单”相关物料中,没有维护的物料:
select distinct t2.fid,t2.fnumber from T_IM_OTHERINWAREHSBILLENTRY t1left join T_BD_MATERIAL t2 on t2.fid=t1.fmaterialid left join T_IM_OTHERINWAREHSBILL t3 on t3.fid=t1.fparentid where 1=1 and t2.fid in( select distinct FMATERIALID from T_BD_MATERIALCOMPANYINFO) and t3.fnumber='OTI2020000034' --其他入库单编码