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.