Collections Report: Ins Summary

On OpenEMR 5.0.2 (4), When I generate a collections report with Category “Open” & Aging Columns “5”, to get 120+, I get all the data for each collection period (0-29) (30-59) etc…

However, when I select category “Ins Summary”, only collection period (0-29) totals are displayed, the rest from (30-59)… until 120+ are 0.00


What might be the issue?

Recommend upgrading to v6 where it’s been fixed.

Thanks @stephenwaite will do.

So it was a know issue in v5.0.2?

@stephenwaite out of curiosity, what was causing the issue? code, DB?

Upgraded to v6, but still the same issue. Does it perhaps to do with data?

Which tables are involved in the generation of Insurance Summary Collections Report?

hi @Benzo , must be, can’t reproduce the issue.

@stephenwaite does it have to do with status of the bills?

However, If I change the search criteria to ALL it shows each period without a problem, why is the Ins Summary not doing it?

what does Pt Due list?

Lists all the periods as required.

I figured that perhaps is due to the patient balance not being attributed to the insurance.

Does the collections report insurance summary use the last statement date to determine which period the due balance is listed in perhaps?

there’s a caveat to insurance due, if there is a statement count in the invoice then it remains as pt due, so you’d have to zero out the Statements sent
Screenshot from 2022-02-10 08-12-40
prob should be removed from the code base

Agree, probably should be removed from code base.

How do I zero out the statement count?

have to edit each invoice

Sheesh! :grimacing:

Alright.

Thought I could run a sql query & reset all statement counts once.

sure, that’s an option

Which table should I look at to reset the count?

form_encounter has stmt_count

Thanks @stephenwaite

The reason for statement count was purely to know how many times a statement was sent to the patient right? resetting that number won’t have any implications on the account right?

1 Like