Hi
Can anyone suggest me any readymade script or CRM etc for the following requirements
This will be a browser based online system, with login facility for the system admin and users.
a) database of few hundred members
b) on 7th day of each month a query will be run to check who has paid their monthly bill. Somebody will manually fill that data by 6th
c) On 8th someone run a query to find the names and details of the defaulters let's say 25 members have not paid their dues. A report can be generated as to who this person is, person id, address/contact details and amount due.
d) a standard letter of request or legal notice (already in a template format) can be created with personalised info i.e. a standard legal notice with the defaulters details (like a personalised newletter) can be generated which can be sent via email or printed and send via post or fax etc
Although it sounds simple it is also complex.
Any suggestions?
Many thanks in advanace.
Can anyone suggest me any readymade script or CRM etc for the following requirements
This will be a browser based online system, with login facility for the system admin and users.
a) database of few hundred members
b) on 7th day of each month a query will be run to check who has paid their monthly bill. Somebody will manually fill that data by 6th
c) On 8th someone run a query to find the names and details of the defaulters let's say 25 members have not paid their dues. A report can be generated as to who this person is, person id, address/contact details and amount due.
d) a standard letter of request or legal notice (already in a template format) can be created with personalised info i.e. a standard legal notice with the defaulters details (like a personalised newletter) can be generated which can be sent via email or printed and send via post or fax etc
Although it sounds simple it is also complex.
Any suggestions?
Many thanks in advanace.