Sarah
|
| Posted: 08/18/2002, 1:12 PM |
|
I am wanting to make a billing system for a learning project using php & mysql. It will send monthly bills to my clients through email. I would like to post payments to the database and have the payment show or say past due for the month. I'm at a loss as to where to begin. I haven't been able to find a tutorial online. Any thoughts?
TIA
|
|
|
 |
James
|
| Posted: 08/19/2002, 8:55 AM |
|
know
|
|
|
|
Ron Mahon
|
| Posted: 08/19/2002, 9:50 AM |
|
I suggest you set up a database profile for each customer. The file should contain the detail of the charges and link to a customer file for name address etc. and a flag for last date this customer was processed.
This update would populate an AR record for each customer in the billing file
That way you only have to run a program against this file once a per billing period. That way if the charges change you only have to update the billing record (S).
Other enhancements to think about are tracking the number of charges. I.e. if the course sells for $x.00 with 12 easy payments you need to know when to exclude this record from further update.
I used this for cable TV and water billing.
Good luck
Ron
|
|
|
|
Sarah
|
| Posted: 08/19/2002, 5:37 PM |
|
Thanks Ron, you've given me some ideas of where to start!
|
|
|
|
