核算記賬單價(jià)翻倍原因分析：采購優(yōu)化流程一張采購入庫單應(yīng)對應(yīng)一張采購結(jié)算單，出現(xiàn)問題原因是優(yōu)化流程下，一張采購入庫單對應(yīng)多張結(jié)算單。問題解答：更新腳本（注意備份數(shù)據(jù)）：BeginDeclare @ID intBEGINBEGIN TRANSACTIONDECLARE PSV CURSOR FOR SELECT Distinct PSVID FROM PurSettleVouchs WHERE ID Not In (SELECT ps.id FROM RdRecord r join RdRecords rs on (r.id = rs.id) join PurSettleVouchs ps on (ps.iRdsID = rs.AutoID and r.cCode = ps.cPIVCode) )OPEN PSVFETCH NEXT FROM PSV INTO @IDWHILE @@FETCH_STATUS = 0BEGIN--刪除結(jié)算單明細(xì)表DELETE FROM PurSettleVouchs WHERE PurSettleVouchs.PSVID = @ID IF (@@ERROR 0)Begin RollBack TRANSACTIONCLOSE PSVDEALLOCATE PSVReturnEndELSEBEGIN--刪除結(jié)算單主表DELETE FROM PurSettleVouch WHERE PSVID = @IDENDPrint @IDFETCH NEXT FROM PSV INTO @IDEND ENDCOMMIT TRANSACTIONCLOSE PSVDEALLOCATE PSVEnd