用友软件销售发票号经常重复
微信号:yyrjgls
技术咨询,有偿服务!
复制微信号
技术咨询,有偿服务!
复制微信号
原因分析:销售发票主表salebillvouch索引丢失。 正常帐套有14个索引,客户帐套只有13个,缺1个。
问题解答:操作步骤:1. 由于帐套中有重复的发票号,需要在数据库中查出做对应修改。select [cSBVCode],[cVouchType] from [SaleBillVouch]group by [cSBVCode],[cVouchType]having count([cSBVCode])>1 or count([cVouchType])>12. 把重复发票号记录修改正确后,把缺失的索引增加进来。/****** Object: Index [SBVKey] Script Date: 07/12/2013 11:01:06 ******/CREATE UNIQUE NONCLUSTERED INDEX [SBVKey] ON [dbo].[SaleBillVouch] ([cSBVCode] ASC,[cVouchType] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GO索引增加后,后续操作若有发票号重复的情况,单据无法保存。