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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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:
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
Rod
www.sunsetsystems.com
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- 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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
"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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Nice to see that a 2008 post got revived, and great that I am getting all this replies! Thanks all.
@aethelwulffe
I did a similar trick on another system, but I used a view. This way no direct interaction was required, with minimal chance for messing up the databases. But it is clear that there is no ready-to-go solution for WebERP either. Which brings me back to the main question: Is there an API to the export A/R ledger?
I still am trying to find out how the insurance bookkeeping can be bypassed, or even how the OpenEMR handles the flow. The most important for me is to understand if insurance is activated on service level, or on billing level. This would be a great help in order to modify my billing routines in OpenEMR. Can somebody please explain this?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello everyone,
My name is Victor Essang, just read your post and found out that you know about OpenEMR and Sql-Ledger, I am a user of OpenEMR 4.1.0, and I am looking for someone that can help me integrate a stable accounting package such as SQL-Ledger to work with OpenEMR such that patients payments and demographics can be viewed in sql-ledger so that reports can be printed out form sql-Ledger. If you feel you can handle such kind of programming, kindly contact me via essang.victor7@gmail.com. Waiting to hear from you soon.
Thank you!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
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!
Rod
www.sunsetsystems.com
I will be glad to test 2.8. I will report back on this soon.
-Mike
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
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!
Rod
www.sunsetsystems.com
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
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
@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.
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.
Rod
www.sunsetsystems.com
@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
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
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
@"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 :
http://www.openmedsoftware.org/mw/images/archive/8/80/20100408230131%21OpenEMR-PracticeMgmt-Gap-Review.pdf
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.
"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.
http://www.weberp.org
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.
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
@aethelwulffe : Thanks for the tip. Can you be more specific about how you import the OpenEMR billing info to your accounting?
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
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.
Nice to see that a 2008 post got revived, and great that I am getting all this replies! Thanks all.
@aethelwulffe
I did a similar trick on another system, but I used a view. This way no direct interaction was required, with minimal chance for messing up the databases. But it is clear that there is no ready-to-go solution for WebERP either. Which brings me back to the main question: Is there an API to the export A/R ledger?
I still am trying to find out how the insurance bookkeeping can be bypassed, or even how the OpenEMR handles the flow. The most important for me is to understand if insurance is activated on service level, or on billing level. This would be a great help in order to modify my billing routines in OpenEMR. Can somebody please explain this?
Hello everyone,
My name is Victor Essang, just read your post and found out that you know about OpenEMR and Sql-Ledger, I am a user of OpenEMR 4.1.0, and I am looking for someone that can help me integrate a stable accounting package such as SQL-Ledger to work with OpenEMR such that patients payments and demographics can be viewed in sql-ledger so that reports can be printed out form sql-Ledger. If you feel you can handle such kind of programming, kindly contact me via essang.victor7@gmail.com. Waiting to hear from you soon.
Thank you!