esears1 wrote on Monday, December 12, 2005:
That’s not a bad idea to make a HOWTO…
I have php client loaded (i can run the processing from a command prompt and it works fine ). It is just when I run it from the openemr billing link that I get that message. wierd.
sunsetsystems wrote on Monday, December 12, 2005:
It looks like the php executable is not in the web server’s path. There are several ways to fix this. One would be to modify billing_report.php, where you see this line:
"php -q process_bills.php bill > process_bills.log 2>&1 &");
changing it to something like:
"/usr/bin/php -q process_bills.php bill > process_bills.log 2>&1 &");
… depending on the actual location of the executable.
– Rod
www.sunsetsystems.com
esears1 wrote on Thursday, December 29, 2005:
ok, I have the php-cli loaded and still the link says the same thing in the log. I can run a php executable from the command prompt no problem. I even tried what Rod said about putting the path where php is and still. any ideas?
sunsetsystems wrote on Thursday, December 29, 2005:
Dunno, I’d have to poke around with it for a bit. It’s not a problem I’ve heard of before and there’s not enough info here to work with. I guess you can run the billing command manually until someone figures it out.
– Rod
www.sunsetsystems.com
esears1 wrote on Thursday, December 29, 2005:
ok another question. I successfully created the .pdf docs when I selected which bills to be processed as hcfa and then ran the billing process manually from the shell prompt. Now when i go back into emr and go to billing, I select all, then click on generate electronic batch and clear. I get the following error:
Entry has not been previously sent to external system or no entry was found for them in the integration mapping, could not send claim. Patient: ‘28’
What does that mean?? I do see the .pdf docs in the public directory so i’m not sure what i need to do or not doing.
sunsetsystems wrote on Thursday, December 29, 2005:
It means you’re posting a claim for at least one patient who has no entry in SQL-Ledger. This can happen if you added any patients to OpenEMR before you got SQL-Ledger working with it.
You can get a patient posted to SL by updating their demographics.
– Rod
www.sunsetsystems.com
esears1 wrote on Thursday, December 29, 2005:
I have done what you said but if I go into sql-ledger, it does not have any info in there at all. no customers at all. The process we are doing is creating the superbills in openemr, then i generate the claims. but we can never see any info in sql-ledger at all it seems it’s not getting posted. All the claims i have done, sql-ledger was setup prior to openemr patients were added.
need help… need to get this working. in the meantime i sent zirmed the processeed file, so hopefully it is a good one. we need our money :>
esears1 wrote on Thursday, December 29, 2005:
Forgot to mention , then in setting up sql-ledger the only thing I did was make sure the installation was setup correctly according to the documentation I found here or at oemr.org. (creating dataset, user,etc) But as far as using sql-ledger (entering in info, etc) I have done nothing…
sunsetsystems wrote on Thursday, December 29, 2005:
If you have no customers in SL then clearly something is wrong. What happens if you go into a patient’s demographics and save them? Any errors? If not, does the customer then show up in SL?
You really need to resolve all the outstanding issues before you go into production with it.
– Rod
www.sunsetsystems.com
esears1 wrote on Thursday, December 29, 2005:
Well, there are no errors when we go into demographcis to save them and they do not show up in sl.
btw. we are in production between two systems. old and new (openemr)
jimbo456 wrote on Thursday, December 29, 2005:
Have you setup the ms service correctly in sql-ledger and added the correct ar account in the config file for openemr to post bills to?
It is real esay to confuse which username and pw you are using to access sql-ledger also.
Also what url path are you using in config.php?
Jimbo
sunsetsystems wrote on Thursday, December 29, 2005:
I would check what happens in the Apache "access log" and "error log" when you save the demographics.
– Rod
www.sunsetsystems.com
me2yaah wrote on Saturday, September 01, 2012:
Hello Rod, i have gone through the complete thread and i have followed all setup procedures and config settings but my major challenge is that i still receive the ff error msg wen i try to access a patients demographics in openemr. "Fault: Code: 5 Reason ‘Didn’t receive 200 OK from remote server. (HTTP/1.1 500 Internal Server Error)’. Can you pls help me bcos openemr and sql-ledger are both working fine but i dont see any connection btw them. Thank you!
me2yaah wrote on Saturday, September 01, 2012:
Hello Rod, i have gone through the complete thread and i have followed all setup procedures and config settings but my major challenge is that i still receive the ff error msg wen i try to access a patients demographics in openemr. "Fault: Code: 5 Reason ‘Didn’t receive 200 OK from remote server. (HTTP/1.1 500 Internal Server Error)’. Can you pls help me bcos openemr and sql-ledger are both working fine but i dont see any connection btw them. Thank you!
sunsetsystems wrote on Sunday, September 02, 2012:
Hey, SQL-Ledger use with OpenEMR is obsolete. Suggest you download the new 4.1.1 release and go from there. Much easier now!