期末调汇凭证提交报错

栏目：eas cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

期末调汇凭证提交报错

1、问题描述

期末调汇生成的凭证，提交报错，报错如图：

报错堆栈：

Caused by: java.lang.NullPointerException

at com.kingdee.eas.fi.gl.app.voucher.SubmitStandradVoucherService.updateAdjustRateHistory(SubmitStandradVoucherService.java:281)

at com.kingdee.eas.fi.gl.app.voucher.SubmitStandradVoucherService.dealAfterSubmit(SubmitStandradVoucherService.java:234)

at com.kingdee.eas.fi.gl.app.voucher.AbstractSubmitBaseVoucherService.submitVoucher(AbstractSubmitBaseVoucherService.java:120)

at com.kingdee.eas.fi.gl.app.voucher.SubmitStandradVoucherService.submitVoucher(SubmitStandradVoucherService.java:92)

at com.kingdee.eas.fi.gl.app.BaseVoucherControllerBean._submit(BaseVoucherControllerBean.java:116)

at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean.submit(AbstractCoreBaseControllerBean.java:458)

at com.kingdee.eas.fi.gl.app.VoucherControllerBean.submit(VoucherControllerBean.java:2938)

2、解决方案

EAS 8.5版本需更新补丁PT158408，EAS8.61版本需更新补丁PT165737，或更新总账模块最新补丁。

临时变通处理，可以通过以下语句，找到错误的调汇历史记录，需要先备份待删除的错误记录，再删除错误记录。

--找到不正确的调汇历史信息记录

select arh.* from T_GL_AdjExchRateHistory arh

inner join t_gl_voucherentry ve on ve.faccountid=arh.faccountid and ve.FCurrencyID=arh.FCurrencyID

inner join t_gl_voucher v on ve.fbillid=v.fid inner join t_bd_period p on p.fid=v.fperiodid inner join t_org_company c on c.fid=v.fcompanyid where p.fnumber='期间编码' and c.fnumber='公司编码' and v.FSourceType=2 and ve.fcaa is not null and arh.FAssistHGID is null