Do you use or administer OpenEMR? Take the General Satisfaction Survey to help improve the product

Pre-payments: Why don't they show on the payments screen?


Hi, do either of you guys know why prepayments to don’t show on this screen?
Why isn’t prepayment a column?

I’d have to assume that a pre-payment is still a patient payment and should carry forward as a credit/debit(as case may be). Ledger and invoice should break it out…

That makes so much sense.

Why didn’t I think of that?

Because i’m on a roll today i.e i’ve been right 3 out of 10 times. Very good day for me! :slight_smile:

I have had to address the prepayments not showing anywhere but in the batch payment records.
When users go to the Front Office Receipts report. Prepayments don’t show there. Is there a reason for prepayment not to be shown in the money collected for the day?

I figured it out.

Someone added a line to the query

    "JOIN form_encounter AS fe ON fe.encounter=r.encounter " .

Adding this line to the query causes the query to filter out the prepayments since prepayments are not tied to an encounter. So, remove this line from the query, and the query will pick up the prepayments and put them in the Previous column. The previous column should be renamed Prepayment.

1 Like