6.0升级 到7.0 ,管理员组用户 按F12键调出库存选择批次,调出的界面没有序号,批次和序号,换算率,多了一行计划跟踪号,内置管理员和新增用户界面显示正常。
问题描述:
解决方案:
【解决方案】需清除用户设置。declare @Fuserid int select @Fuserid=Fuserid from t_user where fname='manager' if exists (select 1 from sysobjects where name='ICClassUserProfile' and xtype='u') begin delete from ICClassUserProfile where fuserid=@Fuserid end if exists (select 1 from sysobjects where name='t_UserProfile' and xtype='u') begin delete from t_UserProfile where fuserid=@Fuserid end if exists (select 1 from sysobjects where name='ICReportProfile' and xtype='u') begin delete from ICReportProfile where fuserid=@Fuserid end if exists (select 1 from sysobjects where name='ICPlanProfile' and xtype='u') begin delete from ICPlanProfile where fuserid=@Fuserid end if exists (select 1 from sysobjects where name='ICPlanProfile' and xtype='u') begin delete from ICPlanProfile where fuserid=@Fuserid end if exists (select 1 from sysobjects where name='ICSchemeProfile' and xtype='u') begin delete from ICSchemeProfile where fuserid=@Fuserid end if exists (select 1 from sysobjects where name='icreportprofile' and xtype='u') begin delete from icreportprofile where fuserid=@Fuserid end if exists (select 1 from sysobjects where name='icreportformat' and xtype='u') begin delete from icreportformat where fuserid=@Fuserid end
其中“manager”为需要清除设置的用户名
6.0升级 到7.0 ,管理员组用户 按F12键调出库存选择批次,调出的界面没有序号,批次和序号,换算率,多了一行计划跟踪号,内置管理员和新增用户界面显示正常。
本文2024-09-22 16:21:15发表“kis知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-kis-87399.html