Unnamed Insurance Company showing in our Payment Method Financial Report

Support
#1

Situation
Receipts Summary (under Reports, Financial, Payment Method) shows an Insurance Company section titled “Unnamed Insurance Company”. The entries in that section are adjustment amounts however, our system shows no Insurance Company by that name. We’re at a loss to understand or explain how this happening and why?
Can anyone shed some light on this?

OpenEMR Version
I’m using OpenEMR version 6.1.0 (1)

Browser:
I’m using: FF 106.0.5 (64-bit)

Operating System
I’m using: Ubuntu 18.04.6

Logs
Did you check the logs? Yes
Was there anything pertinent in them? No
Please paste them here (surround with three backticks (```) for readability.
You can also turn on User Debugging under Administration->Globals->Logging User Debugging Options=>All

#2

Hello @hitechelp -
Probably would be good to have some screenshots of your report. But the problem has the sound of a missing datum somewhere, being arbitrarily called ‘Unnamed Insurance Company’ by the system when it does not have its real name.

Some ideas to check:

  • Is it possible that you have an insurance company’s identifiers listed in Admin/ Practice/ Practice Settings/ Insurance Companies but it has no name in the blank?
  • Or a set of payments that all have adjustments but in which the insco is not named?
  • If you can trace which entries are being shown, then backtrack to the patient involved, and look in their insurance data, that might be revealing.
  • Maybe open the ‘Checkout’ and ‘Payment’ screens (main menu: Fees/ Checkout or Payment) for the encounters in the “Unnamed Insurance Company” section and see if any insurance payments have been noted without indicating the insco.

Happy hunting and good luck!

#3

Thank you htuck!

Now I have something to work from.

#4

hi @hitechelp , would you like to test out this updated script which should improve the report? It can be replaced in the webroot at interface/reports
receipts_by_method_report.php (28.3 KB)

1 Like
I need help to customize the financial report
#5

Stephen,

We’re running Oemr v6.1.0 (1)

I tested your file on my backup server and got a blank page with tab titled “Unknown”

Apache Error log excerpt follows;

[Mon Dec 12 08:31:48.334769 2022] [php7:error] [pid 20794] [client [192.168.1.128:65438](http://192.168.1.128:65438)] PHP Fatal error: require_once(): Failed opening required '/var/www/html/openemr/library/patient.inc.php' (include_path='/var/www/html/openemr/vendor/pear/archive_tar:/var/www/html/openemr/vendor/pear/console_getopt:/var/www/html/openemr/vendor/pear/pear-core-minimal/src:/var/www/html/openemr/vendor/pear/pear_exception:.:/usr/share/php') in /var/www/html/openemr/interface/reports/receipts_by_method_report.php on line 25, referer: https://192.168.1.100/openemr/interface/main/tabs/main.php?token_main=NTOIQaWFQJ8ySk0E6ujOZR6u2PfPqhBugJHNFF4P
[Mon Dec 12 08:32:24.051818 2022] [php7:warn] [pid 20797] [client [192.168.1.128:65450](http://192.168.1.128:65450)] PHP Warning: require_once(/var/www/html/openemr/library/patient.inc.php): failed to open stream: No such file or directory in /var/www/html/openemr/interface/reports/receipts_by_method_report.php on line 25, referer: https://192.168.1.100/openemr/interface/main/tabs/main.php?token_main=NTOIQaWFQJ8ySk0E6ujOZR6u2PfPqhBugJHNFF4P
[Mon Dec 12 08:32:24.051933 2022] [php7:error] [pid 20797] [client [192.168.1.128:65450](http://192.168.1.128:65450)] PHP Fatal error: require_once(): Failed opening required '/var/www/html/openemr/library/patient.inc.php' (include_path='/var/www/html/openemr/vendor/pear/archive_tar:/var/www/html/openemr/vendor/pear/console_getopt:/var/www/html/openemr/vendor/pear/pear-core-minimal/src:/var/www/html/openemr/vendor/pear/pear_exception:.:/usr/share/php') in /var/www/html/openemr/interface/reports/receipts_by_method_report.php on line 25, referer: [https://192.168.1.100/openemr/interface/main/tabs/main.php?token_main=NTOIQaWFQJ8ySk0E6ujOZR6u2PfPqhBugJHNFF4P```](https://192.168.1.100/openemr/interface/main/tabs/main.php?token_main=NTOIQaWFQJ8ySk0E6ujOZR6u2PfPqhBugJHNFF4P)

Thanks for the effort, I hope you can get to the bottom of this.
#6

hi @hitechelp , sorry, it’s only for v7.

#7

I suspected that might be the case, hence the version id in my reply.

Thank You Stephen,
Joyful holiday wishes to you.

1 Like