Billing table where code_type is COPAY

markleeds wrote on Friday, February 10, 2006:

Would it mess anything up to use the code_text column of this table to record what method of payment was used?

It looks like right now all that goes in there is the redundant word ‘copay’ which is already in the code_type column as ‘COPAY’.

I would like to record here if the patient paid with cash, credit card, check, or other.

I want to add a set of radio buttons where you type in the copay to allow for the recording of payment method.  This way, I can later generate those reports that show the breakdown of cash, credit card and check payments for the day.

markleeds wrote on Friday, February 10, 2006:

From the time I wrote the last message, I got to work and put it in.  The radio buttons and the change to add the payment method to the database.  It is really beautiful.  It was a matter of a few lines in copay.php and a single variable name change in diagnosis.php.  The existing code is so simple and sensible, it worked out perfectly.

My only concern is if the code_text column of the billing table is used elsewhere.  I doubt it, but you never know.

I’ll post the changed files at http://drleeds.com/files/payment.tar.gz if anyone wants to play around with it.

sunsetsystems wrote on Saturday, February 11, 2006:

I think this is a good idea and should be fine.

You might also want to  take a look at interface/patient_file/front_payment.php which I created at the request of a client to track receipts at the front window before the encounter is created, and for past encounters (i.e. someone walks in to pay off a past balance).  A good project would be to enhance this to automate posting this into the billing table or to SQL-Ledger, as appropriate.

– Rod
www.sunsetsystems.com

markleeds wrote on Sunday, February 12, 2006:

here’s some screen shots:
http://drleeds.com/screenshots

I’ll type up some explanation later.

sunsetsystems wrote on Sunday, February 12, 2006:

Looks nice!  Are your code changes general enough to be put into CVS (i.e. not specific to your practice)?  If so I would be happy to commit them.

– Rod
www.sunsetsystems.com

markleeds wrote on Monday, February 13, 2006:

Everything is completely general.  Nothing practice specific at all.

Give me a few minutes tomorrow to clean up the code a little, especially the cash_receipt.php file.

Rod, I’ll e-mail the files or a link when they’re ready.

markleeds wrote on Monday, February 13, 2006:

Rod, I can’t access my e-mail properly from work, so I’ll just post a link here:

http://drleeds.com/files/emr.tar.gz

This file has the changed files and a readme which explains where they go and some of what I changed.