金蝶专业/商贸版

金蝶商贸版6.1打开销售单明细表提示正在服务器获取数据?

解决办法:
可参考以下脚本执行处理:
set nocount on
declare @Fuserid int
select @Fuserid=Fuserid from t_user
--在这里修改需要清理个人信息的用户名
where fname='用户名'
--select @Fuserid
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
【注意事项】
正式账套执行脚本前请先做好备份,建议待在测试账套中核实无误后再在正式账套中执行。

金蝶KIS云是金蝶集团面向小型企业的管理软件,为小型企业提供财务、生产、销售、采购、仓存、零售、电商等云服务。金蝶KIS云秉承“让生意更成功”的理念,助力企业一键上云用云,让企业管理更高效,并通过创新的技术,带给企业上云全新体验。金蝶KIS云含金蝶旗舰版,金蝶专业版 ,金蝶标准板,迷你版等系列产品.

TOP