Can I add code to a rptInvoice to compute interest to the amount o

  • Thread starter Thread starter DMainland
  • Start date Start date
D

DMainland

I use a rptInvoice to bill my customers. I would like to be able to add some
code to the report that would compute interest on the amount owed as the
receiveable remains unpaid. The interest would probably be added on a
monthly basis (1/12th of a year) to reflect an annual rate. I would like the
time frame to be based on the DateInvoice field and the interest be added
automatically to the amount owed on a monthly basis if possible. Any help
would be greatly appreciated.
 
It is possible to put a calculated field on a report, e.g. a charge 7.25% on
the Amount field would be:
=[Amount] * .0725

However, what you are proposing is probably to complex to do in that way. If
you are planning to add charges at specific times (e.g. end of each month),
at specific rates (which may change over time), based on the daily balance
(not merely the end of month), you will need a table to *store* these
charges in, and some code to calculate the charges and assign them to the
table. Your report would then show the charges calculated in the table.

That's the only way you will get this to be consistent.
 
Back
Top