Menu

balance due

Help
CVerk
2010-10-02
2013-04-06
  • CVerk

    CVerk - 2010-10-02

    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?

     
  • Rod Roark

    Rod Roark - 2010-10-03

    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,

    Rod
    www.sunsetsystems.com

     
  • CVerk

    CVerk - 2010-10-03

    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.

     
  • Rod Roark

    Rod Roark - 2010-10-03

    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:

    http://www.openmedsoftware.org/wiki/Development_3.2.x_Demo

    Rod
    www.sunsetsystems.com

     
  • CVerk

    CVerk - 2010-10-03

    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

    CVerk - 2010-10-03

    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.

     
  • Rod Roark

    Rod Roark - 2010-10-03

    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!

    Rod
    www.sunsetsystems.com

     
  • CVerk

    CVerk - 2010-10-04

    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.

     
  • Brady Miller

    Brady Miller - 2010-10-05

    hey,
    Is this fix confirmed? If so, will send out another patch in the next day or so.
    -brady

     
  • Rod Roark

    Rod Roark - 2010-10-05

    Well, two of us seem to think it works.  :-)  I did check it on a live site.

    Rod
    www.sunsetsystems.com

     
  • CVerk

    CVerk - 2010-10-05

    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.

     
  • Rod Roark

    Rod Roark - 2010-10-05

    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.

    Rod
    www.sunsetsystems.com

     
  • Brady Miller

    Brady Miller - 2010-10-05

    hey.
    A new patch was just released fixing the balance due bug:
    http://www.openmedsoftware.org/wiki/OpenEMR_Patches
    -brady

     
  • Sim

    Sim - 2011-02-10

    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.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.