用友服务咨询热线：010-67201766

固定资产卡片管理打开错误，怎么解决问题描述：固定资产卡片管理打开错误，怎么解决？ 解决办法：对于进行数据复制的帐套，如出现此问题，可以进行下列操作，然后重新进行数据复制的初始化。 --删除指定名称的外键fa_ItemsManual_PK if exists(select * from sysobjects where id = object_id(N'[dbo].[fa_ItemsManual_PK]') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1) ALTER TABLE fa_ItemsManual DROP CONSTRAINT fa_ItemsManual_PK GO if exists (select syscolumns.name from syscolumns inner join sysobjects on syscolumns.id=sysobjects.id where syscolumns.name='ufguid' and sysobjects.name='fa_ItemsManual') ALTER TABLE [dbo].[fa_ItemsManual] DROP COLUMN [ufguid] go If Not Exists(SELECT name FROM sysobjects WHERE xtype = 'PK' and name= 'PK_fa_ItemsManual_sCardNum') ALTER TABLE [dbo].[fa_ItemsManual] WITH NOCHECK ADD CONSTRAINT [PK_fa_ItemsManual_sCardNum] PRIMARY KEY NONCLUSTERED ([sCardNum]) ON [PRIMARY] GO