發(fā)布時間:2024-11-18 瀏覽:44次
特價活動:>>>> 用友U8、T6、T+、T3軟件產(chǎn)品特價活動,暢捷通T+cloud、好會計、易代賬、好業(yè)財、好生意云產(chǎn)品6-8折優(yōu)惠。
從12.2升級到專屬云時,報錯,具體看附件。
問題回復(fù):
客戶數(shù)據(jù)庫出現(xiàn)損壞的情況,需要針對具體的數(shù)據(jù)庫表中的數(shù)據(jù)做修復(fù)處理。 具體修復(fù)腳本如下: ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT (0) FOR [IsSystem] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT (2) FOR [DecimalDigits] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT (0) FOR [NeedReSetBooleanTxt] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT ('是|否') FOR [BooleanTxt] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT (1) FOR [PropTitleCanChange] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT (1) FOR [IsAsSearchCategoryField] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT ('string') FOR [FieldType] GO ALTER TABLE [dbo].[Eap_ColumnSet] ADD DEFAULT (0) FOR [IsDevField] GO
-- 針對出入庫明細(xì)的處理 UPDATE ST_RDRecord_b SET createdtime='2017-04-20 00:00:03.000',updated='2017-04-20' WHERE id='19964'; UPDATE ST_RDRecord_b SET createdtime='2018-08-04 00:00:26.000',updated='2018-08-04' WHERE id='69357'; GO
-- 針對銷貨單明細(xì)的處理 UPDATE SA_SaleDelivery_b SET updated = '2017-03-02 16:51:45.810' WHERE ID = 173 UPDATE SA_SaleDelivery_b SET updated = '2017-10-09 20:47:45.337', SingleInvGrossProfit = -18.2700000000000000 WHERE ID = 8297 GO
-- 針對銷售訂單明細(xì)的處理 UPDATE SA_SaleOrder_b SET executedQuantity = 600.00000000000000 WHERE id = 631 UPDATE SA_SaleOrder_b SET executedQuantity = 30.00000000000000, saleOutQuantity = 30.00000000000000 WHERE id = 2999 UPDATE SA_SaleOrder_b SET executedQuantity = 10.00000000000000 WHERE id = 3391 UPDATE SA_SaleOrder_b SET executedQuantity = 45.00000000000000, saleOutQuantity = 45.00000000000000 WHERE id = 3742 UPDATE SA_SaleOrder_b SET executedQuantity = 60.00000000000000 WHERE id = 5787 UPDATE SA_SaleOrder_b SET origDiscountAmount = ROUND(origDiscountPrice * quantity, 2) WHERE id = 15380 UPDATE SA_SaleOrder_b SET origDiscountAmount = 1140.00000000000000, discountAmount = 1140.00000000000000, taxPrice = 19.00000000000000, origTaxPrice = 19.00000000000000, taxRate = 0, discountPrice = 19.00000000000000, origDiscountPrice = 19.00000000000000 WHERE id = 16382 UPDATE SA_SaleOrder_b SET discountAmount = 185.0000000000000, origDiscountAmount = 185.0000000000000, taxAmount = 185.0000000000000, origTaxAmount = 185.0000000000000, tax = 0.00000000000000, origTax = 0.00000000000000, isPresent = 0 WHERE id = 12979 GO
-- 針對銷售訂單表頭的處理 UPDATE SA_SaleOrder SET voucherdate = '2016-12-22 00:00:00.000', madedate = '2016-12-22 00:00:00.000', auditeddate = '2016-12-22 00:00:00.000', createdtime = '2016-12-22 13:36:04.387', updated = '2016-12-22 13:36:04.387' WHERE ID = 253 GO
客服電話:400-665-0028
用友好會計、用友易代賬、用友好業(yè)財、用友好生意、用友T+Cloud試用地址__用友暢捷通公司網(wǎng)站
關(guān)鍵字:用友軟件,暢捷通軟件,財務(wù)軟件,進(jìn)銷存軟件,U9官網(wǎng),用友U8,用友T1,用友T+,用友T3,用友T6,暢捷通好會計,好生意,好業(yè)財,用友培訓(xùn)服務(wù)售后公司,暢捷通運(yùn)營培訓(xùn)服務(wù)公司