NC65 财务报销 portal端填单保存后,收支项目被无故清空(偶发现象),导致审批人在单据管理节点修改或者审批时修改,保存报错,如下图:
查看代码发现大坑:
所以只能先后台数据库手动更新收支项目进去:
--020901 境内住宿费
select distinct code , name , mnecode , pk_inoutbusiclass , pk_parent from bd_inoutbusiclass where isnull(dr, 0) = 0 and ( enablestate = 2 ) and ( pk_inoutbusiclass = N'1001A11000000001WH8Y' ) order by code
--0209 境内差旅费
select distinct code , name , mnecode , pk_inoutbusiclass from bd_inoutbusiclass where pk_parent = '1001A11000000001WH8X' and ( enablestate = 2 ) and isnull(dr, 0) = 0
/*
code name mnecode pk_inoutbusiclass
020901 境内住宿费 NULL 1001A11000000001WH8Y
020902 城际交通费 NULL 1001A11000000001WH8Z
020903 境内伙食补贴 NULL 1001A11000000001WH90
020904 境内交通补贴 NULL 1001A11000000001WH91
020999 境内差旅费其他 NULL 1001A11000000001WH92
*/
--根据报销单据号查询单据主键
select pk_jkbx from er_bxzb bx where bx.djbh = '264X202303031270'
--根据报销主表主键查询子表页签号和收支项目
select pk_busitem, tablecode, szxmid from er_busitem bi where bi.pk_jkbx = '0001A11000000004R7KJ'
--根据子表主键更新对应的收支项目
update er_busitem set szxmid = '1001A11000000001WH8Y' where pk_busitem = '0001A11000000004R7KO';
update er_busitem set szxmid = '1001A11000000001WH8Z' where pk_busitem = '0001A11000000004R7KP';
update er_busitem set szxmid = '1001A11000000001WH8Z' where pk_busitem = '0001A11000000004R7KQ';
update er_busitem set szxmid = '1001A11000000001WH8Z' where pk_busitem = '0001A11000000004R7KR';
update er_busitem set szxmid = '1001A11000000001WH90' where pk_busitem = '0001A11000000004R7KS';
update er_busitem set szxmid = '1001A11000000001WH91' where pk_busitem = '0001A11000000004R7KT';
更新完收支项目后,保存又出现新的问题:
最后只能去【基础数据】-【单据控制规则-集团/业务单元】那里把相关的规则删除或停用了