发布时间:2024-6-21
特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、好业财、好生意云产品6-8折优惠,另有话费赠送。
登录一个启用日期在19年的账套,提示日期不在业务范围内。后台显示20年有数据,但是登录还是提示日期不在业务范围内。新建账套做数据同步也是一样的提示。已打过最新补丁测试也没解决。
问题回复:
1、备份账套;
2、在账套库执行脚本:
set IDENTITY_INSERT sm_period on if not exists (select 1 from sm_period) begin insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2020,1,'2020-01-01 00:00:00.000','2020-01-31 00:00:00.000',1,1,13) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2020,2,'2020-02-01 00:00:00.000','2020-02-29 00:00:00.000',1,1,14) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2020,3,'2020-03-01 00:00:00.000','2020-03-31 00:00:00.000',1,1,15) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2020,4,'2020-04-01 00:00:00.000','2020-04-30 00:00:00.000',1,1,16) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2020,5,'2020-05-01 00:00:00.000','2020-05-31 00:00:00.000',1,1,17) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2020,6,'2020-06-01 00:00:00.000','2020-06-30 00:00:00.000',1,1,18) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2020,7,'2020-07-01 00:00:00.000','2020-07-31 00:00:00.000',0,0,19) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2020,8,'2020-08-01 00:00:00.000','2020-08-31 00:00:00.000',0,0,20) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2020,9,'2020-09-01 00:00:00.000','2020-09-30 00:00:00.000',0,0,21) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2020,10,'2020-10-01 00:00:00.000','2020-10-31 00:00:00.000',0,0,22) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2020,11,'2020-11-01 00:00:00.000','2020-11-30 00:00:00.000',0,0,23) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2020,12,'2020-12-01 00:00:00.000','2020-12-31 00:00:00.000',0,0,24) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2019,1,'2019-01-01 00:00:00.000','2019-01-31 00:00:00.000',3,3,1) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2019,2,'2019-02-01 00:00:00.000','2019-02-28 00:00:00.000',3,3,2) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2019,3,'2019-03-01 00:00:00.000','2019-03-31 00:00:00.000',3,3,3) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2019,4,'2019-04-01 00:00:00.000','2019-04-30 00:00:00.000',3,3,4) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2019,5,'2019-05-01 00:00:00.000','2019-05-31 00:00:00.000',3,3,5) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2019,6,'2019-06-01 00:00:00.000','2019-06-30 00:00:00.000',3,3,6) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2019,7,'2019-07-01 00:00:00.000','2019-07-31 00:00:00.000',3,3,7) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2019,8,'2019-08-01 00:00:00.000','2019-08-31 00:00:00.000',3,3,8) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2019,9,'2019-09-01 00:00:00.000','2019-09-30 00:00:00.000',3,3,9) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2019,10,'2019-10-01 00:00:00.000','2019-10-31 00:00:00.000',1,1,10) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2019,11,'2019-11-01 00:00:00.000','2019-11-30 00:00:00.000',1,1,11) insert into sm_period (currentyear,currentperiod,begindate,endDate,bizterminalstate,fiterminalstate,id) values (2019,12,'2019-12-01 00:00:00.000','2019-12-31 00:00:00.000',1,1,12) end set IDENTITY_INSERT sm_period off ;
3、重启后台服务 ;
4、登录。
截屏,微信识别二维码
客服QQ:5151867
(点击QQ号复制,添加好友)