(FAQ)新建二级会计科目提示:该数据记录已被科目余额引用
1、备份数据 2、前台删除该科目的业务数据 3、执行以下脚本清理余额表数据 delete from t_gl_accountbalance where faccountid = '待反分配的科目FID' delete from t_gl_assistbalance where faccountid = '待反分配的科目FID' delete from t_gl_assistmeasurebalance where faccountid = '待反分配的科目FID' delete from t_gl_initaccountbalance where faccountid = '待反分配的科目FID' delete from t_gl_initt_gl_assistbalance where faccountid = '待反分配的科目FID'