(FAQ)科目余额表上的非明细科目上挂核算项目

【问题】: (FAQ)科目余额表上的非明细科目上挂核算项目
版本: 7.5
模块: 总账
【答复】:
a) 检查是否有凭证 select v.fnumber 凭证的编码,at.fnumber 科目的编码,p.fnumber 期间编码,c.fnumber 组织编码 from t_gl_voucherentry ve inner join t_bd_accountview at on at.fid = ve.faccountid left join t_gl_voucher v on v.fid = ve.fbillid left join t_bd_period p on p.fid = v.FPeriodID inner join t_org_company c on c.fid = at.FCompanyID where at.FIsLeaf = 0 如果有检查到凭证编码的话需要修改凭证。 如果没有搜索到凭证的话直接删除这条分录即可 a) 删除分录脏数据脚本如下 i. 备份数据(只有分录没有凭证头的才需要删除) select ve.* into ve0108bak from t_gl_voucherentry ve inner join t_bd_accountview at on at.fid = ve.faccountid left join t_gl_voucher v on v.fid = ve.fbillid left join t_bd_period p on p.fid = v.FPeriodID inner join t_org_company c on c.fid = at.FCompanyID where at.FIsLeaf = 0 and v.fid is null ii. 删除凭证脏数据 Delete from t_gl_voucherentry where fid in (select fid from ve0108bak) b) 检查初始化数据 select at.fnumber 科目的编码,c.fnumber 组织编码,hg.FDisplayNameGroup_L2 核算项目组合完整名称 from t_gl_initassistbalance ab inner join t_bd_accountview at on at.fid = ab.faccountid inner join t_org_company c on c.fid = at.FCompanyID inner join t_bd_assistanthg hg on hg.fid = ab.FAssistGrpID where at.FIsLeaf = 0 如果初始化数据有问题的话只能反初始化修改。 1、 余额清理 清理方案见《GLHY0042_总账余额脏数据清理脚本》 清理完毕后重算科目余额