用友畅捷通T3 T6会计期间错乱
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
语句中的002是账套号,2022是年度,可根据实际修改,谢谢