Prorata Calculation Using Dates

LeiCuntapay

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

SriNitya

@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