固定资产恢复月末结账报错BOF或EOF解决办法

分享到:

2021-08-13 18:52:53

固定资产无法取消月末结账,对应的修改方法
use ufdata_008_2012
--select * into fa_vtsobject20120423 from fa_vtsobject order by imonth,smodelid
select * from fa_vtsobject order by imonth,smodelid
use ufdata_008_2011
select * from fa_vtsobject order by imonth,smodelid

--从上一年中的表中补充缺少的记录

insert into ufdata_008_2012..fa_vtsobject( iMonth,sModelId,objVtsfile)

select iMonth,sModelId,objVtsfile from ufdata_008_2011..fa_Vtsobject

where iMonth not in (select DISTINCT(iMonth) from ufdata_008_2012..fa_vtsobject)


insert into fa_vtsobject(imonth,sModelId,objVtsfile,iyear)
select '6',sModelId,objVtsfile,iyear  from fa_vtsobject  where iyear=2021 and iMonth=5
 

--因为上一年的记录也缺少,所以要手工添加记录

insert into ufdata_008_2012..fa_vtsobject( iMonth,sModelId,objVtsfile)

select 1,sModelId,objVtsfile from ufdata_008_2011..fa_Vtsobject where iMonth =4
声明:此篇为用友服务中心文章,转载请标明出处链接:
  • 相关文章
  • 热门下载
  • 数据修复
  • 热门标签
合作伙伴