So this is a multi-level question:
My company gives out no interest loans and sets up a promissory note to receive monthly payments until the loan is paid off. Right now I have “People” as a parent table to “Promissory” (each Person can have many Promissory Transactions). Each time a loan is set up, the loan amount is entered into a field called “loan amount”. Each time a client makes a payment, that amount is entered into a field called “payment amount”. (I'm open to changing this layout if you have a better idea)
1. I want a field to track the balance associated with each person.
2. Then I want a report that tells me when any person who still owes us hasn’t made a payment in 2 months (1 month past due).
3. Ideally I’d like it if that information (person-balance-last payment-last payment date) could automatically go into a form letter document that I could copy into an email or print off to physically mail. Maybe the email could even auto send...
I know this is relatively complex and I’m sure I could put several hours into it and figure it out, but I thought that maybe somebody could give me some pointers or point me towards a related article.
Thanks in advance.