Hi All,
Working in EBS version 12.2.12
Actually i trying create loan request form report, the user will enter from which date, loan amount
example
date 01-AUG-2025
Loan Amount : 13000
total package 4510
monthly deduction : 4510*.20 = 902
for 15 months : 13000/902 = 14.41 equal to 15 months
i need to show 15 with deduction amount with every month balance
the report output is
emp no emp name basic_salary, transportation, housing loan_deduction (every month) balance
Month
Period
Description
Amount
Balance
1
Aug-25
Deduction
-902
12,098
2
Sep-25
Deduction
-902
11,196
3
Oct-25
Deduction
-902
10,294
4
Nov-25
Deduction
-902
9,392
5
Dec-25
Deduction
-902
8,490
6
Jan-26
Deduction
-902
7,588
7
Feb-26
Deduction
-902
6,686
8
Mar-26
Deduction
-902
5,784
9
Apr-26
Deduction
-902
4,882
10
May-26
Deduction
-902
3,980
11
Jun-26
Deduction
-902
3,078
12
Jul-26
Deduction
-902
2,176
13
Aug-26
Deduction
-902
1,274
14
Sep-26
Deduction
-902
372
15
Oct-26
Deduction
-372
-
please i need help to achieve this
Regards