SL missing billing transactions

ajperezcrespo wrote on Thursday, January 12, 2006:

Patient info transfers into SL with no problems, billing info does not show up.  No EOB no AR transactions either.  Otherwise alls nifty.
OEMR 2.8.0
SL 2.6.4
MYSQL 4.1x
PG 8.0
Any clues
Alfonso

sunsetsystems wrote on Thursday, January 12, 2006:

Make sure all the account numbers in your config files exist in SL, and that you have created the MS services item and that it links to the income account.  There was another recent thread about all this.

– Rod
www.sunsetsystems.com

ajperezcrespo wrote on Thursday, January 12, 2006:

1)Made sure all acct number in Configs exits in SL. I did notice that the default consulting account in Config.php and Global.php is 4020 but in SL is 4320.
2)Created the MS Services item. MS (No quotes) Account created and linked to 4320 and 5010 (these are the defual links in SL).

Global.php
$sl_cash_acc    = ‘1060’;       // sql-ledger account number for checking
$sl_ar_acc      = ‘1200’;       // sql-ledger account number for a/r
$sl_income_acc  = ‘4320’;       // sql-ledger account number for medical services income
$sl_services_id = ‘MS’;         // sql-ledger parts table id for medical services

Config.php
$GLOBALS[‘oer_config’][‘ws_accounting’][‘username’] = “unused”;
$GLOBALS[‘oer_config’][‘ws_accounting’][‘password’] = “unused”;
$GLOBALS[‘oer_config’][‘ws_accounting’][‘url_path’] = “http://” .
  $_SERVER[“SERVER_NAME”] . “/sql-ledger/login.pl”;
$GLOBALS[‘oer_config’][‘ws_accounting’][‘income_acct’] = “4320”;
Thanks

andres_paglayan wrote on Thursday, January 12, 2006:

under openemr/accountig/ there are two files,

you have to rename the ws_server_26.pl to ws_server.pl

(and toss the old ws_server.pl)

ajperezcrespo wrote on Thursday, January 12, 2006:

That was done. Even erased and re-did databases for both mysql and pg.

sunsetsystems wrote on Thursday, January 12, 2006:

Is anything in the Apache error log?  If not, I suggest modifying ws_server.pl to write a log file.

– Rod
www.sunsetsystems.com

ajperezcrespo wrote on Friday, January 13, 2006:

How’s about a really big hint as to how to go about doing that?

sunsetsystems wrote on Friday, January 13, 2006:

OK.  See freeb/formatbin/hcfa.pl for examples.  Look for lines containing LOG, for example like this:

grep LOG /usr/share/freeb/formatbin/hcfa.pl

Start with a definition like this:

my $LogFile = ‘/tmp/ws_server.log’;

and then open the log, write to it, and close it like hcfa.pl does.

Congratulations, you’re now writing Perl code!  :slight_smile:

– Rod
www.sunsetsystems.com

ajperezcrespo wrote on Friday, January 13, 2006:

Well I didn’t graduate as a Perl programer but going through I did find out that my ws_server.pl was corrupt.  I made good on the moment and installed SL 2.6.5 and all seems good and happy.
Sorry and thanks for the patience guy.