mike-h30 wrote on Friday, August 15, 2008:
I thought I would start a new thread in the event others will be installing SQL Ledger with OpenEMR 2.9.0.
Is SQL Ledger 2.6.27 still the recommended version to install with OpenEMR 2.9.0?
-Mike
sunsetsystems wrote on Friday, August 15, 2008:
I’m not aware of any problems with SL 2.8… it’s just not as well tested. If you feel adventurous give it a try and let us know how it works!
mike-h30 wrote on Friday, August 15, 2008:
I will be glad to test 2.8. I will report back on this soon.
-Mike
xiaoanri wrote on Sunday, September 28, 2008:
I would like to use sql ledger with OpenEMR 2.9.0, are there places I can find instructions how to install this? I have OpenEMR running on windows server 2003. Thank you. Hui
sunsetsystems wrote on Sunday, September 28, 2008:
Hui – SQL-Ledger under Windows is difficult and I would encourage you to move to Linux unless you have a great deal of time and patience. That said, I did play with it under Windows XP last year with some success. See:
http://www.oemr.org/modules/wiwimod/index.php?page=SqlLedgerInstallHowtos
Good luck!
voipbound wrote on Tuesday, December 23, 2008:
How did you guys do. Sql-ledger 2.8 did not work out well for me with Ubuntu 8.10. I had to revert back to 2.6
mike-h30 wrote on Tuesday, December 23, 2008:
I was able to get SQL Ledger 2.8 installed on SUSE Linux Enterprise Server 10 - SP2. However, we never used it as we postponed integrating billing and A/R until the release of OpenEMR-2.9.1. A/R support will be built into OpenEMR-2.9.1 thus eliminating the need for SQL Ledger. I am currently testing OpenEMR-2.9.1-dev.
-Mike
thesatman wrote on Saturday, April 28, 2012:
@rod:
your Sql-ledger howto:
Page not found
The requested page could not be found.
I posted a likewise request earlier on this forum. I am in need of an accounting system, and itlooks like SQL-Ledger can do the job, for accounting in Norway. However, I need to know how this will affect my OpenEMR virtual appliance. I see SQL-Ledger is installed, but I can not figure out how to launch the program. Looks like it is only partially installed.
Please your advice. Many thanks in advance.
sunsetsystems wrote on Monday, April 30, 2012:
thesatman: SQL-Ledger is obsolete for use with OpenEMR. However it should be fine as a standalone accounting system. See www.sql-ledger.com for more about that.
thesatman wrote on Monday, April 30, 2012:
@rod: Thx for clarifying this. Does this mean there i no A/R export feature whatsoever towards an accounting package (pref. SQL-Ledger)?
Secondly: If not, it leaves me with another question, as posed her : https://sourceforge.net/projects/openemr/forums/forum/202504/topic/1878010?message=11423669.
The question:
I am running the 4.1.0 VMware virtual appliance, and has Sql-Ledger (partially) installed. If I understand it correctly configuring tax is done in the sql-ledger.conf file. (Read more here:
http://www.assembla.com/code/openemr/git/nodes/master/accounting/sql-ledger.conf.)
But this still leaves me with a few questions.
- Is this combo OpenEMR/Sql-Ledger flexible enough to allow certain services to be billed with 0% tax, and other with 25%?
- Will the invoice specify the lines telling what the net grand total is for services at 0%, a field for the net grand total for 25%. As an example:
I am an alternative practitioner in Norway, and am offering services that are not covered by the insurance. Therefor, I would like to create a system where I have possibility to enter:
code xxx1 : Therapy session abc -> number of sessions: 1 -> rate: kr. 500,- (taxes 0%)
code xxx2 : sales of products xyz -> number of products : 2 -> Unit price: kr. 100,- (taxes 25%)
| 0% | 25%
Net total | 500 | 200
taxes | 0| 50
Total | 500| 250
Grand total : 750
No insurance, no codes. Please notice the local currency in the details. In OpenEMR I see NO way to create 2 types of services, one with taxes, the other exempt for taxes.
So, how do I approach this in OpenEMR?
Regards
jcahn2 wrote on Tuesday, May 01, 2012:
Ahoy thesatman.
Have a look at this thread from ckwu.
http://sourceforge.net/projects/openemr/forums/forum/202504/topic/5215713
I tested this seems like a couple of years ago now and I was impressed. His product, which integrates with OpenEMR, provides a general ledger and much more. I believe it is MySQL based also which would simplify your config needs. It also includes everything else one would need to run a business. If you test it out, I would be very interested in your findings.
Jack Cahn
OEMR Board
bradymiller wrote on Tuesday, May 01, 2012:
Hi,
The 4.1.0 OpenEMR appliance does not have sql-ledger installed. Note it was installed in old appliances (pre version 3.0) before sql-ledger became obsolete in OpenEMR.
I do not know much of billing, but there is a administration->lists->‘Tax Rate’ list and several places in the code where this taxrates list is used in addition to a a taxrates column in the codes sql table. So, guessing that tax rates is either supported or it wouldn’t be too tough to code support in for it.
-brady
OpenEMR
thesatman wrote on Tuesday, May 01, 2012:
@“jahn2”
Thank you “Jcahn2” for pointing that out for me. I used an hour or 2 to brows through the CK-ERP website. Now, from my point of view, the first thing that scared me is the notice in the ERP main page, saying : “Do not expect any help nor assistance on this module from anyone.”
…… ???
Seriously. In my previous life I was an accountant for over 20 years. So I have my share of knowledge. In addition I worked for many years as an IT consultant, so no big surprises here either. I have learned that with every accounting package, there is trouble ahead. It can be a bug, or maybe a feature is not documented well enough, or maybe the user is just not looking in the right places to get a certain job done within the package. But trust me on this one, support is something you definite need to have. CK-ERP announces that there is no written documentation at all. The only documentation are the actual files that makes the program running.
Rapports need to be generated. Not all lists are default, and every country has its own rules and traditions when it comes to accounting and tax reporting. The advice CK-ERP is giving : “You need to learn SQL”. :o( BlueERP, based on CK-ERP, has a report generator. Now that’s a good idea ;o)
The great thing about SQL-Ledger is that it already comes with Norwegian text, and a fully tested Norwegian account chart/plan. Thus we have Norwegian users (read: I will not be the only one struggling with “local legal and practical” issues).
I am willing to pay for support, and could consider a local (Norwegian) web based accounting system. But in order to do so, I need to make sure what the export features are. If OpenEMR has an API manual, things could be a lot easier. Anyone that can point me in the right direction?
@“bradymiller”
Sorry to say this, but you’ve got me puzzled… I don’t quite understand what you mean by “I do not know much of billing”. My question basically is: you’ve seen what it is I try to achieve (see my example above). Now who can help me with a step-by-step in my efforts to make this work for me, or who can point me to the documentation that explains it.
I also have the problem that I am not familiar with the concepts of ICD9, CPT4, HCPCS and CVX, simply because alternative practitioners in Norway don’t use a kind of coding. I found a wiki explaining CPT codes, but this is an American system. As stated, neither do I need to bill the insurance companies, and send a “balance bill” to the customer. All I need is a straight forward “enter a customer”, “enter a visit + journal”, “enter the fee+print invoice”, “receive cash payment+ register payment”.
The fact that I am not familiar with the above mentioned codes, makes it difficult for me to understand the procedure of creating services and products, and the impact on the administration flow (in terms of how to bypass the insurance billing). I found a good visual aid on “OpenEMR Practice Management Gap Review DRAFT”. For those who are interested, you can find it here :
To summarize, I found CPT information here: http://en.wikipedia.org/wiki/Current_Procedural_Terminology, and gives me an idea on what this is all about. In OpenEMR > administration > lists > Fee sheet // I also found the mechanism that is generating the fee based on service rendered. Leaves me for now with the question: What about the insurance question. Can somebody please explain how to bypass this?
I hope this discussion helps other in a similar situation.
Once this is up and running, and I can create invoicesto my patients, print them, and register payments, I have covered the basics. Next issue will be export or API to an external accounting program.
aethelwulffe wrote on Tuesday, May 01, 2012:
"CK-ERP is designed to fail within a Windows environment. "
-from the CK-ERP site.
I am cool with the sentiment, but I think a cross-platform outlook is the responsible one.
I am just curious as to how it “integrates” with OpenEMR. I can’t use it, of course (Linux only).
I am working with Web ERP (very nice). You can export some billing stuff in OpenEMR to OFX output, but much better to have a program like WebERP that can have limited access to the OpenEMR billing tables.
fndtn357 wrote on Tuesday, May 01, 2012:
Re: "CK-ERP is designed to fail within a Windows environment. "
I have installed it in Drupal on LAMP and it works. It is not very GUI friendly yet and the education functionality is missing. It is probably in need of some major TLC to improve the interface and some functionality. The claims of it not being a complete package are warning you all over the place.
jcahn2 wrote on Tuesday, May 01, 2012:
Sorry, the CK-ERP may not be too useful for you. I had just seen CK post about a new version available in the last couple of weeks and didn’t investigate thoroughly. JC
thesatman wrote on Tuesday, May 01, 2012:
@aethelwulffe : Thanks for the tip. Can you be more specific about how you import the OpenEMR billing info to your accounting?
bradymiller wrote on Tuesday, May 01, 2012:
Hi thesatman,
Sorry for the confusion. What I meant to say is that my knowledge of the billing/taxing features is not good. I replied to your post because I do know that sql -ledger is not included in the 4.1.0 OpenEMR appliance and because you addressed me specifically on this question in another forum.
-brady
OpenEMR
aethelwulffe wrote on Tuesday, May 01, 2012:
thesatman,
Importing just payment data from sql at the moment, but I have a WIP sharing OEMR database tables to WebERP… I have not fully mapped out the table relationship yet. I will need to get that straight before I can make sure I am importing data in the most meaningful way. While the WebERP tables are very intuitively organized, the equivalent processes that OpenEMR tries to do are quite strange to me and far more complex. OpenEmr is worried about the billing process in ways that don’t quite match up with double-entry accounting.