Ineterst Calculations

[dbant2003]

I am wondering if anyone has a suggestion on how to perform interest calculations. ACCPAC is not able to calculate interest in the method we would like it to do. We have a terms setup that invoices are due by the end of the following month, the 30th of the month following. If the customer doesn't pay by the end of the next month then we would want interest to calculated if still overdue in the next period using the whole month instead of the due date. This is somewhat of having a retroactive charge but not back to the document date. I have tried a few things but nothing seems to work well enough for me to suggest us make that change. I am considering designing a macro that will look at invoice due dates to change them to the first of the month for invoices not paid by the end of the due date period and still unpaid next month. Could soemone suggest something for us to do or had a similar sitaution and how you were to solve it.