問題原因:賬戶余額表錯誤，用腳本進(jìn)行重新計算。

  解決方法:備份數(shù)據(jù)。用友軟件反記賬方法">反記賬到年初，并用新建余額表腳本進(jìn)行更新fd_accbal表的操作：

  IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[fd_accBal]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN --------清空賬戶余額表-------- DELETE FROM fd_accBal --------判斷賬戶開戶日期是否超前系統(tǒng)起用日期：是--讀入系統(tǒng)起用日期 ；否--讀入賬戶開戶日期-------- DECLARE @dFDNatStartDate DateTime SET @dFDNatStartDate = (SELECT CONVERT(DATETIME,cValue) AS cValue FROM AccInformation WHERE cSysID = 'FD' AND cName = 'dFDNatStartDate') --------從賬戶定義表中讀取相應(yīng)數(shù)據(jù)到賬戶余額表-------- INSERT INTO fd_accBal (accdef_id,bill_date,bal_mny,bal_booked_mny,natural_bal_mny,natural_bal_booked_mny) SELECT accdef_id,(CASE WHEN dOpenDate < @dFDNatStartDate THEN @dFDNatStartDate ELSE dOpenDate END) AS OpenDate,isnull(mb,0), isnull(mb,0),isnull(qcye_natural_mny,0),isnull(qcye_natural_mny,0) FROM FD_AccDef ------------------------------- --------賬戶余額表升級--------- -------FD_transactions--------- ------------------------------- DECLARE @vchId fd_udt_id,@vchType varchar(2),@derVchType varchar(2), @billDate datetime, @rcvAccId fd_udt_id,@parAccId fd_udt_id, @fixedAccId fd_udt_id,@sumMny decimal(20,2), @comMny decimal(20,2),@natMny decimal(21,2), @bookBill int DECLARE @openDate datetime DECLARE @statues INT DECLARE @trncnt INT --影響賬戶余額的字段變更 -- SET cursor_close_on_commit ON DECLARE accBal CURSOR FOR SELECT fd_transactions.transactions_id,fd_entities.ibitype,fd_entities.iderivebitype, fd_transactions.bill_date,fd_transactions.rcv_acc_id,fd_transactions.pay_acc_id, fd_transactions.fixed_acc_id, SNULL(fd_transactions.sum_mny,0),ISNULL(fd_transactions.commission_mny,0), ISNULL(fd_transactions.natural_mny,0),CASE ISNULL(book_name,0) when '0' then 0 else 1 end FROM fd_transactions INNER JOIN fd_entities ON SUBSTRING(fd_transactions.transactions_id,1,2)=fd_entities.ibitype WHERE fd_entities.iderivebitype=@dFDNatStartDate begin EXEC @statues=fd_updatebalance @vchId,@vchType,@derVchType,@billDate,@rcvAccId, @parAccId,@fixedAccId,@sumMny,@comMny,@natMny,0 IF @statues!=0 OR @@error!=0 GOTO Errhandle if @bookbill<>0 begin EXEC @statues=fd_updatebalance @vchId,@vchType,@derVchType,@billDate,@rcvAccId, @parAccId,@fixedAccId,@sumMny,@comMny,@natMny,1 IF @statues!=0 OR @@error!=0 GOTO Errhandle end end FETCH accbal INTO @vchId,@vchType,@derVchType,@billDate,@rcvAccId, @parAccId,@fixedAccId,@sumMny,@comMny,@natMny,@bookbill END CLOSE accbal DEALLOCATE accbal --SET cursor_close_on_commit OFF GOTO ExitProc ErrHandle: DECLARE @errmsg VARCHAR(50) IF @statues!=0 BEGIN SELECT @errmsg=(CASE WHEN @statues=-101 THEN '賬戶余額表錯誤！賬戶在表中無記錄！' WHEN @statues=-102 THEN '賬戶余額表錯誤！賬戶在表中余額記錄丟失！' WHEN @statues=-103 THEN '賬戶余額表更新失�。⊙a(bǔ)記賬戶余額記錄操作失�。�' WHEN @statues=-104 THEN '賬戶余額表更新失��！更新賬戶余額記錄操作失敗！' END) RAISERROR(@errmsg,16,1) END CLOSE accbal DEALLOCATE accbal --SET cursor_close_on_commit OFF END ExitProc: GO 再重新記帳.