导致这个原因的一般是系统库会计期间乱了,UFsystem库,表 UA_Period,
看是不是排序乱了(001是账套,2023是年度,根据自己实际修改)SELECT * FROM UA_Period
WHERE iYear = '2023' AND cAcc_Id = '001'
对系统库进行备份,然后执行语句(002是账套号,2022是年度,根据自己需求进行修改):
select * into temp_a from ufsystem..ua_period where cacc_id='002' and iyear='2022' order by iyear,iid
delete from ufsystem..ua_period where cacc_id='002' and iyear='2022'
insert into ufsystem..ua_period select * from temp_a
drop table temp_a