Having a lot of free time over the holiday and a desire to ditch Quickbooks, I worked out all the fixes necessary to make SQL-Ledger 2.8.10 work with OpenEMR 2.8.3. I also added code that allows you to specify up sales tax for your state (I needed this as we would also be selling items to patients).
Besides re-working ws_server.conf there were a couple tweaks needed to interface/billing/sl_eob_search.php and library/classes/WSClaim.class.php and some new variables to add to sql-ledger.conf to make it work.
If anyone else is interested, let me know. I'm not one of the developers and can't add things to CVS (fine by me) so, I'll either have to send you the files directly or, if one of the devs wants to get in touch, I can pass then along for inclusion.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
BIG thanks to tekknogenius for a post from last year that gave me my first clue as to how to make a go of this. (http://sourceforge.net/forum/message.php?msg_id=4270725)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Brady: Because of changes to the customer database schema in the newer SQL-Ledger, that probably won't work. The likely best way to handle this will be to provide both the ws_server_26.pl for the 2.6.X version of SQL-Ledger and my new ws_server_2.8.10_tax.pl file and clear instructions on the use of each.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have ported Fred's changes to current CVS and checked them in. They look good, and more testing (with both SL 2.6.x and 2.8.x) would be nice if anyone wants to give it a shot. Thanks Fred!
Rod
www.sunsetsystems.com
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hey everyone,
Having a lot of free time over the holiday and a desire to ditch Quickbooks, I worked out all the fixes necessary to make SQL-Ledger 2.8.10 work with OpenEMR 2.8.3. I also added code that allows you to specify up sales tax for your state (I needed this as we would also be selling items to patients).
Besides re-working ws_server.conf there were a couple tweaks needed to interface/billing/sl_eob_search.php and library/classes/WSClaim.class.php and some new variables to add to sql-ledger.conf to make it work.
If anyone else is interested, let me know. I'm not one of the developers and can't add things to CVS (fine by me) so, I'll either have to send you the files directly or, if one of the devs wants to get in touch, I can pass then along for inclusion.
Oh, forgot to say:
BIG thanks to tekknogenius for a post from last year that gave me my first clue as to how to make a go of this. (http://sourceforge.net/forum/message.php?msg_id=4270725)
This sounds great. Why don't you email your changes to me. rod at sunsetsystems dot com. Please include a description of what exactly you did. Thanks.
Rod
www.sunsetsystems.com
We should also make sure changes are backwards compatible with previous SQL-Ledger versions.
-brady
Rod: will do.
Brady: Because of changes to the customer database schema in the newer SQL-Ledger, that probably won't work. The likely best way to handle this will be to provide both the ws_server_26.pl for the 2.6.X version of SQL-Ledger and my new ws_server_2.8.10_tax.pl file and clear instructions on the use of each.
I have ported Fred's changes to current CVS and checked them in. They look good, and more testing (with both SL 2.6.x and 2.8.x) would be nice if anyone wants to give it a shot. Thanks Fred!
Rod
www.sunsetsystems.com