I want to install Microsoft Dynamics GP Dashboards, but when trying to run the Instructions for connecting the dashboard data to Microsoft Dynamics GP I get errors when running the script dashboardscript.sql.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Journal Entry' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Journal Entry For Drillback' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Account Index' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Account For Drillback Index' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Journal Entry' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Journal Entry For Drillback' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Account Index' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Account For Drillback Index' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Journal Entry' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Journal Entry For Drillback' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Account Index' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Account For Drillback Index' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Journal Entry' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Journal Entry For Drillback' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Account Index' is invalid.
Msg 207, Level 16, State 1, Procedure seeGLDebtToEquityDetail, Line 1
The column name 'Account For Drillback Index' is invalid.
Msg 15151, Level 16, State 1, Line 1
You can not find the 'seeGLDebtToEquityDetail' object because it does not exist or the user does not have permission.
How I can fix it?
*This post is locked for comments