how to generate loan balance sheet totalamtpaidamttotal

Question

how to generate loan balance sheet totalamtpaidamttotalInstalmentbalanceinstalmentbalanceamt calculation in sql how

Madhan M · Answer

I tired to sum the colum in PaidAmtand balanceAmtBalanceInstal select R.C_EmployeecodeE.C_EmployeeNameR.C_LoancodeL.F_Loan_Amt as Total_AmtL.F_No_Of_Installment as 'Total_Inst'R.I_INSNO as 'PaidInsta' (R.F_Amount)As 'MonInstal' (L.F_Loan_Amt /(L.F_No_Of_Installment) * (R.I_INSNO)) as 'PaidAmt' (L.F_Loan_Amt - (L.F_Loan_Amt /(L.F_No_Of_Installment) * (R.I_INSNO))) as 'BalanceAmt' --L.F_Loan_Amt-ISNULL((R.F_Amount)0) As 'Balance_Amt' L.F_No_Of_Installment-(R.I_INSNO) As 'BalInstal' ----CEILING((L.F_No_Of_Installment-ISNULL(SUM(R.I_INSNO)0))/(L.F_No_Of_Installment*1.))'Balance.Instal' from Loan_recovery R join LoanAvail_Entry L On R.C_Employeecode=L.C_Employeecode join Employee E on R.C_Employeecode=E.C_EmployeeCode where L.C_MMYYYY GROUP BY R.C_EmployeecodeE.C_EmployeeNameR.C_LoanCodeR.F_AmountF_Loan_Amtl.F_No_Of_InstallmentI_INSNO

Madhan M · Answer

Colum Names Are Two Tables C_Employeecode C_EmployeeName C_Loancode  Total_Amt Total_Inst  PaidInsta MonInstal PaidAmt  BalanceAmt BalInstal 50173 KAVITHAMOL .S PL 20000 10 1 2000 2000 18000 9 50173 KAVITHAMOL .S PL 20000 10 2 2000 4000 16000 8 50173 KAVITHAMOL .S PL 20000 10 3 2000 6000 14000 7 50173 KAVITHAMOL .S PL 20000 10 4 2000 8000 12000 6 50173 KAVITHAMOL .S PL 20000 10 5 2000 10000 10000 5 50173 KAVITHAMOL .S PL 20000 10 6 2000 12000 8000 4 50173 KAVITHAMOL .S PL 20000 10 7 2000 14000 6000 3 50173 KAVITHAMOL .S PL 20000 10 8 2000 16000 4000 2 50173 KAVITHAMOL .S PL 20000 10 9 2000 18000 2000 1 50173 KAVITHAMOL .S PL 20000 10 10 2000 20000 0 0

Madhan M · Answer

Each Employee Yearly Twice In Loan So Single Line Results in Each Loan Amt i need given Year Its Complete or Remain Balance Show in my record Its Posible to This Query I Have To Sum In Paid Amt In PArticular Employee Its Added all the Amount In All Loan How Filter In the PAid AmtAnd Balance INstalments Details

Rajkiran Swain · Answer

https://stackoverflow.com/questions/37177936/calculate-balance-sheet-with-fastest-algorithm

how to generate loan balance sheet totalamt,paidamt,total