总账结账报默认值丢失
问题描述:
总账结账,提示辅助账变更的默认值丢失
解决方案:
总账结账报默认值丢失,这个提示是由于结账时根据辅助账变更记录的默认值生成结转凭证,获取默认值时为空导致。比如科目由A变为A+B时,A核算项目不需设默认值,B核算项目要设个默认值,当其丢失就会报空。可使用以下脚本排查丢失情况
--由无变有丢失的情况
SELECT aae.* FROM t_bd_asstaccountchange aa
INNER JOIN T_bd_asstaccountchangeentry aae ON AA.FID= AAE.FPARENTID
INNER JOIN T_BD_AsstAccount bb ON AA.FAFTERID = BB.FID
INNER JOIN T_bd_accountview av ON AA.FACCOUNTID = AV.FID
INNER JOIN T_org_company c on av.FCOMPANYID =c.fid
--inner join t_bd_asstactgroupdetail asd on asd.FASSTACCOUNTID =ba.fid
where aae.FASSTACTID is null and aa.FBEFOREID is null and c.fnumber='公司编码'
--少变多默认值丢失情况
SELECT aae.* FROM t_bd_asstaccountchange aa
INNER JOIN T_bd_asstaccountchangeentry aae ON AA.FID = AAE.FPARENTID
INNER JOIN T_BD_AsstAccount ba ON AA.FBEFOREID = BA.FID
INNER JOIN T_BD_AsstAccount bb ON AA.FAFTERID = BB.FID
INNER JOIN T_bd_accountview av ON AA.FACCOUNTID = AV.FID
INNER JOIN T_org_company c on av.FCOMPANYID =c.fid
--inner join t_bd_asstactgroupdetail asd on asd.FASSTACCOUNTID =ba.fid
where aae.FASSTACTID is null and aae.FASSTACTTYPEID not in (SELECT FASSTACTTYPEID FROM t_bd_asstactgroupdetail b where b.FASSTACCOUNTID =ba.fid) and c.fnumber='公司编码'
查出的结果如图,补上核算项目的默认值即可
总账结账报默认值丢失
本文2024-09-22 18:28:50发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-101036.html