用友T3-标准版10.8plus1年结数据问题

供应链16年年结到17年无报错， 但是在17年查看采购订单时，订单的顺序是乱的，

年结后采购订单主表autoid 顺序和单据编码不一致。 请先备份帐套，在2017年数据库中执行附件脚本，重新插入数据后调整为一致。

年结后采购订单主表autoid 顺序和单据编码不一致，在2017年数据库中执行如下脚本，重新插入数据，后调整为一致。执行脚本前请务必备份数据库--先备份订单数据if exists(select * from sysobjects where id = object_id(N'[PO_Podetails_temp_T3-74029]') and OBJECTPROPERTY(id,N'IsUserTable') = 1) drop table [PO_Podetails_temp_T3-74029]go SELECT * into [PO_Podetails_temp_T3-74029] FROM [PO_Podetails] order by ID --select * from [PO_Podetails_temp_T3-74029] order by cPOID delete from [PO_Podetails] if exists(select * from sysobjects where id = object_id(N'[PO_Pomain_temp_T3-74029]') and OBJECTPROPERTY(id,N'IsUserTable') = 1) drop table [PO_Pomain_temp_T3-74029] go SELECT [cPOID],[dPODate],[cVenCode],[cDepCode],[cPersonCode],[cPTCode],[cArrivalPlace],[cSCCode], [cexch_name],[nflat],[iTaxRate],[cPayCode],[iCost],[iBargain],[cMemo],[cState],[cPeriod],[cMaker],[cVerifier],[cCloser],[cDefine1], [cDefine2],[cDefine3],[cDefine4],[cDefine5],[cDefine6],[cDefine7],[cDefine8],[cDefine9],[cDefine10],[cSource],[cBusCode],[cBusType] --,[AutoID] ,[cZQCode],[dZQDate] into [PO_Pomain_temp_T3-74029] FROM [PO_Pomain] order by cPOID --select * from [PO_Pomain_temp_T3-74029] order by cPOID delete from [PO_Pomain] --重置标志位 DBCC CHECKIDENT([PO_Pomain], RESEED, 1) --将备份数据重新插入 insert into [PO_Pomain] ([cPOID],[dPODate],[cVenCode],[cDepCode],[cPersonCode],[cPTCode],[cArrivalPlace],[cSCCode], [cexch_name],[nflat],[iTaxRate],[cPayCode],[iCost],[iBargain],[cMemo],[cState],[cPeriod],[cMaker],[cVerifier],[cCloser],[cDefine1], [cDefine2],[cDefine3],[cDefine4],[cDefine5],[cDefine6],[cDefine7],[cDefine8],[cDefine9],[cDefine10],[cSource],[cBusCode],[cBusType] --,[AutoID] ,[cZQCode],[dZQDate]) select [cPOID],[dPODate],[cVenCode],[cDepCode],[cPersonCode],[cPTCode],[cArrivalPlace],[cSCCode], [cexch_name],[nflat],[iTaxRate],[cPayCode],[iCost],[iBargain],[cMemo],[cState],[cPeriod],[cMaker],[cVerifier],[cCloser],[cDefine1], [cDefine2],[cDefine3],[cDefine4],[cDefine5],[cDefine6],[cDefine7],[cDefine8],[cDefine9],[cDefine10],[cSource],[cBusCode],[cBusType] --,[AutoID] ,[cZQCode],[dZQDate] from [PO_Pomain_temp_T3-74029] order by cPOID --select * from [PO_Pomain] order by AutoID insert into [PO_Podetails] select * from [PO_Podetails_temp_T3-74029] order by id --select * from [PO_Podetails] order by ID if exists(select * from sysobjects where id = object_id(N'[PO_Pomain_temp_T3-74029]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)drop table [PO_Pomain_temp_T3-74029] go if exists(select * from sysobjects where id = object_id(N'[PO_Podetails_temp_T3-74029]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)drop table [PO_Podetails_temp_T3-74029] go