how to generate loan balance sheet totalamt,paidamt,total

Question

how to generate loan balance sheet totalamt,paidamt,totalInstalment,balanceinstalment,balanceamt calculation in sql how

Madhan M · Answer

I tired to sum the colum in PaidAmt,and balanceAmt,BalanceInstal, select R.C_Employeecode,E.C_EmployeeName,R.C_Loancode,L.F_Loan_Amt as Total_Amt,L.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_Employeecode,E.C_EmployeeName,R.C_LoanCode,R.F_Amount,F_Loan_Amt,l.F_No_Of_Installment,I_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 Amt,And 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

Answers (4)