Prorata Calculation Using Dates

Question

Almost done with my module. I need help in developing a formula to compute the monthly amortization that looks at dates.

SriNitya · Accepted Answer

@LeiCuntapay

create boolean line items for start period, end period and middle periods and populate the booleans. By using the boolean line items you calculate as shown below

start period line item→ if start boolean then Amount spread* Active days/ No.of days

middle period  line item → if middle boolean then Amount spread else 0

start + Middle  line item →  start period+ middle period ( start & middle period data in single line item, keep summary method SUM)

end period  line item → if end boolean then amount- TIMESUM(start+ middle) else start + Middle

so end period line item gives you the monthly amortization.

By using individual lineitems or by merging the logics in single line item you can do this

Hope this helps.

Sri Nitya