Time: 12/08/2026 12:23:46 AM
PageName: DataTableResult
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='7/1/2026 12:00:00 AM'; SET @TDate=(SELECT SalaryToDate FROM FinancialMonthMaster WITH(nolock) WHERE SalaryFromDate=@FDate );  DECLARE @FTable TABLE ( SMId SMALLINT IDENTITY(1,1), BranchId VARCHAR(10), BranchName VARCHAR(50), EmployeeId VARCHAR(20), EmployeeName VARCHAR(50), NetPayable DECIMAL(10,2), LossOfPay DECIMAL(10,2), Arrear DECIMAL(10,2), Incentive DECIMAL(10,2), Advance DECIMAL(10,2), Deduction DECIMAL(10,2), LoanEMI DECIMAL(10,2), TotalPayment DECIMAL(10,2), TotalPayable DECIMAL(10,2), TotalDeduction DECIMAL(10,2), CTCSalary DECIMAL(10,2), SalaryOf1Day DECIMAL(10,2), BasicPay DECIMAL(10,2), Holiday DECIMAL(10,2), Leave DECIMAL(10,2), Present DECIMAL(10,2), Absent DECIMAL(10,2), Worked DECIMAL(10,2), SalaryPeriod VARCHAR(30), FromDate VARCHAR(20), ToDate VARCHAR(20), NoOfDay TINYINT, SalaryCreated VARCHAR(10), LeaveCalculated VARCHAR(10), JoiningDate VARCHAR(20), DepartmentName VARCHAR(50), DesignationName VARCHAR(50), EmployeeType VARCHAR(10)   );  INSERT INTO @FTable ( BranchId, BranchName, EmployeeId, EmployeeName, NetPayable, TotalPayment, TotalPayable, TotalDeduction, CTCSalary, BasicPay, SalaryPeriod, FromDate, ToDate, NoOfDay, SalaryCreated, JoiningDate, DepartmentName, DesignationName, EmployeeType ) SELECT b.BranchId, b.BranchName, b.EmployeeId, b.EmployeeName, a.NetPayable, a.TotalPayment, a.TotalPayable, a.TotalDeduction, a.CTCSalary, a.BasicPay, rtrim(convert(char,@FDate,103))+' - '+rtrim(convert(char,@TDate,103))AS SalaryPeriod, convert(char,@FDate,103)AS FromDate, convert(char,@TDate,103)AS ToDate, datediff(day,@FDate,@TDate)+1 AS NoOfDay, NULL AS SalaryCreated, convert(char,b.EmpJoinDate,103)AS JoiningDate, b.DepartmentName, b.DesignationName, b.EmployeeType FROM EmployeeSalaryMaster a WITH(nolock) INNER JOIN EmployeeRegistrationDetail b WITH(nolock) ON a.EmployeeId=b.EmployeeId WHERE b.SalaryStatus='Active' AND b.AttendanceStatus='Active'  ORDER BY b.BranchName, a.EmployeeName ;  DECLARE @TTable TABLE ( EmployeeId VARCHAR(20), AttDate DATETIME, AttValue DECIMAL(5,2), AttType VARCHAR(20) ); INSERT INTO @TTable ( EmployeeId, AttDate, AttValue, AttType ) SELECT a.EmployeeId, a.AttDate, a.AttValue, a.AttType FROM EmployeeAttendanceDetail a WITH(nolock) WHERE a.AttStatus='Approved' AND a.AttDate>=@FDate AND a.AttDate<dateadd(day,1,@TDate) ;  UPDATE a SET a.SalaryOf1Day=a.TotalPayment/a.NoOfDay, a.Holiday=isnull((SELECT count(1) FROM @TTable WHERE AttType='Holiday' AND EmployeeId=a.EmployeeId),0), a.Leave=isnull((SELECT count(1) FROM @TTable WHERE AttType='Leave' AND EmployeeId=a.EmployeeId),0), a.Present=isnull((SELECT count(1) FROM @TTable WHERE AttType='Present' AND EmployeeId=a.EmployeeId),0), a.Absent=isnull((SELECT SUM(AttValue) FROM @TTable WHERE AttType='Absent' AND EmployeeId=a.EmployeeId),0), a.LossOfPay=isnull((SELECT SUM(AttValue) FROM @TTable WHERE AttType='LossOfPay' AND EmployeeId=a.EmployeeId),0) FROM @FTable a ;  UPDATE a SET a.Worked=a.NoOfDay-a.LossOfPay, a.Arrear=0, a.Incentive=isnull((SELECT SUM(Credit-Debit) FROM EmployeeIncentiveLedger WITH(nolock) WHERE EmployeeId=a.EmployeeId),0), a.LoanEMI=0, a.Deduction=0, a.Advance=isnull((SELECT SUM(Credit-Debit) FROM EmployeeSalaryAdvance WITH(nolock) WHERE EmployeeId=a.EmployeeId),0), a.LeaveCalculated=(CASE WHEN a.Holiday+a.Leave+a.Present+LossOfPay=a.NoOfDay THEN 'Yes' ELSE 'No' END ), a.SalaryCreated=(CASE WHEN isnull((SELECT count(1) FROM EmployeeSalaryDetail WITH(nolock) WHERE ToDate>@FDate AND EmployeeId=a.EmployeeId),0)>0 THEN 'Yes' ELSE 'No' END ) FROM @FTable a ;  SELECT SMId, BranchName+' ('+BranchId+')' AS BranchIdName, EmployeeId, EmployeeName, NetPayable, LossOfPay, Arrear, Incentive, Advance, Deduction, LoanEMI, TotalPayment, TotalPayable, TotalDeduction, CTCSalary, SalaryOf1Day, BasicPay, Holiday, Leave, Present, Absent, Worked, SalaryPeriod, FromDate, ToDate, NoOfDay, SalaryCreated, LeaveCalculated, JoiningDate, DepartmentName, DesignationName, EmployeeType FROM @FTable ORDER BY BranchName, EmployeeName ; 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid object name 'EmployeeIncentiveLedger'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 12/08/2026 12:23:46 AM
PageName: Employee_EmployeeSalaryGenerate
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='7/1/2026 12:00:00 AM'; SET @TDate=(SELECT SalaryToDate FROM FinancialMonthMaster WITH(nolock) WHERE SalaryFromDate=@FDate );  DECLARE @FTable TABLE ( SMId SMALLINT IDENTITY(1,1), BranchId VARCHAR(10), BranchName VARCHAR(50), EmployeeId VARCHAR(20), EmployeeName VARCHAR(50), NetPayable DECIMAL(10,2), LossOfPay DECIMAL(10,2), Arrear DECIMAL(10,2), Incentive DECIMAL(10,2), Advance DECIMAL(10,2), Deduction DECIMAL(10,2), LoanEMI DECIMAL(10,2), TotalPayment DECIMAL(10,2), TotalPayable DECIMAL(10,2), TotalDeduction DECIMAL(10,2), CTCSalary DECIMAL(10,2), SalaryOf1Day DECIMAL(10,2), BasicPay DECIMAL(10,2), Holiday DECIMAL(10,2), Leave DECIMAL(10,2), Present DECIMAL(10,2), Absent DECIMAL(10,2), Worked DECIMAL(10,2), SalaryPeriod VARCHAR(30), FromDate VARCHAR(20), ToDate VARCHAR(20), NoOfDay TINYINT, SalaryCreated VARCHAR(10), LeaveCalculated VARCHAR(10), JoiningDate VARCHAR(20), DepartmentName VARCHAR(50), DesignationName VARCHAR(50), EmployeeType VARCHAR(10)   );  INSERT INTO @FTable ( BranchId, BranchName, EmployeeId, EmployeeName, NetPayable, TotalPayment, TotalPayable, TotalDeduction, CTCSalary, BasicPay, SalaryPeriod, FromDate, ToDate, NoOfDay, SalaryCreated, JoiningDate, DepartmentName, DesignationName, EmployeeType ) SELECT b.BranchId, b.BranchName, b.EmployeeId, b.EmployeeName, a.NetPayable, a.TotalPayment, a.TotalPayable, a.TotalDeduction, a.CTCSalary, a.BasicPay, rtrim(convert(char,@FDate,103))+' - '+rtrim(convert(char,@TDate,103))AS SalaryPeriod, convert(char,@FDate,103)AS FromDate, convert(char,@TDate,103)AS ToDate, datediff(day,@FDate,@TDate)+1 AS NoOfDay, NULL AS SalaryCreated, convert(char,b.EmpJoinDate,103)AS JoiningDate, b.DepartmentName, b.DesignationName, b.EmployeeType FROM EmployeeSalaryMaster a WITH(nolock) INNER JOIN EmployeeRegistrationDetail b WITH(nolock) ON a.EmployeeId=b.EmployeeId WHERE b.SalaryStatus='Active' AND b.AttendanceStatus='Active'  ORDER BY b.BranchName, a.EmployeeName ;  DECLARE @TTable TABLE ( EmployeeId VARCHAR(20), AttDate DATETIME, AttValue DECIMAL(5,2), AttType VARCHAR(20) ); INSERT INTO @TTable ( EmployeeId, AttDate, AttValue, AttType ) SELECT a.EmployeeId, a.AttDate, a.AttValue, a.AttType FROM EmployeeAttendanceDetail a WITH(nolock) WHERE a.AttStatus='Approved' AND a.AttDate>=@FDate AND a.AttDate<dateadd(day,1,@TDate) ;  UPDATE a SET a.SalaryOf1Day=a.TotalPayment/a.NoOfDay, a.Holiday=isnull((SELECT count(1) FROM @TTable WHERE AttType='Holiday' AND EmployeeId=a.EmployeeId),0), a.Leave=isnull((SELECT count(1) FROM @TTable WHERE AttType='Leave' AND EmployeeId=a.EmployeeId),0), a.Present=isnull((SELECT count(1) FROM @TTable WHERE AttType='Present' AND EmployeeId=a.EmployeeId),0), a.Absent=isnull((SELECT SUM(AttValue) FROM @TTable WHERE AttType='Absent' AND EmployeeId=a.EmployeeId),0), a.LossOfPay=isnull((SELECT SUM(AttValue) FROM @TTable WHERE AttType='LossOfPay' AND EmployeeId=a.EmployeeId),0) FROM @FTable a ;  UPDATE a SET a.Worked=a.NoOfDay-a.LossOfPay, a.Arrear=0, a.Incentive=isnull((SELECT SUM(Credit-Debit) FROM EmployeeIncentiveLedger WITH(nolock) WHERE EmployeeId=a.EmployeeId),0), a.LoanEMI=0, a.Deduction=0, a.Advance=isnull((SELECT SUM(Credit-Debit) FROM EmployeeSalaryAdvance WITH(nolock) WHERE EmployeeId=a.EmployeeId),0), a.LeaveCalculated=(CASE WHEN a.Holiday+a.Leave+a.Present+LossOfPay=a.NoOfDay THEN 'Yes' ELSE 'No' END ), a.SalaryCreated=(CASE WHEN isnull((SELECT count(1) FROM EmployeeSalaryDetail WITH(nolock) WHERE ToDate>@FDate AND EmployeeId=a.EmployeeId),0)>0 THEN 'Yes' ELSE 'No' END ) FROM @FTable a ;  SELECT SMId, BranchName+' ('+BranchId+')' AS BranchIdName, EmployeeId, EmployeeName, NetPayable, LossOfPay, Arrear, Incentive, Advance, Deduction, LoanEMI, TotalPayment, TotalPayable, TotalDeduction, CTCSalary, SalaryOf1Day, BasicPay, Holiday, Leave, Present, Absent, Worked, SalaryPeriod, FromDate, ToDate, NoOfDay, SalaryCreated, LeaveCalculated, JoiningDate, DepartmentName, DesignationName, EmployeeType FROM @FTable ORDER BY BranchName, EmployeeName ; 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_jusy4q5p
StackTrace:    at Employee_EmployeeSalaryGenerate.btnSearch_Click(Object sender, EventArgs e)
TargetSite: Void btnSearch_Click(System.Object, System.EventArgs)

Time: 12/08/2026 12:23:50 AM
PageName: DataTableResult
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='6/1/2026 12:00:00 AM'; SET @TDate=(SELECT SalaryToDate FROM FinancialMonthMaster WITH(nolock) WHERE SalaryFromDate=@FDate );  DECLARE @FTable TABLE ( SMId SMALLINT IDENTITY(1,1), BranchId VARCHAR(10), BranchName VARCHAR(50), EmployeeId VARCHAR(20), EmployeeName VARCHAR(50), NetPayable DECIMAL(10,2), LossOfPay DECIMAL(10,2), Arrear DECIMAL(10,2), Incentive DECIMAL(10,2), Advance DECIMAL(10,2), Deduction DECIMAL(10,2), LoanEMI DECIMAL(10,2), TotalPayment DECIMAL(10,2), TotalPayable DECIMAL(10,2), TotalDeduction DECIMAL(10,2), CTCSalary DECIMAL(10,2), SalaryOf1Day DECIMAL(10,2), BasicPay DECIMAL(10,2), Holiday DECIMAL(10,2), Leave DECIMAL(10,2), Present DECIMAL(10,2), Absent DECIMAL(10,2), Worked DECIMAL(10,2), SalaryPeriod VARCHAR(30), FromDate VARCHAR(20), ToDate VARCHAR(20), NoOfDay TINYINT, SalaryCreated VARCHAR(10), LeaveCalculated VARCHAR(10), JoiningDate VARCHAR(20), DepartmentName VARCHAR(50), DesignationName VARCHAR(50), EmployeeType VARCHAR(10)   );  INSERT INTO @FTable ( BranchId, BranchName, EmployeeId, EmployeeName, NetPayable, TotalPayment, TotalPayable, TotalDeduction, CTCSalary, BasicPay, SalaryPeriod, FromDate, ToDate, NoOfDay, SalaryCreated, JoiningDate, DepartmentName, DesignationName, EmployeeType ) SELECT b.BranchId, b.BranchName, b.EmployeeId, b.EmployeeName, a.NetPayable, a.TotalPayment, a.TotalPayable, a.TotalDeduction, a.CTCSalary, a.BasicPay, rtrim(convert(char,@FDate,103))+' - '+rtrim(convert(char,@TDate,103))AS SalaryPeriod, convert(char,@FDate,103)AS FromDate, convert(char,@TDate,103)AS ToDate, datediff(day,@FDate,@TDate)+1 AS NoOfDay, NULL AS SalaryCreated, convert(char,b.EmpJoinDate,103)AS JoiningDate, b.DepartmentName, b.DesignationName, b.EmployeeType FROM EmployeeSalaryMaster a WITH(nolock) INNER JOIN EmployeeRegistrationDetail b WITH(nolock) ON a.EmployeeId=b.EmployeeId WHERE b.SalaryStatus='Active' AND b.AttendanceStatus='Active'  ORDER BY b.BranchName, a.EmployeeName ;  DECLARE @TTable TABLE ( EmployeeId VARCHAR(20), AttDate DATETIME, AttValue DECIMAL(5,2), AttType VARCHAR(20) ); INSERT INTO @TTable ( EmployeeId, AttDate, AttValue, AttType ) SELECT a.EmployeeId, a.AttDate, a.AttValue, a.AttType FROM EmployeeAttendanceDetail a WITH(nolock) WHERE a.AttStatus='Approved' AND a.AttDate>=@FDate AND a.AttDate<dateadd(day,1,@TDate) ;  UPDATE a SET a.SalaryOf1Day=a.TotalPayment/a.NoOfDay, a.Holiday=isnull((SELECT count(1) FROM @TTable WHERE AttType='Holiday' AND EmployeeId=a.EmployeeId),0), a.Leave=isnull((SELECT count(1) FROM @TTable WHERE AttType='Leave' AND EmployeeId=a.EmployeeId),0), a.Present=isnull((SELECT count(1) FROM @TTable WHERE AttType='Present' AND EmployeeId=a.EmployeeId),0), a.Absent=isnull((SELECT SUM(AttValue) FROM @TTable WHERE AttType='Absent' AND EmployeeId=a.EmployeeId),0), a.LossOfPay=isnull((SELECT SUM(AttValue) FROM @TTable WHERE AttType='LossOfPay' AND EmployeeId=a.EmployeeId),0) FROM @FTable a ;  UPDATE a SET a.Worked=a.NoOfDay-a.LossOfPay, a.Arrear=0, a.Incentive=isnull((SELECT SUM(Credit-Debit) FROM EmployeeIncentiveLedger WITH(nolock) WHERE EmployeeId=a.EmployeeId),0), a.LoanEMI=0, a.Deduction=0, a.Advance=isnull((SELECT SUM(Credit-Debit) FROM EmployeeSalaryAdvance WITH(nolock) WHERE EmployeeId=a.EmployeeId),0), a.LeaveCalculated=(CASE WHEN a.Holiday+a.Leave+a.Present+LossOfPay=a.NoOfDay THEN 'Yes' ELSE 'No' END ), a.SalaryCreated=(CASE WHEN isnull((SELECT count(1) FROM EmployeeSalaryDetail WITH(nolock) WHERE ToDate>@FDate AND EmployeeId=a.EmployeeId),0)>0 THEN 'Yes' ELSE 'No' END ) FROM @FTable a ;  SELECT SMId, BranchName+' ('+BranchId+')' AS BranchIdName, EmployeeId, EmployeeName, NetPayable, LossOfPay, Arrear, Incentive, Advance, Deduction, LoanEMI, TotalPayment, TotalPayable, TotalDeduction, CTCSalary, SalaryOf1Day, BasicPay, Holiday, Leave, Present, Absent, Worked, SalaryPeriod, FromDate, ToDate, NoOfDay, SalaryCreated, LeaveCalculated, JoiningDate, DepartmentName, DesignationName, EmployeeType FROM @FTable ORDER BY BranchName, EmployeeName ; 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid object name 'EmployeeIncentiveLedger'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 12/08/2026 12:23:50 AM
PageName: Employee_EmployeeSalaryGenerate
String str:  DECLARE @FDate DATE, @TDate DATE; SET @FDate='6/1/2026 12:00:00 AM'; SET @TDate=(SELECT SalaryToDate FROM FinancialMonthMaster WITH(nolock) WHERE SalaryFromDate=@FDate );  DECLARE @FTable TABLE ( SMId SMALLINT IDENTITY(1,1), BranchId VARCHAR(10), BranchName VARCHAR(50), EmployeeId VARCHAR(20), EmployeeName VARCHAR(50), NetPayable DECIMAL(10,2), LossOfPay DECIMAL(10,2), Arrear DECIMAL(10,2), Incentive DECIMAL(10,2), Advance DECIMAL(10,2), Deduction DECIMAL(10,2), LoanEMI DECIMAL(10,2), TotalPayment DECIMAL(10,2), TotalPayable DECIMAL(10,2), TotalDeduction DECIMAL(10,2), CTCSalary DECIMAL(10,2), SalaryOf1Day DECIMAL(10,2), BasicPay DECIMAL(10,2), Holiday DECIMAL(10,2), Leave DECIMAL(10,2), Present DECIMAL(10,2), Absent DECIMAL(10,2), Worked DECIMAL(10,2), SalaryPeriod VARCHAR(30), FromDate VARCHAR(20), ToDate VARCHAR(20), NoOfDay TINYINT, SalaryCreated VARCHAR(10), LeaveCalculated VARCHAR(10), JoiningDate VARCHAR(20), DepartmentName VARCHAR(50), DesignationName VARCHAR(50), EmployeeType VARCHAR(10)   );  INSERT INTO @FTable ( BranchId, BranchName, EmployeeId, EmployeeName, NetPayable, TotalPayment, TotalPayable, TotalDeduction, CTCSalary, BasicPay, SalaryPeriod, FromDate, ToDate, NoOfDay, SalaryCreated, JoiningDate, DepartmentName, DesignationName, EmployeeType ) SELECT b.BranchId, b.BranchName, b.EmployeeId, b.EmployeeName, a.NetPayable, a.TotalPayment, a.TotalPayable, a.TotalDeduction, a.CTCSalary, a.BasicPay, rtrim(convert(char,@FDate,103))+' - '+rtrim(convert(char,@TDate,103))AS SalaryPeriod, convert(char,@FDate,103)AS FromDate, convert(char,@TDate,103)AS ToDate, datediff(day,@FDate,@TDate)+1 AS NoOfDay, NULL AS SalaryCreated, convert(char,b.EmpJoinDate,103)AS JoiningDate, b.DepartmentName, b.DesignationName, b.EmployeeType FROM EmployeeSalaryMaster a WITH(nolock) INNER JOIN EmployeeRegistrationDetail b WITH(nolock) ON a.EmployeeId=b.EmployeeId WHERE b.SalaryStatus='Active' AND b.AttendanceStatus='Active'  ORDER BY b.BranchName, a.EmployeeName ;  DECLARE @TTable TABLE ( EmployeeId VARCHAR(20), AttDate DATETIME, AttValue DECIMAL(5,2), AttType VARCHAR(20) ); INSERT INTO @TTable ( EmployeeId, AttDate, AttValue, AttType ) SELECT a.EmployeeId, a.AttDate, a.AttValue, a.AttType FROM EmployeeAttendanceDetail a WITH(nolock) WHERE a.AttStatus='Approved' AND a.AttDate>=@FDate AND a.AttDate<dateadd(day,1,@TDate) ;  UPDATE a SET a.SalaryOf1Day=a.TotalPayment/a.NoOfDay, a.Holiday=isnull((SELECT count(1) FROM @TTable WHERE AttType='Holiday' AND EmployeeId=a.EmployeeId),0), a.Leave=isnull((SELECT count(1) FROM @TTable WHERE AttType='Leave' AND EmployeeId=a.EmployeeId),0), a.Present=isnull((SELECT count(1) FROM @TTable WHERE AttType='Present' AND EmployeeId=a.EmployeeId),0), a.Absent=isnull((SELECT SUM(AttValue) FROM @TTable WHERE AttType='Absent' AND EmployeeId=a.EmployeeId),0), a.LossOfPay=isnull((SELECT SUM(AttValue) FROM @TTable WHERE AttType='LossOfPay' AND EmployeeId=a.EmployeeId),0) FROM @FTable a ;  UPDATE a SET a.Worked=a.NoOfDay-a.LossOfPay, a.Arrear=0, a.Incentive=isnull((SELECT SUM(Credit-Debit) FROM EmployeeIncentiveLedger WITH(nolock) WHERE EmployeeId=a.EmployeeId),0), a.LoanEMI=0, a.Deduction=0, a.Advance=isnull((SELECT SUM(Credit-Debit) FROM EmployeeSalaryAdvance WITH(nolock) WHERE EmployeeId=a.EmployeeId),0), a.LeaveCalculated=(CASE WHEN a.Holiday+a.Leave+a.Present+LossOfPay=a.NoOfDay THEN 'Yes' ELSE 'No' END ), a.SalaryCreated=(CASE WHEN isnull((SELECT count(1) FROM EmployeeSalaryDetail WITH(nolock) WHERE ToDate>@FDate AND EmployeeId=a.EmployeeId),0)>0 THEN 'Yes' ELSE 'No' END ) FROM @FTable a ;  SELECT SMId, BranchName+' ('+BranchId+')' AS BranchIdName, EmployeeId, EmployeeName, NetPayable, LossOfPay, Arrear, Incentive, Advance, Deduction, LoanEMI, TotalPayment, TotalPayable, TotalDeduction, CTCSalary, SalaryOf1Day, BasicPay, Holiday, Leave, Present, Absent, Worked, SalaryPeriod, FromDate, ToDate, NoOfDay, SalaryCreated, LeaveCalculated, JoiningDate, DepartmentName, DesignationName, EmployeeType FROM @FTable ORDER BY BranchName, EmployeeName ; 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: App_Web_jusy4q5p
StackTrace:    at Employee_EmployeeSalaryGenerate.btnSearch_Click(Object sender, EventArgs e)
TargetSite: Void btnSearch_Click(System.Object, System.EventArgs)

Time: 14/08/2026 04:17:01 PM
PageName: GroupLoan_PrintGroupLoanStatementSummaryHTML
String str:  DECLARE @ODate DATE, @LoanId VARCHAR(50); SET @ODate=GETDATE(); SET @LoanId='GL00002309' ; DECLARE @FTable TABLE ( LRNo INT IDENTITY(1,1), LoanId VARCHAR(50), Days VARCHAR(10), DDate DATE, DDay VARCHAR(10), DNo INT, PNo INT, Prin DECIMAL(10,2), Intt DECIMAL(10,2), Total DECIMAL(10,2), PrinBal DECIMAL(10,2), InttBal DECIMAL(10,2), TotalBal DECIMAL(10,2), PStatus VARCHAR(10), PayType VARCHAR(10), Settle VARCHAR(10), PDue DECIMAL(10,2), PPaid DECIMAL(10,2), Other DECIMAL(10,2), Saving DECIMAL(10,2), PDate DATE, VoucherId VARCHAR(20), PayMode VARCHAR(20), PayStatus VARCHAR(20), PayHeadId VARCHAR(20), PayTransId VARCHAR(20), PaidOfficerName VARCHAR(70), DueOfficerName VARCHAR(70), EntryDetail VARCHAR(50), NoOfDays INT, PenaltyAmount DECIMAL(10,2)  ) ;  INSERT INTO @FTable ( LoanId, DDate, DDay, DNo, PNo, Prin, Intt, Total, PStatus, PayType, Settle, PDue, PPaid, Other, Saving, PDate, VoucherId, PayMode, PayStatus, PayHeadId, PayTransId, PaidOfficerName, DueOfficerName, EntryDetail, PenaltyAmount ) SELECT a.LoanId, convert(CHAR,a.DDate,106)AS DDate, DateName(dw,a.DDate)AS DDay, a.DNo, a.PNo, a.Prin, a.Intt, a.Total, a.PStatus, a.PayType, a.Settle, a.PDue, a.PPaid, a.Other, a.Saving, convert(CHAR,a.PDate,106)AS PDate, a.VoucherId, a.PayMode, a.PayStatus, a.PayHeadId, a.PayTransId, isnull(a.DueOfficerName,'N/A')+' ('+isnull(a.DueOfficerId,'')+')'AS DueOfficerName, isnull(a.PaidOfficerName,'N/A')+' ('+isnull(a.PaidOfficerId,'')+')'AS PaidOfficerName, a.EntryUser+' on '+rtrim(Convert(CHAR,a.EntryTime,106))+' '+rtrim(Convert(CHAR,a.EntryTime,108))AS EntryDetail, dbo.funCalculateGroupLoanEMIPenalty(@ODate, a.LoanId, a.DDate, a.Total)AS PenaltyAmount FROM GroupLoanLedger a WITH(nolock) WHERE a.LoanId=@LoanId ORDER BY a.DNo, isnull(a.PNo,99)  ;  SELECT LRNo, Convert(CHAR,DDate,106)AS DDate, DDay, DNo, PNo, CASE WHEN isnull(Prin,0)>0 THEN Convert(CHAR,isnull(Prin,0)) ELSE '' END AS Prin, CASE WHEN isnull(Intt,0)>0 THEN Convert(CHAR,isnull(Intt,0)) ELSE '' END AS Intt, CASE WHEN isnull(Total,0)>0 THEN Convert(CHAR,isnull(Total,0)) ELSE '' END AS Total, isnull((SELECT SUM(isnull(Prin,0)) FROM @FTable WHERE LRNo>a.LRNo),0)AS PrinBal, isnull((SELECT SUM(isnull(Intt,0)) FROM @FTable WHERE LRNo>a.LRNo),0)AS InttBal, isnull((SELECT SUM(isnull(Total,0)) FROM @FTable WHERE LRNo>a.LRNo),0)AS TotalBal, PStatus, PayType, Settle, CASE WHEN PDue>0 THEN Convert(CHAR,isnull(PDue,0)) ELSE Convert(CHAR,isnull(PenaltyAmount,0)) END AS PDue, CASE WHEN isnull(PPaid,0)>0 THEN Convert(CHAR,isnull(PPaid,0)) ELSE '' END AS PPaid, CASE WHEN isnull(Other,0)>0 THEN Convert(CHAR,isnull(Other,0)) ELSE '' END AS Other, CASE WHEN isnull(Saving,0)>0 THEN Convert(CHAR,isnull(Saving,0)) ELSE '' END AS Saving, CASE WHEN PStatus='Paid' THEN convert(CHAR,isnull(Total,0)+isnull(PPaid,0)+isnull(Other,0)+isnull(Saving,0)) ELSE '' END AS TotalPaid, Convert(CHAR,PDate,106)AS PDate, VoucherId, isnull(Convert(char,datediff(day,(SELECT DDate FROM @FTable WHERE LRNo+1=a.LRNo AND DNo!=a.DNo),a.DDate)),'N/A')AS Days, PaidOfficerName, DueOfficerName, EntryDetail, isnull((SELECT Convert(CHAR,SUM(isnull(Prin,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PaidPrin, isnull((SELECT convert(CHAR,SUM(isnull(Intt,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PaidIntt, isnull((SELECT convert(CHAR,SUM(isnull(Total,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PaidTotal, isnull((SELECT convert(CHAR,SUM(isnull(PDue,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PenaltyTotal, isnull((SELECT convert(CHAR,SUM(isnull(PPaid,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PenaltyPaid, isnull((SELECT convert(CHAR,SUM(isnull(PDue,0)-isnull(PPaid,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PenaltyBalance, isnull((SELECT convert(CHAR,SUM(isnull(Prin,0))) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverduePrin, isnull((SELECT convert(CHAR,SUM(isnull(Intt,0))) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueIntt, isnull((SELECT convert(CHAR,SUM(isnull(Total,0))) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueTotal, isnull((SELECT convert(CHAR,COUNT(DISTINCT DNo)) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueNo, isnull((SELECT convert(CHAR,datediff(day,MIN(DDate),GETDATE())) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueDay, isnull((SELECT Convert(CHAR,MIN(DDate),106) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueDate, isnull((SELECT convert(CHAR,SUM(isnull(Prin,0))) FROM @FTable WHERE PStatus='Due'),'N/A')AS BalancePrin, isnull((SELECT convert(CHAR,SUM(isnull(Intt,0))) FROM @FTable WHERE PStatus='Due'),'N/A')AS BalanceIntt, isnull((SELECT convert(CHAR,SUM(isnull(Total,0))) FROM @FTable WHERE PStatus='Due'),'N/A')AS BalanceTotal, rtrim(convert(CHAR, b.LoanAmount))AS LoanAmount, rtrim(convert(CHAR, b.TotalInterest))AS TotalInterest, rtrim(convert(CHAR, b.TotalFee))AS TotalFee, rtrim(convert(CHAR, b.EMIAmount))AS EMIAmount, b.BranchName + ' (' + b.BranchId + ')' AS BranchName, b.LoanOfficerName + ' (' + b.LoanOfficerId + ')'AS LoanOfficerName, b.CenterName + ' (' + b.CenterId + ')'AS CenterName, b.MemberId, b.MemberName, b.MemberMobileNo, b.NomineeName, b.NomineeMobileNo, b.NomineeRelation, b.MemberAddress, a.LoanId, rtrim(convert(CHAR, b.LoanCycle))AS LoanCycle, convert(CHAR, b.DisburseDate, 106)AS DisburseDate, b.GLoanTypeNo,rtrim(convert(CHAR, b.LoanTerm)) + ' - ' + LoanTermMode AS LoanTermMode, b.LoanPurpose, b.LoanFunder, CASE WHEN b.LoanStatus = 'LoanDisbursed' THEN 'Active' ELSE 'Closed on ' + rtrim(convert(CHAR, b.CloseDate, 06)) END AS LoanStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyBannerURL')AS CompanyBannerURL FROM @FTable a INNER JOIN GroupLoanAccount b WITH(nolock)ON a.LoanId = b.LoanId ORDER BY LRNo  ; 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Column 'SrNo' does not belong to table .
Source: System.Data
StackTrace:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at GroupLoan_PrintGroupLoanStatementSummaryHTML.GroupLoanStatementDetail()
TargetSite: System.Data.DataColumn GetDataColumn(System.String)

Time: 14/08/2026 04:17:21 PM
PageName: GroupLoan_PrintGroupLoanStatementDetailHTML
String str:  DECLARE @ODate DATE, @LoanId VARCHAR(50); SET @ODate=GETDATE(); SET @LoanId='GL00002309' ; DECLARE @FTable TABLE ( LRNo INT IDENTITY(1,1), LoanId VARCHAR(50), Days VARCHAR(10), DDate DATE, DDay VARCHAR(10), DNo INT, PNo INT, Prin DECIMAL(10,2), Intt DECIMAL(10,2), Total DECIMAL(10,2), PrinBal DECIMAL(10,2), InttBal DECIMAL(10,2), TotalBal DECIMAL(10,2), PStatus VARCHAR(10), PayType VARCHAR(10), Settle VARCHAR(10), PDue DECIMAL(10,2), PPaid DECIMAL(10,2), Other DECIMAL(10,2), Saving DECIMAL(10,2), PDate DATE, VoucherId VARCHAR(20), PayMode VARCHAR(20), PayStatus VARCHAR(20), PayHeadId VARCHAR(20), PayTransId VARCHAR(20), PaidOfficerName VARCHAR(70), DueOfficerName VARCHAR(70), EntryDetail VARCHAR(50), NoOfDays INT, PenaltyAmount DECIMAL(10,2)  ) ;  INSERT INTO @FTable ( LoanId, DDate, DDay, DNo, PNo, Prin, Intt, Total, PStatus, PayType, Settle, PDue, PPaid, Other, Saving, PDate, VoucherId, PayMode, PayStatus, PayHeadId, PayTransId, PaidOfficerName, DueOfficerName, EntryDetail, PenaltyAmount ) SELECT a.LoanId, convert(CHAR,a.DDate,106)AS DDate, DateName(dw,a.DDate)AS DDay, a.DNo, a.PNo, a.Prin, a.Intt, a.Total, a.PStatus, a.PayType, a.Settle, a.PDue, a.PPaid, a.Other, a.Saving, convert(CHAR,a.PDate,106)AS PDate, a.VoucherId, a.PayMode, a.PayStatus, a.PayHeadId, a.PayTransId, isnull(a.DueOfficerName,'N/A')+' ('+isnull(a.DueOfficerId,'')+')'AS DueOfficerName, isnull(a.PaidOfficerName,'N/A')+' ('+isnull(a.PaidOfficerId,'')+')'AS PaidOfficerName, a.EntryUser+' on '+rtrim(Convert(CHAR,a.EntryTime,106))+' '+rtrim(Convert(CHAR,a.EntryTime,108))AS EntryDetail, dbo.funCalculateGroupLoanEMIPenalty(@ODate, a.LoanId, a.DDate, a.Total)AS PenaltyAmount  FROM GroupLoanLedger a WITH(nolock) WHERE a.LoanId=@LoanId ORDER BY a.DNo, isnull(a.PNo,99)  ;  SELECT LRNo, Convert(CHAR,DDate,106)AS DDate, DDay, DNo, PNo, CASE WHEN isnull(Prin,0)>0 THEN Convert(CHAR,isnull(Prin,0)) ELSE '' END AS Prin, CASE WHEN isnull(Intt,0)>0 THEN Convert(CHAR,isnull(Intt,0)) ELSE '' END AS Intt, CASE WHEN isnull(Total,0)>0 THEN Convert(CHAR,isnull(Total,0)) ELSE '' END AS Total, isnull((SELECT SUM(isnull(Prin,0)) FROM @FTable WHERE LRNo>a.LRNo),0)AS PrinBal, isnull((SELECT SUM(isnull(Intt,0)) FROM @FTable WHERE LRNo>a.LRNo),0)AS InttBal, isnull((SELECT SUM(isnull(Total,0)) FROM @FTable WHERE LRNo>a.LRNo),0)AS TotalBal, PStatus, PayType, Settle, CASE WHEN PDue>0 THEN Convert(CHAR,isnull(PDue,0)) ELSE Convert(CHAR,isnull(PenaltyAmount,0)) END AS PDue, CASE WHEN isnull(PPaid,0)>0 THEN Convert(CHAR,isnull(PPaid,0)) ELSE '' END AS PPaid, CASE WHEN isnull(Other,0)>0 THEN Convert(CHAR,isnull(Other,0)) ELSE '' END AS Other, CASE WHEN isnull(Saving,0)>0 THEN Convert(CHAR,isnull(Saving,0)) ELSE '' END AS Saving, CASE WHEN PStatus='Paid' THEN convert(CHAR,isnull(Total,0)+isnull(PPaid,0)+isnull(Other,0)+isnull(Saving,0)) ELSE '' END AS TotalPaid, Convert(CHAR,PDate,106)AS PDate, VoucherId, isnull(Convert(char,datediff(day,(SELECT DDate FROM @FTable WHERE LRNo+1=a.LRNo AND DNo!=a.DNo),a.DDate)),'N/A')AS Days, PaidOfficerName, DueOfficerName, EntryDetail, isnull((SELECT Convert(CHAR,SUM(isnull(Prin,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PaidPrin, isnull((SELECT convert(CHAR,SUM(isnull(Intt,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PaidIntt, isnull((SELECT convert(CHAR,SUM(isnull(Total,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PaidTotal, isnull((SELECT convert(CHAR,SUM(isnull(PDue,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PenaltyTotal, isnull((SELECT convert(CHAR,SUM(isnull(PPaid,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PenaltyPaid, isnull((SELECT convert(CHAR,SUM(isnull(PDue,0)-isnull(PPaid,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PenaltyBalance, isnull((SELECT convert(CHAR,SUM(isnull(Prin,0))) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverduePrin, isnull((SELECT convert(CHAR,SUM(isnull(Intt,0))) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueIntt, isnull((SELECT convert(CHAR,SUM(isnull(Total,0))) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueTotal, isnull((SELECT convert(CHAR,COUNT(DISTINCT DNo)) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueNo, isnull((SELECT convert(CHAR,datediff(day,MIN(DDate),GETDATE())) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueDay, isnull((SELECT Convert(CHAR,MIN(DDate),106) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueDate, isnull((SELECT convert(CHAR,SUM(isnull(Prin,0))) FROM @FTable WHERE PStatus='Due'),'N/A')AS BalancePrin, isnull((SELECT convert(CHAR,SUM(isnull(Intt,0))) FROM @FTable WHERE PStatus='Due'),'N/A')AS BalanceIntt, isnull((SELECT convert(CHAR,SUM(isnull(Total,0))) FROM @FTable WHERE PStatus='Due'),'N/A')AS BalanceTotal, rtrim(convert(CHAR, b.LoanAmount))AS LoanAmount, rtrim(convert(CHAR, b.TotalInterest))AS TotalInterest, rtrim(convert(CHAR, b.TotalFee))AS TotalFee, rtrim(convert(CHAR, b.EMIAmount))AS EMIAmount, b.BranchName + ' (' + b.BranchId + ')' AS BranchName, b.LoanOfficerName + ' (' + b.LoanOfficerId + ')'AS LoanOfficerName, b.CenterName + ' (' + b.CenterId + ')'AS CenterName, b.MemberId, b.MemberName, b.MemberMobileNo, b.NomineeName, b.NomineeMobileNo, b.NomineeRelation, b.MemberAddress, a.LoanId, rtrim(convert(CHAR, b.LoanCycle))AS LoanCycle, convert(CHAR, b.DisburseDate, 106)AS DisburseDate, b.GLoanTypeNo,rtrim(convert(CHAR, b.LoanTerm)) + ' - ' + LoanTermMode AS LoanTermMode, b.LoanPurpose, b.LoanFunder, CASE WHEN b.LoanStatus = 'LoanDisbursed' THEN 'Active' ELSE 'Closed on ' + rtrim(convert(CHAR, b.CloseDate, 06)) END AS LoanStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyBannerURL')AS CompanyBannerURL FROM @FTable a INNER JOIN GroupLoanAccount b WITH(nolock)ON a.LoanId = b.LoanId ORDER BY LRNo  ; 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Column 'SrNo' does not belong to table .
Source: System.Data
StackTrace:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at GroupLoan_PrintGroupLoanStatementDetailHTML.GroupLoanStatementDetail()
TargetSite: System.Data.DataColumn GetDataColumn(System.String)

Time: 14/08/2026 04:29:21 PM
PageName: GroupLoan_PrintGroupLoanStatementSummaryHTML
String str:  DECLARE @ODate DATE, @LoanId VARCHAR(50); SET @ODate=GETDATE(); SET @LoanId='GL00004300' ; DECLARE @FTable TABLE ( LRNo INT IDENTITY(1,1), LoanId VARCHAR(50), Days VARCHAR(10), DDate DATE, DDay VARCHAR(10), DNo INT, PNo INT, Prin DECIMAL(10,2), Intt DECIMAL(10,2), Total DECIMAL(10,2), PrinBal DECIMAL(10,2), InttBal DECIMAL(10,2), TotalBal DECIMAL(10,2), PStatus VARCHAR(10), PayType VARCHAR(10), Settle VARCHAR(10), PDue DECIMAL(10,2), PPaid DECIMAL(10,2), Other DECIMAL(10,2), Saving DECIMAL(10,2), PDate DATE, VoucherId VARCHAR(20), PayMode VARCHAR(20), PayStatus VARCHAR(20), PayHeadId VARCHAR(20), PayTransId VARCHAR(20), PaidOfficerName VARCHAR(70), DueOfficerName VARCHAR(70), EntryDetail VARCHAR(50), NoOfDays INT, PenaltyAmount DECIMAL(10,2)  ) ;  INSERT INTO @FTable ( LoanId, DDate, DDay, DNo, PNo, Prin, Intt, Total, PStatus, PayType, Settle, PDue, PPaid, Other, Saving, PDate, VoucherId, PayMode, PayStatus, PayHeadId, PayTransId, PaidOfficerName, DueOfficerName, EntryDetail, PenaltyAmount ) SELECT a.LoanId, convert(CHAR,a.DDate,106)AS DDate, DateName(dw,a.DDate)AS DDay, a.DNo, a.PNo, a.Prin, a.Intt, a.Total, a.PStatus, a.PayType, a.Settle, a.PDue, a.PPaid, a.Other, a.Saving, convert(CHAR,a.PDate,106)AS PDate, a.VoucherId, a.PayMode, a.PayStatus, a.PayHeadId, a.PayTransId, isnull(a.DueOfficerName,'N/A')+' ('+isnull(a.DueOfficerId,'')+')'AS DueOfficerName, isnull(a.PaidOfficerName,'N/A')+' ('+isnull(a.PaidOfficerId,'')+')'AS PaidOfficerName, a.EntryUser+' on '+rtrim(Convert(CHAR,a.EntryTime,106))+' '+rtrim(Convert(CHAR,a.EntryTime,108))AS EntryDetail, dbo.funCalculateGroupLoanEMIPenalty(@ODate, a.LoanId, a.DDate, a.Total)AS PenaltyAmount FROM GroupLoanLedger a WITH(nolock) WHERE a.LoanId=@LoanId ORDER BY a.DNo, isnull(a.PNo,99)  ;  SELECT LRNo, Convert(CHAR,DDate,106)AS DDate, DDay, DNo, PNo, CASE WHEN isnull(Prin,0)>0 THEN Convert(CHAR,isnull(Prin,0)) ELSE '' END AS Prin, CASE WHEN isnull(Intt,0)>0 THEN Convert(CHAR,isnull(Intt,0)) ELSE '' END AS Intt, CASE WHEN isnull(Total,0)>0 THEN Convert(CHAR,isnull(Total,0)) ELSE '' END AS Total, isnull((SELECT SUM(isnull(Prin,0)) FROM @FTable WHERE LRNo>a.LRNo),0)AS PrinBal, isnull((SELECT SUM(isnull(Intt,0)) FROM @FTable WHERE LRNo>a.LRNo),0)AS InttBal, isnull((SELECT SUM(isnull(Total,0)) FROM @FTable WHERE LRNo>a.LRNo),0)AS TotalBal, PStatus, PayType, Settle, CASE WHEN PDue>0 THEN Convert(CHAR,isnull(PDue,0)) ELSE Convert(CHAR,isnull(PenaltyAmount,0)) END AS PDue, CASE WHEN isnull(PPaid,0)>0 THEN Convert(CHAR,isnull(PPaid,0)) ELSE '' END AS PPaid, CASE WHEN isnull(Other,0)>0 THEN Convert(CHAR,isnull(Other,0)) ELSE '' END AS Other, CASE WHEN isnull(Saving,0)>0 THEN Convert(CHAR,isnull(Saving,0)) ELSE '' END AS Saving, CASE WHEN PStatus='Paid' THEN convert(CHAR,isnull(Total,0)+isnull(PPaid,0)+isnull(Other,0)+isnull(Saving,0)) ELSE '' END AS TotalPaid, Convert(CHAR,PDate,106)AS PDate, VoucherId, isnull(Convert(char,datediff(day,(SELECT DDate FROM @FTable WHERE LRNo+1=a.LRNo AND DNo!=a.DNo),a.DDate)),'N/A')AS Days, PaidOfficerName, DueOfficerName, EntryDetail, isnull((SELECT Convert(CHAR,SUM(isnull(Prin,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PaidPrin, isnull((SELECT convert(CHAR,SUM(isnull(Intt,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PaidIntt, isnull((SELECT convert(CHAR,SUM(isnull(Total,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PaidTotal, isnull((SELECT convert(CHAR,SUM(isnull(PDue,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PenaltyTotal, isnull((SELECT convert(CHAR,SUM(isnull(PPaid,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PenaltyPaid, isnull((SELECT convert(CHAR,SUM(isnull(PDue,0)-isnull(PPaid,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PenaltyBalance, isnull((SELECT convert(CHAR,SUM(isnull(Prin,0))) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverduePrin, isnull((SELECT convert(CHAR,SUM(isnull(Intt,0))) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueIntt, isnull((SELECT convert(CHAR,SUM(isnull(Total,0))) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueTotal, isnull((SELECT convert(CHAR,COUNT(DISTINCT DNo)) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueNo, isnull((SELECT convert(CHAR,datediff(day,MIN(DDate),GETDATE())) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueDay, isnull((SELECT Convert(CHAR,MIN(DDate),106) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueDate, isnull((SELECT convert(CHAR,SUM(isnull(Prin,0))) FROM @FTable WHERE PStatus='Due'),'N/A')AS BalancePrin, isnull((SELECT convert(CHAR,SUM(isnull(Intt,0))) FROM @FTable WHERE PStatus='Due'),'N/A')AS BalanceIntt, isnull((SELECT convert(CHAR,SUM(isnull(Total,0))) FROM @FTable WHERE PStatus='Due'),'N/A')AS BalanceTotal, rtrim(convert(CHAR, b.LoanAmount))AS LoanAmount, rtrim(convert(CHAR, b.TotalInterest))AS TotalInterest, rtrim(convert(CHAR, b.TotalFee))AS TotalFee, rtrim(convert(CHAR, b.EMIAmount))AS EMIAmount, b.BranchName + ' (' + b.BranchId + ')' AS BranchName, b.LoanOfficerName + ' (' + b.LoanOfficerId + ')'AS LoanOfficerName, b.CenterName + ' (' + b.CenterId + ')'AS CenterName, b.MemberId, b.MemberName, b.MemberMobileNo, b.NomineeName, b.NomineeMobileNo, b.NomineeRelation, b.MemberAddress, a.LoanId, rtrim(convert(CHAR, b.LoanCycle))AS LoanCycle, convert(CHAR, b.DisburseDate, 106)AS DisburseDate, b.GLoanTypeNo,rtrim(convert(CHAR, b.LoanTerm)) + ' - ' + LoanTermMode AS LoanTermMode, b.LoanPurpose, b.LoanFunder, CASE WHEN b.LoanStatus = 'LoanDisbursed' THEN 'Active' ELSE 'Closed on ' + rtrim(convert(CHAR, b.CloseDate, 06)) END AS LoanStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyBannerURL')AS CompanyBannerURL FROM @FTable a INNER JOIN GroupLoanAccount b WITH(nolock)ON a.LoanId = b.LoanId ORDER BY LRNo  ; 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Column 'SrNo' does not belong to table .
Source: System.Data
StackTrace:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at GroupLoan_PrintGroupLoanStatementSummaryHTML.GroupLoanStatementDetail()
TargetSite: System.Data.DataColumn GetDataColumn(System.String)

Time: 14/08/2026 04:36:48 PM
PageName: GroupLoan_PrintGroupLoanStatementSummaryHTML
String str:  DECLARE @ODate DATE, @LoanId VARCHAR(50); SET @ODate=GETDATE(); SET @LoanId='GL00004300' ; DECLARE @FTable TABLE ( LRNo INT IDENTITY(1,1), LoanId VARCHAR(50), Days VARCHAR(10), DDate DATE, DDay VARCHAR(10), DNo INT, PNo INT, Prin DECIMAL(10,2), Intt DECIMAL(10,2), Total DECIMAL(10,2), PrinBal DECIMAL(10,2), InttBal DECIMAL(10,2), TotalBal DECIMAL(10,2), PStatus VARCHAR(10), PayType VARCHAR(10), Settle VARCHAR(10), PDue DECIMAL(10,2), PPaid DECIMAL(10,2), Other DECIMAL(10,2), Saving DECIMAL(10,2), PDate DATE, VoucherId VARCHAR(20), PayMode VARCHAR(20), PayStatus VARCHAR(20), PayHeadId VARCHAR(20), PayTransId VARCHAR(20), PaidOfficerName VARCHAR(70), DueOfficerName VARCHAR(70), EntryDetail VARCHAR(50), NoOfDays INT, PenaltyAmount DECIMAL(10,2)  ) ;  INSERT INTO @FTable ( LoanId, DDate, DDay, DNo, PNo, Prin, Intt, Total, PStatus, PayType, Settle, PDue, PPaid, Other, Saving, PDate, VoucherId, PayMode, PayStatus, PayHeadId, PayTransId, PaidOfficerName, DueOfficerName, EntryDetail, PenaltyAmount ) SELECT a.LoanId, convert(CHAR,a.DDate,106)AS DDate, DateName(dw,a.DDate)AS DDay, a.DNo, a.PNo, a.Prin, a.Intt, a.Total, a.PStatus, a.PayType, a.Settle, a.PDue, a.PPaid, a.Other, a.Saving, convert(CHAR,a.PDate,106)AS PDate, a.VoucherId, a.PayMode, a.PayStatus, a.PayHeadId, a.PayTransId, isnull(a.DueOfficerName,'N/A')+' ('+isnull(a.DueOfficerId,'')+')'AS DueOfficerName, isnull(a.PaidOfficerName,'N/A')+' ('+isnull(a.PaidOfficerId,'')+')'AS PaidOfficerName, a.EntryUser+' on '+rtrim(Convert(CHAR,a.EntryTime,106))+' '+rtrim(Convert(CHAR,a.EntryTime,108))AS EntryDetail, dbo.funCalculateGroupLoanEMIPenalty(@ODate, a.LoanId, a.DDate, a.Total)AS PenaltyAmount FROM GroupLoanLedger a WITH(nolock) WHERE a.LoanId=@LoanId ORDER BY a.DNo, isnull(a.PNo,99)  ;  SELECT LRNo, Convert(CHAR,DDate,106)AS DDate, DDay, DNo, PNo, CASE WHEN isnull(Prin,0)>0 THEN Convert(CHAR,isnull(Prin,0)) ELSE '' END AS Prin, CASE WHEN isnull(Intt,0)>0 THEN Convert(CHAR,isnull(Intt,0)) ELSE '' END AS Intt, CASE WHEN isnull(Total,0)>0 THEN Convert(CHAR,isnull(Total,0)) ELSE '' END AS Total, isnull((SELECT SUM(isnull(Prin,0)) FROM @FTable WHERE LRNo>a.LRNo),0)AS PrinBal, isnull((SELECT SUM(isnull(Intt,0)) FROM @FTable WHERE LRNo>a.LRNo),0)AS InttBal, isnull((SELECT SUM(isnull(Total,0)) FROM @FTable WHERE LRNo>a.LRNo),0)AS TotalBal, PStatus, PayType, Settle, CASE WHEN PDue>0 THEN Convert(CHAR,isnull(PDue,0)) ELSE Convert(CHAR,isnull(PenaltyAmount,0)) END AS PDue, CASE WHEN isnull(PPaid,0)>0 THEN Convert(CHAR,isnull(PPaid,0)) ELSE '' END AS PPaid, CASE WHEN isnull(Other,0)>0 THEN Convert(CHAR,isnull(Other,0)) ELSE '' END AS Other, CASE WHEN isnull(Saving,0)>0 THEN Convert(CHAR,isnull(Saving,0)) ELSE '' END AS Saving, CASE WHEN PStatus='Paid' THEN convert(CHAR,isnull(Total,0)+isnull(PPaid,0)+isnull(Other,0)+isnull(Saving,0)) ELSE '' END AS TotalPaid, Convert(CHAR,PDate,106)AS PDate, VoucherId, isnull(Convert(char,datediff(day,(SELECT DDate FROM @FTable WHERE LRNo+1=a.LRNo AND DNo!=a.DNo),a.DDate)),'N/A')AS Days, PaidOfficerName, DueOfficerName, EntryDetail, isnull((SELECT Convert(CHAR,SUM(isnull(Prin,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PaidPrin, isnull((SELECT convert(CHAR,SUM(isnull(Intt,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PaidIntt, isnull((SELECT convert(CHAR,SUM(isnull(Total,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PaidTotal, isnull((SELECT convert(CHAR,SUM(isnull(PDue,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PenaltyTotal, isnull((SELECT convert(CHAR,SUM(isnull(PPaid,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PenaltyPaid, isnull((SELECT convert(CHAR,SUM(isnull(PDue,0)-isnull(PPaid,0))) FROM @FTable WHERE PStatus='Paid'),'N/A')AS PenaltyBalance, isnull((SELECT convert(CHAR,SUM(isnull(Prin,0))) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverduePrin, isnull((SELECT convert(CHAR,SUM(isnull(Intt,0))) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueIntt, isnull((SELECT convert(CHAR,SUM(isnull(Total,0))) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueTotal, isnull((SELECT convert(CHAR,COUNT(DISTINCT DNo)) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueNo, isnull((SELECT convert(CHAR,datediff(day,MIN(DDate),GETDATE())) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueDay, isnull((SELECT Convert(CHAR,MIN(DDate),106) FROM @FTable WHERE DDate<GETDATE() AND PStatus='Due'),'N/A')AS OverdueDate, isnull((SELECT convert(CHAR,SUM(isnull(Prin,0))) FROM @FTable WHERE PStatus='Due'),'N/A')AS BalancePrin, isnull((SELECT convert(CHAR,SUM(isnull(Intt,0))) FROM @FTable WHERE PStatus='Due'),'N/A')AS BalanceIntt, isnull((SELECT convert(CHAR,SUM(isnull(Total,0))) FROM @FTable WHERE PStatus='Due'),'N/A')AS BalanceTotal, rtrim(convert(CHAR, b.LoanAmount))AS LoanAmount, rtrim(convert(CHAR, b.TotalInterest))AS TotalInterest, rtrim(convert(CHAR, b.TotalFee))AS TotalFee, rtrim(convert(CHAR, b.EMIAmount))AS EMIAmount, b.BranchName + ' (' + b.BranchId + ')' AS BranchName, b.LoanOfficerName + ' (' + b.LoanOfficerId + ')'AS LoanOfficerName, b.CenterName + ' (' + b.CenterId + ')'AS CenterName, b.MemberId, b.MemberName, b.MemberMobileNo, b.NomineeName, b.NomineeMobileNo, b.NomineeRelation, b.MemberAddress, a.LoanId, rtrim(convert(CHAR, b.LoanCycle))AS LoanCycle, convert(CHAR, b.DisburseDate, 106)AS DisburseDate, b.GLoanTypeNo,rtrim(convert(CHAR, b.LoanTerm)) + ' - ' + LoanTermMode AS LoanTermMode, b.LoanPurpose, b.LoanFunder, CASE WHEN b.LoanStatus = 'LoanDisbursed' THEN 'Active' ELSE 'Closed on ' + rtrim(convert(CHAR, b.CloseDate, 06)) END AS LoanStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName = 'CompanyBannerURL')AS CompanyBannerURL FROM @FTable a INNER JOIN GroupLoanAccount b WITH(nolock)ON a.LoanId = b.LoanId ORDER BY LRNo  ; 
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Column 'SrNo' does not belong to table .
Source: System.Data
StackTrace:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at GroupLoan_PrintGroupLoanStatementSummaryHTML.GroupLoanStatementDetail()
TargetSite: System.Data.DataColumn GetDataColumn(System.String)