解决方案: |
A、218102科目:执行以下语句,然后重新录入21810203科目期初数:
delete from gl_accsum where ccode like '21810203%'
delete from gl_accsum where ccode like '21810202%'
update gl_accsum set mb=9009.0000,me=9009.0000 where ccode = '218102'
B、2105科目:执行以下语句,删除个人辅助帐中余额为0的记录
delete from gl_accass where ccode = '215105' and cperson_id='6401' and cdept_id ='014'
C、1181科目:执行以下语句,重新录入该科目项目期初余额,在录入该科目项目余额的合计必须与个人期初余额合计相等
delete from gl_accass where ccode = '1181' and citem_id is not null
D、120101科目:执行以下语句,重新录入该科目项目期初余额,在录入该科目项目余额的合计必须与个人期初余额合计相等
select sum(md)-sum(mc) from gl_accvouch where ccode = '120101' and iperiod=0 delete
from gl_accass where ccode = '120101' and citem_id is not null |