cverk wrote on Saturday, October 02, 2010:
I didn’t have the reported balance due calculation problem until applying the patch 7 files onto windows xampp version 3.2. It appears to double whatever the patient paid as a copay and place that as the balance due on the demographics page. It also places that value as a balance due note. The billing and EOB area works fine and the added ability to correct a posting error is nice, so I want to keep the patch in place. Any ideas?
sunsetsystems wrote on Sunday, October 03, 2010:
Could you try to reproduce the problem on the 3.2 demo site?
http://www.openmedsoftware.org/wiki/OpenEMR_Version_3.2.0_Demo
Thanks,
cverk wrote on Sunday, October 03, 2010:
The demo site seems to work OK. Is that one Linux or windows based? I tried to substitute back some of the old files written over by the patch without success so far. I am at the beginning of the learning curve as a physician with limited programming exposure, but once I get up to speed more, I think I can help with how a real life primary care office works, having run one for 25 years.
sunsetsystems wrote on Sunday, October 03, 2010:
Oh I think I told you wrong… looks like that demo does not have the patches installed. Sorry. Test with the 3.2 development demo instead:
cverk wrote on Sunday, October 03, 2010:
That demo site seems to work OK also. patient Fred Flintstone. I tried reloading the patches on my copy without success. As far as I can tell they don’t overwrite anything I have customized such as statement forms etc. Not sure where to look next.
cverk wrote on Sunday, October 03, 2010:
I found the problem to be in the file( patient.inc) in the ( get_patient_balance) function. If you block out the part about out to insurance, then the patient balance comes up correctly, at least as the total balance. I believe the statement was trying to achieve a situation where if they paid their copay and you were awaiting insurance payment, the balance would be zero. Instead it came up as twice the copay amount. I don’t know how to code it to function correctly, so I think I will just leave it marked out for now.
sunsetsystems wrote on Sunday, October 03, 2010:
I see the cause. Change line 1528 in patient.inc from:
$ptbal = $insarr - $brow - $drow;
to:
$ptbal = $insarr + $brow - $drow;
That is, change the first “-” to “+”.
I have checked in the correction. Thanks for noticing this problem!
cverk wrote on Monday, October 04, 2010:
Thank you. That was the fix. If you mark out the whole part you get the total patient balance. If you make the above change to a plus, you get the balance the patient appears to owe, which I think is the correct solution.
bradymiller wrote on Tuesday, October 05, 2010:
hey,
Is this fix confirmed? If so, will send out another patch in the next day or so.
-brady
sunsetsystems wrote on Tuesday, October 05, 2010:
Well, two of us seem to think it works. :-) I did check it on a live site.
cverk wrote on Tuesday, October 05, 2010:
There is similar, but more minor problem posting payments on the EOB area. When you post a payment and then push the W to calculate an adjustment, it does not take into account the copay already paid by the patient. Instead it adjusts off the entire difference. In most cases, the copay applies by insurance rules to the E&M code (99xxx series code) so it seems that would be the code that a paid copay should apply to.
sunsetsystems wrote on Tuesday, October 05, 2010:
There is similar, but more minor problem posting payments on the EOB area. When you post a payment and then push the W to calculate an adjustment, it does not take into account the copay already paid by the patient. Instead it adjusts off the entire difference. In most cases, the copay applies by insurance rules to the E&M code (99xxx series code) so it seems that would be the code that a paid copay should apply to.
If you think that’s a bug, please create a separate tracker item for it… it doesn’t really relate to this thread. But I’ve not heard of any rule about co-pays applying to E&M codes; OpenEMR posts them at the claim level, and that’s how they are sent to insurance in the claim.
bradymiller wrote on Tuesday, October 05, 2010:
hey.
A new patch was just released fixing the balance due bug:
http://www.openmedsoftware.org/wiki/OpenEMR_Patches
-brady
sim2011 wrote on Thursday, February 10, 2011:
Hi
We are using _openemr 3.1v. _
We r finding balance (Calculation) error.
1. Front Desk:
The front desk is unable to make out - how much COPAYS per patient were dues, when the claim r still being billed. At present they r calculating by subtracting pt dues using the PAYMENT shown in POP up.
2. We understand copay is seaparate and charges are separate at claim level. and we show both in X12.
EOB showing:
Balance due=Charges-Copay-Insurance payment-Adjustment.
Shouldnt it be?
Balance due=Charges+Insurance defined Copay-Copay-Insurance payment-Adjustment.
Is this correct or is it bug which may need to an upgrade on our front?Is it necessary to jump to 3.2 or 3.1 would work as well? plz help, as our physicians 1st billing batch file wud be ready soon for Sending Claims.
Thanks 
any suggestion or advice wud help …
openemr user
sim.