Troubleshooting: Unable to open Consolidated Financial Report – Invalid DDL Statement . . . Cannot find the object “dbo.ConsolidateProfile” because it does not exist or you do not have permissions: Difference between revisions
(Created page with "'''Question:''' When I try to open AutoCount Consolidate Financial Report, system prompted error “Invalid DDL Statement . . . Cannot find the object “dbo.ConsolidateProfile”. What should I do? '''Version:''' 1.8 / 1.9 / 2.0 File:Dboconsolidateprofile1.png When click on OK File:Dboconsolidateprofile2.png Click OK again another error prompted. File:Dboconsolidateprofile3.png <u><b>Possible Reason:</b></u> There is a missing table in your Cons...") |
No edit summary |
||
Line 46: | Line 46: | ||
|- |
|- |
||
!<div style="text-align: left;"> |
!<div style="text-align: left;"> |
||
EXEC sp_addtype N'd_AccType', N'nvarchar (2)' |
EXEC sp_addtype N'd_AccType', N'nvarchar (2)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_Boolean', N'char (1)' |
EXEC sp_addtype N'd_Boolean', N'char (1)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_AccNo', N'nvarchar (12)' |
EXEC sp_addtype N'd_AccNo', N'nvarchar (12)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_AccDescription', N'nvarchar (80)' |
EXEC sp_addtype N'd_AccDescription', N'nvarchar (80)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_SpecialAccType', N'varchar (3)' |
EXEC sp_addtype N'd_SpecialAccType', N'varchar (3)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_CurrencyCode', N'nvarchar (5)' |
EXEC sp_addtype N'd_CurrencyCode', N'nvarchar (5)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_Project', N'nvarchar (20)' |
EXEC sp_addtype N'd_Project', N'nvarchar (20)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_Dept', N'nvarchar (20)' |
EXEC sp_addtype N'd_Dept', N'nvarchar (20)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_BudgetName', N'nvarchar (20)' |
EXEC sp_addtype N'd_BudgetName', N'nvarchar (20)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_PeriodNo', N'int' |
EXEC sp_addtype N'd_PeriodNo', N'int'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_Money', N'decimal(19,2)' |
EXEC sp_addtype N'd_Money', N'decimal(19,2)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_JournalType', N'nvarchar (10)' |
EXEC sp_addtype N'd_JournalType', N'nvarchar (10)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_SourceType', N'varchar (2)' |
EXEC sp_addtype N'd_SourceType', N'varchar (2)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_GLDescription', N'nvarchar (100)' |
EXEC sp_addtype N'd_GLDescription', N'nvarchar (100)'<br/> |
||
GO |
GO<br/> |
||
EXEC sp_addtype N'd_CurrencyRate', N'decimal(19, 12)' |
EXEC sp_addtype N'd_CurrencyRate', N'decimal(19, 12)'<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[ConsolidateProfile]( |
CREATE TABLE [dbo].[ConsolidateProfile](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[CompanyName] [nvarchar](80) NULL, |
[CompanyName] [nvarchar](80) NULL,<br/> |
||
[Remark] [nvarchar](12) NULL, |
[Remark] [nvarchar](12) NULL,<br/> |
||
[DisplayName] [nvarchar](40) NULL, |
[DisplayName] [nvarchar](40) NULL,<br/> |
||
[UseLiveDB] [d_Boolean] NOT NULL, |
[UseLiveDB] [d_Boolean] NOT NULL,<br/> |
||
[LiveDBServerName] [nvarchar] (100) NULL, |
[LiveDBServerName] [nvarchar] (100) NULL,<br/> |
||
[LiveDBUserName] [nvarchar] (20) NULL, |
[LiveDBUserName] [nvarchar] (20) NULL,<br/> |
||
[LiveDBPassword] [nvarchar] (100) NULL, |
[LiveDBPassword] [nvarchar] (100) NULL,<br/> |
||
[LiveDBDatabaseName] [nvarchar] (20) NULL, |
[LiveDBDatabaseName] [nvarchar] (20) NULL,<br/> |
||
[FiscalYearStartPeriod] [int] NULL, |
[FiscalYearStartPeriod] [int] NULL,<br/> |
||
[ActualDataStartPeriod] [int] NULL, |
[ActualDataStartPeriod] [int] NULL,<br/> |
||
[CurrencyDecimal] [int] NOT NULL, |
[CurrencyDecimal] [int] NOT NULL,<br/> |
||
[UseLiveStockBalance] [d_Boolean] NOT NULL, |
[UseLiveStockBalance] [d_Boolean] NOT NULL,<br/> |
||
[UseBankerRounding] [d_Boolean] NOT NULL, |
[UseBankerRounding] [d_Boolean] NOT NULL,<br/> |
||
[OpeningBalanceInYTD] [d_Boolean] NOT NULL, |
[OpeningBalanceInYTD] [d_Boolean] NOT NULL,<br/> |
||
[BalanceStockAccountNo] [d_AccNo] NULL, |
[BalanceStockAccountNo] [d_AccNo] NULL,<br/> |
||
[LastUpdatedData] [datetime] NULL, |
[LastUpdatedData] [datetime] NULL,<br/> |
||
CONSTRAINT [PK_ConsolidateProfile] PRIMARY KEY NONCLUSTERED |
CONSTRAINT [PK_ConsolidateProfile] PRIMARY KEY NONCLUSTERED<br/> |
||
( |
(<br/> |
||
[AccountBookKey] ASC |
[AccountBookKey] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[AccGroup] ( |
CREATE TABLE [dbo].[AccGroup] (<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[AccType] [d_AccType] NOT NULL, |
[AccType] [d_AccType] NOT NULL,<br/> |
||
[Seq] [int] NOT NULL, |
[Seq] [int] NOT NULL,<br/> |
||
[NormalBalance] char(1) NOT NULL, |
[NormalBalance] char(1) NOT NULL,<br/> |
||
[Group] char(2) NOT NULL, |
[Group] char(2) NOT NULL,<br/> |
||
[Level] [int] NOT NULL, |
[Level] [int] NOT NULL,<br/> |
||
CONSTRAINT [PK_AccGroup] PRIMARY KEY NONCLUSTERED |
CONSTRAINT [PK_AccGroup] PRIMARY KEY NONCLUSTERED<br/> |
||
( |
(<br/> |
||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[AccType] ASC |
[AccType] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[AccType] ( |
CREATE TABLE [dbo].[AccType] (<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[AccType] [d_AccType] NOT NULL, |
[AccType] [d_AccType] NOT NULL,<br/> |
||
[Description] [nvarchar] (40) NULL , |
[Description] [nvarchar] (40) NULL ,<br/> |
||
[Desc2] [nvarchar] (40) NULL , |
[Desc2] [nvarchar] (40) NULL ,<br/> |
||
[IsBSType] [d_Boolean] NOT NULL , |
[IsBSType] [d_Boolean] NOT NULL ,<br/> |
||
[IsSystemType] [d_Boolean] NOT NULL , |
[IsSystemType] [d_Boolean] NOT NULL ,<br/> |
||
CONSTRAINT [PK_AccType] PRIMARY KEY NONCLUSTERED |
CONSTRAINT [PK_AccType] PRIMARY KEY NONCLUSTERED<br/> |
||
( |
(<br/> |
||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[AccType] ASC |
[AccType] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[GLMast]( |
CREATE TABLE [dbo].[GLMast](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[AccNo] [dbo].[d_AccNo] NOT NULL, |
[AccNo] [dbo].[d_AccNo] NOT NULL,<br/> |
||
[ParentAccNo] [dbo].[d_AccNo] NULL, |
[ParentAccNo] [dbo].[d_AccNo] NULL,<br/> |
||
[Description] [dbo].[d_AccDescription] NULL, |
[Description] [dbo].[d_AccDescription] NULL,<br/> |
||
[Desc2] [dbo].[d_AccDescription] NULL, |
[Desc2] [dbo].[d_AccDescription] NULL,<br/> |
||
[AccType] [dbo].[d_AccType] NOT NULL, |
[AccType] [dbo].[d_AccType] NOT NULL,<br/> |
||
[SpecialAccType] [dbo].[d_SpecialAccType] NULL, |
[SpecialAccType] [dbo].[d_SpecialAccType] NULL,<br/> |
||
[CurrencyCode] [dbo].[d_CurrencyCode] NOT NULL, |
[CurrencyCode] [dbo].[d_CurrencyCode] NOT NULL,<br/> |
||
[CashFlowCategory] [char](1) NULL, |
[CashFlowCategory] [char](1) NULL,<br/> |
||
CONSTRAINT [PK_GLMast] PRIMARY KEY NONCLUSTERED |
CONSTRAINT [PK_GLMast] PRIMARY KEY NONCLUSTERED<br/> |
||
( |
(<br/> |
||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[AccNo] ASC |
[AccNo] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[AssetLink]( |
CREATE TABLE [dbo].[AssetLink](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[AssetAccNo] [dbo].[d_AccNo] NOT NULL, |
[AssetAccNo] [dbo].[d_AccNo] NOT NULL,<br/> |
||
[AssetDeprnAccNo] [dbo].[d_AccNo] NOT NULL, |
[AssetDeprnAccNo] [dbo].[d_AccNo] NOT NULL,<br/> |
||
CONSTRAINT [PK_AssetLink] PRIMARY KEY NONCLUSTERED |
CONSTRAINT [PK_AssetLink] PRIMARY KEY NONCLUSTERED<br/> |
||
( |
(<br/> |
||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[AssetAccNo] ASC, |
[AssetAccNo] ASC,<br/> |
||
[AssetDeprnAccNo] ASC |
[AssetDeprnAccNo] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[Project]( |
CREATE TABLE [dbo].[Project](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[ProjNo] [dbo].[d_Project] NOT NULL, |
[ProjNo] [dbo].[d_Project] NOT NULL,<br/> |
||
[ParentProjNo] [dbo].[d_Project] NULL, |
[ParentProjNo] [dbo].[d_Project] NULL,<br/> |
||
[Description] [nvarchar](40) NULL, |
[Description] [nvarchar](40) NULL,<br/> |
||
[Desc2] [nvarchar](40) NULL, |
[Desc2] [nvarchar](40) NULL,<br/> |
||
[IsActive] [dbo].[d_Boolean] NOT NULL, |
[IsActive] [dbo].[d_Boolean] NOT NULL,<br/> |
||
[LastUpdate] [int] NOT NULL, |
[LastUpdate] [int] NOT NULL,<br/> |
||
CONSTRAINT [PK_Project] PRIMARY KEY NONCLUSTERED |
CONSTRAINT [PK_Project] PRIMARY KEY NONCLUSTERED<br/> |
||
( |
(<br/> |
||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[ProjNo] ASC |
[ProjNo] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[Dept]( |
CREATE TABLE [dbo].[Dept](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[DeptNo] [dbo].[d_Dept] NOT NULL, |
[DeptNo] [dbo].[d_Dept] NOT NULL,<br/> |
||
[ParentDeptNo] [dbo].[d_Dept] NULL, |
[ParentDeptNo] [dbo].[d_Dept] NULL,<br/> |
||
[Description] [nvarchar](40) NULL, |
[Description] [nvarchar](40) NULL,<br/> |
||
[Desc2] [nvarchar](40) NULL, |
[Desc2] [nvarchar](40) NULL,<br/> |
||
[IsActive] [dbo].[d_Boolean] NOT NULL, |
[IsActive] [dbo].[d_Boolean] NOT NULL,<br/> |
||
[LastUpdate] [int] NOT NULL, |
[LastUpdate] [int] NOT NULL,<br/> |
||
CONSTRAINT [PK_Dept] PRIMARY KEY NONCLUSTERED |
CONSTRAINT [PK_Dept] PRIMARY KEY NONCLUSTERED<br/> |
||
( |
(<br/> |
||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[DeptNo] ASC |
[DeptNo] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[Budget]( |
CREATE TABLE [dbo].[Budget](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[BudgetKey] [int] NOT NULL, |
[BudgetKey] [int] NOT NULL,<br/> |
||
[BudgetName] [dbo].[d_BudgetName] NOT NULL, |
[BudgetName] [dbo].[d_BudgetName] NOT NULL,<br/> |
||
CONSTRAINT [PK_Budget] PRIMARY KEY NONCLUSTERED |
CONSTRAINT [PK_Budget] PRIMARY KEY NONCLUSTERED<br/> |
||
( |
(<br/> |
||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[BudgetKey] ASC |
[BudgetKey] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[BudgetPBalance]( |
CREATE TABLE [dbo].[BudgetPBalance](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[BudgetKey] [int] NOT NULL, |
[BudgetKey] [int] NOT NULL,<br/> |
||
[PeriodNo] [dbo].[d_PeriodNo] NOT NULL, |
[PeriodNo] [dbo].[d_PeriodNo] NOT NULL,<br/> |
||
[AccNO] [dbo].[d_AccNo] NOT NULL, |
[AccNO] [dbo].[d_AccNo] NOT NULL,<br/> |
||
[ProjNo] [dbo].[d_Project] NULL, |
[ProjNo] [dbo].[d_Project] NULL,<br/> |
||
[DeptNo] [dbo].[d_Dept] NULL, |
[DeptNo] [dbo].[d_Dept] NULL,<br/> |
||
[Amount] [dbo].[d_Money] NULL |
[Amount] [dbo].[d_Money] NULL<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE NONCLUSTERED INDEX [IX_BudgetPBalance] ON [dbo].[BudgetPBalance] |
CREATE NONCLUSTERED INDEX [IX_BudgetPBalance] ON [dbo].[BudgetPBalance]<br/> |
||
(<br/> |
|||
( |
|||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[BudgetKey] ASC, |
[BudgetKey] ASC,<br/> |
||
[PeriodNo] ASC, |
[PeriodNo] ASC,<br/> |
||
[AccNO] ASC, |
[AccNO] ASC,<br/> |
||
[ProjNo] ASC, |
[ProjNo] ASC,<br/> |
||
[DeptNo] ASC |
[DeptNo] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[StockSet]( |
CREATE TABLE [dbo].[StockSet](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[StockSetKey] [int] NOT NULL, |
[StockSetKey] [int] NOT NULL,<br/> |
||
[OpenStock] [dbo].[d_AccNo] NOT NULL, |
[OpenStock] [dbo].[d_AccNo] NOT NULL,<br/> |
||
[CloseStock] [dbo].[d_AccNo] NOT NULL, |
[CloseStock] [dbo].[d_AccNo] NOT NULL,<br/> |
||
[BalanceStock] [dbo].[d_AccNo] NOT NULL, |
[BalanceStock] [dbo].[d_AccNo] NOT NULL,<br/> |
||
CONSTRAINT [PK_StockSet] PRIMARY KEY NONCLUSTERED |
CONSTRAINT [PK_StockSet] PRIMARY KEY NONCLUSTERED<br/> |
||
( |
(<br/> |
||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[StockSetKey] ASC |
[StockSetKey] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[StockPBalance]( |
CREATE TABLE [dbo].[StockPBalance](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[StockSetKey] [int] NOT NULL, |
[StockSetKey] [int] NOT NULL,<br/> |
||
[PeriodNo] [dbo].[d_PeriodNo] NOT NULL, |
[PeriodNo] [dbo].[d_PeriodNo] NOT NULL,<br/> |
||
[ProjNo] [dbo].[d_Project] NULL, |
[ProjNo] [dbo].[d_Project] NULL,<br/> |
||
[DeptNo] [dbo].[d_Dept] NULL, |
[DeptNo] [dbo].[d_Dept] NULL,<br/> |
||
[Balance] [dbo].[d_Money] NULL |
[Balance] [dbo].[d_Money] NULL<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE NONCLUSTERED INDEX [IX_StockPBalance] ON [dbo].[StockPBalance] |
CREATE NONCLUSTERED INDEX [IX_StockPBalance] ON [dbo].[StockPBalance]<br/> |
||
(<br/> |
|||
( |
|||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[StockSetKey] ASC, |
[StockSetKey] ASC,<br/> |
||
[PeriodNo] ASC, |
[PeriodNo] ASC,<br/> |
||
[ProjNo] ASC, |
[ProjNo] ASC,<br/> |
||
[DeptNo] ASC |
[DeptNo] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[PBalance]( |
CREATE TABLE [dbo].[PBalance](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[PeriodNo] [dbo].[d_PeriodNo] NOT NULL, |
[PeriodNo] [dbo].[d_PeriodNo] NOT NULL,<br/> |
||
[AccNo] [dbo].[d_AccNo] NOT NULL, |
[AccNo] [dbo].[d_AccNo] NOT NULL,<br/> |
||
[ProjNo] [dbo].[d_Project] NULL, |
[ProjNo] [dbo].[d_Project] NULL,<br/> |
||
[DeptNo] [dbo].[d_Dept] NULL, |
[DeptNo] [dbo].[d_Dept] NULL,<br/> |
||
[DR] [dbo].[d_Money] NULL, |
[DR] [dbo].[d_Money] NULL,<br/> |
||
[CR] [dbo].[d_Money] NULL, |
[CR] [dbo].[d_Money] NULL,<br/> |
||
[HomeDR] [dbo].[d_Money] NULL, |
[HomeDR] [dbo].[d_Money] NULL,<br/> |
||
[HomeCR] [dbo].[d_Money] NULL |
[HomeCR] [dbo].[d_Money] NULL<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE NONCLUSTERED INDEX [IX_PBalance] ON [dbo].[PBalance] |
CREATE NONCLUSTERED INDEX [IX_PBalance] ON [dbo].[PBalance]<br/> |
||
(<br/> |
|||
( |
|||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[PeriodNo] ASC, |
[PeriodNo] ASC,<br/> |
||
[AccNo] ASC, |
[AccNo] ASC,<br/> |
||
[ProjNo] ASC, |
[ProjNo] ASC,<br/> |
||
[DeptNo] ASC |
[DeptNo] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[OBalance]( |
CREATE TABLE [dbo].[OBalance](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[PeriodNo] [dbo].[d_PeriodNo] NOT NULL, |
[PeriodNo] [dbo].[d_PeriodNo] NOT NULL,<br/> |
||
[AccNo] [dbo].[d_AccNo] NOT NULL, |
[AccNo] [dbo].[d_AccNo] NOT NULL,<br/> |
||
[ProjNo] [dbo].[d_Project] NULL, |
[ProjNo] [dbo].[d_Project] NULL,<br/> |
||
[DeptNo] [dbo].[d_Dept] NULL, |
[DeptNo] [dbo].[d_Dept] NULL,<br/> |
||
[DR] [dbo].[d_Money] NULL, |
[DR] [dbo].[d_Money] NULL,<br/> |
||
[CR] [dbo].[d_Money] NULL, |
[CR] [dbo].[d_Money] NULL,<br/> |
||
[HomeDR] [dbo].[d_Money] NULL, |
[HomeDR] [dbo].[d_Money] NULL,<br/> |
||
[HomeCR] [dbo].[d_Money] NULL |
[HomeCR] [dbo].[d_Money] NULL<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE NONCLUSTERED INDEX [IX_OBalance] ON [dbo].[OBalance] |
CREATE NONCLUSTERED INDEX [IX_OBalance] ON [dbo].[OBalance]<br/> |
||
(<br/> |
|||
( |
|||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[PeriodNo] ASC, |
[PeriodNo] ASC,<br/> |
||
[AccNo] ASC, |
[AccNo] ASC,<br/> |
||
[ProjNo] ASC, |
[ProjNo] ASC,<br/> |
||
[DeptNo] ASC |
[DeptNo] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[GLDTL]( |
CREATE TABLE [dbo].[GLDTL](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[GLDtlKey] [bigint] NOT NULL, |
[GLDtlKey] [bigint] NOT NULL,<br/> |
||
[AccNo] [dbo].[d_AccNo] NOT NULL, |
[AccNo] [dbo].[d_AccNo] NOT NULL,<br/> |
||
[DEAccNo] [dbo].[d_AccNo] NULL, |
[DEAccNo] [dbo].[d_AccNo] NULL,<br/> |
||
[ProjNo] [dbo].[d_Project] NULL, |
[ProjNo] [dbo].[d_Project] NULL,<br/> |
||
[DeptNo] [dbo].[d_Dept] NULL, |
[DeptNo] [dbo].[d_Dept] NULL,<br/> |
||
[CurrencyCode] [dbo].[d_CurrencyCode] NOT NULL, |
[CurrencyCode] [dbo].[d_CurrencyCode] NOT NULL,<br/> |
||
[CurrencyRate] [dbo].[d_CurrencyRate] NOT NULL, |
[CurrencyRate] [dbo].[d_CurrencyRate] NOT NULL,<br/> |
||
[ToHomeRate] [dbo].[d_CurrencyRate] NOT NULL, |
[ToHomeRate] [dbo].[d_CurrencyRate] NOT NULL,<br/> |
||
[OrgDR] [dbo].[d_Money] NULL, |
[OrgDR] [dbo].[d_Money] NULL,<br/> |
||
[OrgCR] [dbo].[d_Money] NULL, |
[OrgCR] [dbo].[d_Money] NULL,<br/> |
||
[DR] [dbo].[d_Money] NULL, |
[DR] [dbo].[d_Money] NULL,<br/> |
||
[CR] [dbo].[d_Money] NULL, |
[CR] [dbo].[d_Money] NULL,<br/> |
||
[HomeDR] [dbo].[d_Money] NULL, |
[HomeDR] [dbo].[d_Money] NULL,<br/> |
||
[HomeCR] [dbo].[d_Money] NULL, |
[HomeCR] [dbo].[d_Money] NULL,<br/> |
||
[TransDate] [datetime] NOT NULL, |
[TransDate] [datetime] NOT NULL,<br/> |
||
[Description] [dbo].[d_GLDescription] NULL, |
[Description] [dbo].[d_GLDescription] NULL,<br/> |
||
[RefNo1] [nvarchar](20) NULL, |
[RefNo1] [nvarchar](20) NULL,<br/> |
||
[RefNo2] [nvarchar](20) NULL, |
[RefNo2] [nvarchar](20) NULL,<br/> |
||
[DEKey] [bigint] NULL, |
[DEKey] [bigint] NULL,<br/> |
||
CONSTRAINT [PK_GLDTL] PRIMARY KEY NONCLUSTERED |
CONSTRAINT [PK_GLDTL] PRIMARY KEY NONCLUSTERED<br/> |
||
( |
(<br/> |
||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[GLDtlKey] ASC |
[GLDtlKey] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
CREATE TABLE [dbo].[FiscalYear]( |
CREATE TABLE [dbo].[FiscalYear](<br/> |
||
[AccountBookKey] [bigint] NOT NULL, |
[AccountBookKey] [bigint] NOT NULL,<br/> |
||
[FiscalYearName] [nvarchar](20) NOT NULL, |
[FiscalYearName] [nvarchar](20) NOT NULL,<br/> |
||
[FromDate] [datetime] NOT NULL, |
[FromDate] [datetime] NOT NULL,<br/> |
||
[ToDate] [datetime] NOT NULL, |
[ToDate] [datetime] NOT NULL,<br/> |
||
[IsActive] [dbo].[d_Boolean] NOT NULL, |
[IsActive] [dbo].[d_Boolean] NOT NULL,<br/> |
||
CONSTRAINT [PK_FiscalYear] PRIMARY KEY NONCLUSTERED |
CONSTRAINT [PK_FiscalYear] PRIMARY KEY NONCLUSTERED<br/> |
||
( |
(<br/> |
||
[AccountBookKey] ASC, |
[AccountBookKey] ASC,<br/> |
||
[FiscalYearName] ASC |
[FiscalYearName] ASC<br/> |
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br/> |
||
) ON [PRIMARY] |
) ON [PRIMARY]<br/> |
||
GO |
GO<br/> |
||
|} |
|} |
Latest revision as of 09:01, 28 February 2023
Question: When I try to open AutoCount Consolidate Financial Report, system prompted error “Invalid DDL Statement . . . Cannot find the object “dbo.ConsolidateProfile”. What should I do?
Version: 1.8 / 1.9 / 2.0
When click on OK
Click OK again another error prompted.
Possible Reason:
There is a missing table in your Consolidate database.
Solution:
1. Search and open SQL Management Studio from Windows search.
2. Connect SQL Server Management Studio.
3. Right click on AUTOCOUNT_CONSOLIDATE (for 1.9), AUTOCOUNT_CONSOLIDATE_V2 (for 2.0) and select New Query.
4. Paste the copy of below sql query.
EXEC sp_addtype N'd_AccType', N'nvarchar (2)' [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE TABLE [dbo].[AccGroup] ( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE TABLE [dbo].[AccType] ( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE TABLE [dbo].[GLMast]( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE TABLE [dbo].[AssetLink]( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE TABLE [dbo].[Project]( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE TABLE [dbo].[Dept]( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE TABLE [dbo].[Budget]( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE TABLE [dbo].[BudgetPBalance]( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_BudgetPBalance] ON [dbo].[BudgetPBalance] [AccountBookKey] ASC, )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] CREATE TABLE [dbo].[StockSet]( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE TABLE [dbo].[StockPBalance]( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_StockPBalance] ON [dbo].[StockPBalance] [AccountBookKey] ASC, )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] CREATE TABLE [dbo].[PBalance]( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_PBalance] ON [dbo].[PBalance] [AccountBookKey] ASC, )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] CREATE TABLE [dbo].[OBalance]( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_OBalance] ON [dbo].[OBalance] [AccountBookKey] ASC, )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] CREATE TABLE [dbo].[GLDTL]( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] CREATE TABLE [dbo].[FiscalYear]( [AccountBookKey] [bigint] NOT NULL, ) ON [PRIMARY] |
---|
5. Execute the sql query.
6. Now, you should be able to login AutoCount Consolidate.
Note: Please seek assistance from your software dealer if the problem persists after performing the suggested steps.
By: Aimi 230216, Lay Swan 230222, P230224
AutoCount Accounting 2.0 & 2.1
|
AutoCount Accounting 1.8 / 1.9
|
AutoCount Payroll
|
AutoCount POS
|
AutoCount On The Go
|
AutoCount Accounting Plug-In Documentations
|