Problem solution
1. Back up the account first
select * into t_bd_account_1125 from T_BD_ACCOUNT
2, find out the problem voucher
select distinct b.FNUMBER as account book Code, v.FYEAR as year, v.FPERIOD as period, g.FNAME as voucher word, v.FVOUCHERGROUPNO as voucher number from T_GL_VOUCHERENTRY ve inner join T_GL_VOUCHER v on v.FVOUCHERID=ve.FVOUCHERID
inner join T_BD_ACCOUNTBOOK
inner join T_BD_ACCOUNTBOOK v.FACCOUNTBOOKID=b.FBOOKID
inner join T_BD_VOUCHERGROUP_L g on v.FVOUCHERGROUPID=g.FVCHGROUPID and g.FLOCALEID=2052
where FACCOUNTID in(
select FACCTID from T_BD_ACCOUNT where FACCTTID from T_BD_ACCOUNT like FACCTTID ‘ %/_1’escape’/’)
3. Export the voucher through the voucher list
(Use the voucher found in step 2 to filter the voucher list, and then export to Excel)
4. Delete the wrong account
delete from T_BD_ACCOUNT where FACCTID in(select FACCTID from T_BD_ACCOUNT where FACCTTBLID=2001 and FHELPERCODE like’%/_1’escape’/’))
5. Introduce the certificate again
Import the Excel voucher derived in step 3
Note: the attributes before and after the operation steps cannot be messed up