D
dbain30
I'm attempting to create a report that will provide our customers with
an account history and accrual information. So far I've created a
report that list all of the transactions and has a running balance
however I'm having trouble in calculating the accrual.
Each transaction is posted with an Effective From date, the issue is
that in order to calculate interest you must be able to calculate the #
of days in that period. The only way to do that is to look at the date
of the next transaction and calculate the difference between the two.
Since these are two records on the same table, and will change each
time we run the report, I have yet to figure out how to accomplish this
task.
A second issue is that most of the transactions are principal, interest
and fee payments. For these items I would need the interest rate from
the previous transaction to flow down unless the transaction is a rate
change, then it should remain as is and then follow the same logic for
remaining transactions.
Any help that you can offer would be greatly appreciated!
an account history and accrual information. So far I've created a
report that list all of the transactions and has a running balance
however I'm having trouble in calculating the accrual.
Each transaction is posted with an Effective From date, the issue is
that in order to calculate interest you must be able to calculate the #
of days in that period. The only way to do that is to look at the date
of the next transaction and calculate the difference between the two.
Since these are two records on the same table, and will change each
time we run the report, I have yet to figure out how to accomplish this
task.
A second issue is that most of the transactions are principal, interest
and fee payments. For these items I would need the interest rate from
the previous transaction to flow down unless the transaction is a rate
change, then it should remain as is and then follow the same logic for
remaining transactions.
Any help that you can offer would be greatly appreciated!