精品免费久久久久电影_在线a一级大片免费观看_老司机永久深夜在线视频_97尤物无码在线视频

    熱門關(guān)鍵詞用友BIP 用友U9 用友NC 用友U8 OA T+ 好業(yè)財

    詳細(xì)信息

    您現(xiàn)在的位置:網(wǎng)站首頁 >> 百科問答 >> 詳細(xì)信息

    從t+12.2升級到t+專屬云時,報錯

    發(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


    上一篇:T+采購入庫單沒有生成憑證,但是在生憑證界面選不到這個單據(jù)

    客服電話:400-665-0028

    魯ICP備10028716號-2

    用友好會計、用友易代賬、用友好業(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ù)公司