SQL-Ledger 2.8.10 and OEMR 2.8.3 works now

fred0 wrote on Wednesday, January 09, 2008:

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.

fred0 wrote on Wednesday, January 09, 2008:

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)

sunsetsystems wrote on Wednesday, January 09, 2008:

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

bradymiller wrote on Thursday, January 10, 2008:

We should also make sure changes are backwards compatible with previous SQL-Ledger versions.
-brady

fred0 wrote on Thursday, January 10, 2008:

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.

sunsetsystems wrote on Friday, January 11, 2008:

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