| Description |
We are getting below error while upgrading customer i21 application from 14.4v to 15.3v.
Error SQL72014: .Net SqlClient Data Provider: Msg 207, Level 16, State 1, Procedure uspGLGetAccountDetailReport, Line 192 Invalid column name 'Location'.
Error SQL72045: Script execution error. The executed script:
CREATE PROCEDURE [dbo].[uspGLGetAccountDetailReport]
@xmlParam NVARCHAR (MAX)=''
AS
BEGIN
SET NOCOUNT ON;
IF (ISNULL(@xmlParam, '') = '')
BEGIN
SELECT DISTINCT '' AS AccountHeader,
'' AS strAccountDescripion,
'' AS strAccountType,
'' AS strAccountGroup,
getdate() AS dtmDate,
'' AS strBatchId,
0.0 AS dblDebit,
0.0 AS dblCredit,
0.0 AS dblDebitUnit,
0.0 AS dblCreditUnit,
'' AS strDetailDescription,
'' AS strTransactionId,
0 AS intTransactionId,
'' AS strTransactionType,
'' AS strTransactionForm,
'' AS strModuleName,
'' AS
|