Editing Statement

Day-to-Day Users
1

msregina1 wrote on Monday, February 20, 2012:

Can anyone advise me on how I would go about editing my patient statement?   I need to changed our address and remit to address.

2

sunsetsystems wrote on Monday, February 20, 2012:

Edit the file sites/default/statement.inc.php (or substitute an appropriate site ID for “default”).  You’ll find comments in there to help you figure out what to do.

Rod
www.sunsetsystems.com

3

nursejeff wrote on Tuesday, February 12, 2013:

Hi Rod,

How would I add 2-3 lines between my address on the top of the page and the Addressee in order to make it fit in the envelope better.

Jeff Guillory
NP Health Clinic

4

bgregg wrote on Tuesday, February 12, 2013:

Jeff,

That can be accomplished by adding a “\n” for each break similar to this:

$out  = sprintf("%-34s %-23s %-s\n",$clinic_name,$stmt['patient'],$stmt['today']);
$out .= sprintf("%-34s %s: %-s\n",$clinic_addr,$label_chartnum,$stmt['pid']);
$out .= sprintf("%-34s %-s\n",$clinic_csz,$label_insinfo);
$out .= "\n\n";

Brad Gregg
MI-Squared

5

nursejeff wrote on Tuesday, February 12, 2013:

Thank you Brad,

We actually read the instruction on the file and made some other adjustments also.

Thanks again for your help.

Jeff

6

hitechelp wrote on Tuesday, February 12, 2013:

Jeff,

We set up our invoice to overcome a number of issues present in the default invoice: 
1. Get the patient address to show and stay visible in the left window of a number 10 envelope with two simple folds.
2. Show the total amount due instead of “Insurance information On File” on return part of statement.
3  Modify the credit card payment section to include spaces for billing zip, CCV and date without taking more space.
4. Moved the canned statements further down to make more room, and changed the wording.
5. Added a way to put in a separate billing phone number (otherwise primary facility phone is default)

I’d be glad to share ours with you, it has comments in parenthesis to explain what changes were made.
In case you were unaware, do not use Word or similar programs on php files.  Recommend download Notepad++ for easier editing.    https://docs.google.com/file/d/0B6_qxpCoBHlYMThQWk9ZOVpaOG8/edit?usp=sharing

7

arnabnaha wrote on Monday, July 22, 2013:

Hi david, I need the statement file badly changed…can I see yours to get an Idea for my clinic?
my email id is: superarnab@gmail.com

8

hitechelp wrote on Tuesday, July 23, 2013:

Updated version to let you insert a billing phone number that is different from default facility.

Those using the previous version may have noted that entering a billing phone number after the contact’s name on the “Billing Attn:” line in the Facilities section causes that number to show up in your claims and obviously, we don’t want that to happen.

https://docs.google.com/file/d/0B6_qxpCoBHlYaGowU3VrdkVSWXM/edit?usp=sharing

9

fsgl wrote on Tuesday, July 23, 2013:

David,

Access to the Google documents is restricted even with a Gmail account.

It would be great if you could copy the contents to this thread.

10

bradymiller wrote on Thursday, July 25, 2013:

Hi David,
Even better to get the code on git/github. Check out this tutorial:
http://www.open-emr.org/wiki/index.php/Git_for_dummies
-brady
OpenEMR

11

Hi Rod,
I have been trying in vain to edit the Remit To address. I have looked thru the sites/default/statement.inc.php file and follow your instructions to;
“Edit the file sites/default/statement.inc.php (or substitute an appropriate site ID for “default”).”
I only end up deleting the city in the report when I substitute the actual citys name for the word ‘city’ below;
Line 530 in 5.0.1-6 version
// Facility (service location)

$clinic_name = "{$row['name']}";
$clinic_addr = "{$row['street']}";
$clinic_csz = "{$row['city']}, {$row['state']}, {$row['postal_code']}";

Thus this is obviously not what you meant by edit what is in brackets.
Could you please guide me as to what exactly to edit.

Thank you,

Henry

12

have you seen this recent thread Beef with the patient statement

13

Hi Stephen,

Thank you for responding.
Read thru this. I am not a programmer. I just want to change the Remit To address, as it is not the same as our Facility address. Reading Ron’s post it would appear to be relatively simple, just edit the info between the brackets. I just want to know where exactly to do this in the file.

Thank you,

Henry

14

@hamd
To answer your question, find these lines in the statement.inc.php file.

// Billing location modified by Daniel Pflieger at Growlingflea Software
    $service_query = sqlStatement("SELECT * FROM `form_encounter` fe join facility f on fe.billing_facility = f.id where fe.id = ?", array($stmt['fid']));
    $row = sqlFetchArray($service_query);
    $remit_name = "{$row['name']}";
    $remit_addr = "{$row['street']}";
    $remit_csz = "{$row['city']}, {$row['state']}, {$row['postal_code']}";

You can hard code in your remit too address this way:

// Billing location modified by Daniel Pflieger at Growlingflea Software
    // $service_query = sqlStatement("SELECT * FROM `form_encounter` fe join facility f on fe.billing_facility = f.id where fe.id = ?", array($stmt['fid']));
    //$row = sqlFetchArray($service_query);
    $remit_name = "The Name Where the Bill Goes";
    $remit_addr = "123 A St ";
    $remit_csz = "YourCity, ST, 96857";

This should work.

15

Hi Sherwin,

Those exact lines can only be found in github master branch PR 10/21/2018 by Daniel Pflieger.
So are you saying that I should copy and substitute that statement.inc.php file in github for the one that my 5.0.1-6 system has now, then make those modifications?
From what I was reading in the Forum (Statement.inc.php file incorrectly sets the billing facility to the same value of service facility regardless of what is entered in Admin->Facility) this is the same problem he was trying to resolve in 4/18 -5/18, i.e. different facility and billing addresses.

Sorry to sound dense, but I want to be sure of what I’m doing.

Thank you,

Henry

16

Hi Sherwin,

It appears that there are 2 places that have the above code in the statement file, lines 146 and 545.
Do they both need to be modified.

Thank you,

Henry

17

My apologies, I was in the wrong version.
You do need to find the first instance of $remit_name.

Which the first instance is line 137.

You can change these lines from this:

  <td style="margin:auto;"><b>'.$label_remitto.'</b><br />'
  .$remit_name.'<br />'
  .$remit_addr.'<br />'
  .$remit_csz.'
  </td>

To this:

  <td style="margin:auto;"><b>'.$label_remitto.'</b><br />'
  .'My Billing location Name <br />'
  .'123 Any St NW <br />'
  .'Kansas City, NB, 98765
  </td>
18

Hi Sherwin,

The line at 134 is // Billing location
The line at 135 is $ remit_name = $clinic_name;
The line at 136 is $ remit_addr = $clinic_addr;
The line at 137 is $ remit_csz = $clinic_csz;

I do not see the line that goes before it that you noted.

Thank you,

Henry

19

Hi Sherwin,
The first line is at line 422. Is this where these changes belong.

Thank you,

Henry

20

Henry, what version openemr are you trying to modify statement?