While doing a GP 10 (10.00.1868) to GP 2013 (12.00.1482) upgrade we were stopped by this error message. They do not use Analytical Accounting but there appears to be pieces of it left over. Is there any way to clear out all references to AA so I can run the upgrade again?
The following SQL statement produced an error:
CREATE FUNCTION [dbo].[ENC_FUNC_GET_aaBUDGETID] (@AccountIndex INTEGER, @aaFiscalPeriod INTEGER, @PeriodDate DATETIME, @FiscalYear INTEGER, @IsaaBudgetID INTEGER) RETURNS VARCHAR(100) AS BEGIN DECLARE @aaBudgetID VARCHAR(100) DECLARE @BudgetID VARCHAR (100) DECLARE @OutStr VARCHAR (100) IF (SELECT TOP 1 ENCAAValidationType FROM ENC40100 WHERE FiscalYear = @FiscalYear) = 1 BEGIN IF EXISTS (SELECT (aaBudgetID) FROM AAG00905 WHERE ACTINDX = @AccountIndex AND PERIODDT = @PeriodDate AND aaFiscalPeriod = @aaFiscalPeriod AND YEAR1 = @FiscalYear AND aaBudgetID IN (SELECT aaBudgetID FROM ENC40100 where FiscalYear = @FiscalYear) GROUP BY aaBudgetID HAVING ISNULL(SUM(Balance), 0) > 0) BEGIN SET @aaBudgetID = ISNULL((SELECT TOP 1 aaBudgetID from AAG00905 WHERE ACTINDX = @AccountIndex AND PERIODDT = @PeriodDate AND aaFiscalPeriod = @aaFiscalPeriod AND YEAR1 = @FiscalYear AND aaBudgetID IN (SELECT aaBudgetID FROM ENC40100 where FiscalYear = @FiscalYear) GROUP BY aaBudgetID HAVING ISNULL(SUM(Balance), 0) > 0), 0) END ELSE BEGIN SET @aaBudgetID = ISNULL((SELECT TOP 1 aaBudgetID from AAG00905 WHERE ACTINDX = @AccountIndex AND PERIODDT = @PeriodDate AND aaFiscalPeriod = @aaFiscalPeriod AND YEAR1 = @FiscalYear AND aaBudgetID IN (SELECT aaBudgetID FROM ENC40100 where FiscalYear = @FiscalYear) GROUP BY aaBudgetID HAVING ISNULL(SUM(Balance), 0) = 0), 0) END END ELSE BEGIN SET @aaBudgetID = ISNULL((SELECT TOP 1 aaBudgetID from AAG00904 WHERE PERIODDT = @PeriodDate AND aaFiscalPeriod = @aaFiscalPeriod AND YEAR1 = @FiscalYear AND aaBudgetID in (SELECT aaBudgetID from ENC40100 where FiscalYear = @FiscalYear) GROUP BY aaBudgetID HAVING ISNULL(SUM(Balance), 0) > 0), 0) END IF @aaBudgetID = 0 BEGIN SET @aaBudgetID = ISNULL((SELECT TOP 1 aaBudgetID FROM ENC40100 WHERE @PeriodDate>=From_Date AND @PeriodDate<=TODATE AND FiscalYear=@FiscalYear), 0) END IF @IsaaBudgetID != 1 BEGIN SET @BudgetID = (SELECT BUDGETID FROM ENC40100 WHERE @PeriodDate>=From_Date and @PeriodDate<=TODATE and FiscalYear = @FiscalYear and aaBudgetID = @aaBudgetID) SET @OutStr = @BudgetID END ELSE BEGIN SET @OutStr = @aaBudgetID END RETURN (@OutStr) END
*This post is locked for comments
I have the same question (0)
