T6-企业管理软件7.0 固定资产系统折旧分配表打不开，输入单据提示最大单据号的问题

固定资产系统折旧分配表打不开，输入单据提示最大单据号的问题。

问题回复：

1、在操作之前请先对进行数据备份，以防数据出错后无法恢复！

2、执行脚本： delete from fa_deprvouchers where lOptID>714 insert into fa_deprvouchermain(loptid,snum,imaxperiod,iminperiod,istyle,szwvouchertype,szwvouchernum,slockedby) values(701,'01',1,1,1,null,null,null) insert into fa_deprvouchermain(loptid,snum,imaxperiod,iminperiod,istyle,szwvouchertype,szwvouchernum,slockedby) values(702,'02',2,2,1,null,null,null) insert into fa_deprvouchermain(loptid,snum,imaxperiod,iminperiod,istyle,szwvouchertype,szwvouchernum,slockedby) values(706,'03',3,3,1,null,null,null) insert into fa_deprvouchermain(loptid,snum,imaxperiod,iminperiod,istyle,szwvouchertype,szwvouchernum,slockedby) values(707,'04',4,4,1,null,null,null) insert into fa_deprvouchermain(loptid,snum,imaxperiod,iminperiod,istyle,szwvouchertype,szwvouchernum,slockedby) values(708,'05',5,5,1,null,null,null) insert into fa_deprvouchermain(loptid,snum,imaxperiod,iminperiod,istyle,szwvouchertype,szwvouchernum,slockedby) values(710,'06',6,6,1,null,null,null) insert into fa_deprvouchermain(loptid,snum,imaxperiod,iminperiod,istyle,szwvouchertype,szwvouchernum,slockedby) values(714,'07',7,7,1,null,null,null) 请您看一下您的您的是不是003，不是的话需要您将UFDATA_003_2020和cacc_id='003' 修改为您的账套号 update ufsystem..ua_identity set ifatherid=(select max(id) from UFDATA_003_2020..AssemVouch),ichildid=(select max(autoID)from UFDATA_003_2020..AssemVouchs ) where cacc_id='003' and cvouchtype='As'