I would like to add in my customer reminders of the outstanding invoices, a field with the number of outstanding due days (sum of days), and a interest caclulation. How can I best do that. Example: Invoice amount: 1000 Due date: 01/01/2006 Date reminder: 15/01/2006 Outstanding days: 15 Interest: 1000 * 7% *15/360 = 2,91 Invoice Duedate Outstanding Interest 1000€ 01/01/2006 15 2,91 €
Hi Can you not use the finance charge funcitonality, this will create the interst entry as you require. The “day” you will still need to design on the report, and someone else will need to answer that [:D]
quote:
I would like to add in my customer reminders of the outstanding invoices, a field with the number of outstanding due days (sum of days), and a interest caclulation. How can I best do that. Example: Invoice amount: 1000 Due date: 01/01/2006 Date reminder: 15/01/2006 Outstanding days: 15 Interest: 1000 * 7% *15/360 = 2,91 Invoice Duedate Outstanding Interest 1000€ 01/01/2006 15 2,91 €
Originally posted by mutse - 2006 Mar 23 : 07:23:11
“Outstanding Days” := WORKDATE - “Due Date”; Anna