1500 Form Box 12, Box 14, Box 24( I/J)

Day-to-Day Users
#1

Hi,

By trying to generate the 1500 PDF, I found Box 12 is missing the date, Box 14 is blank, and Box 24 (I/J, in our case is EI and the tax ID number) are all missing. How can I bring them back? The most update patches are installed in our computer.

I have found the V5.0.0.0 has all these boxes presented and also no rendering provider and supervising provider problems I asked in another thread. Is it possible to keep the database but downgrade to the previous version of openEMR?

BTW, we are running everything in windows 10.

#2

Some problems resolved:

  1. After modifying Administration --> Practice --> Insurance number --> and adding Provider number & Provider number (type), the BOX 24 (I/J) missing problem is solved.

  2. According to our previous experiences, Box 12 missing date is not essentially needed for filing claims. So we can leave it blank.

However, the Box 14 entry for “Date of current” and “Qualifier” are still missing. Please help.
Thank you!

#3

hi @luminosity, are you using v.5.0.1(3) and the Misc Billing Options form?

#4

No, I left it blank like we did in older version 5.0.0. When we left it blank in that version. All we need to do is input the date of current (onset/hospital date) when we open “new encounter form”. When 1500 form was generated, openEmr will automatically pull the date from “encounter form”.

Yes, we are using V.5.0.1(3).

I guess what we are looking for is… without using “Miscellaneous Billing Options for HCFA-1500”, the Box 14 will set the onset/hospital date as the default.

#5

hi @luminosity, thanks for the detailed bug report, this was previously fixed and probably should go in the next patch

#6

Hi Stephen,

I corrected the file by commenting out the original and plug in yours. The PDF file of 1500 can’t regenerate at all…

I got the following message on the screen.

“Data item at (32, 16) precedes current column.”

I used to work in IT field before becoming a health care professional so I have some basic skills to do this myself. But I haven’t worked as a programmer for almost 20 years. Please help!
Thank you!

#7

hi @luminosity, it works on my test v.5.0.1(3), do you want to paste what you’ve commented out and inserted here in a code block?

#8

Hi Stephen,

This is what I did.

// Box 14. Date of Current Illness/Injury/Pregnancy

//commented out the original version based on https://community.open-emr.org/t/1500-form-box-12-box-14-box-24-i-j/10361/5
//$tmp = $claim->miscOnsetDate();
//put_hcfa(32, 2, 2, substr($tmp, 4, 2));
//put_hcfa(32, 5, 2, substr($tmp, 6, 2));
//put_hcfa(32, 8, 4, substr($tmp, 0, 4));

//Fix recommended by https://community.open-emr.org/t/1500-form-box-12-box-14-box-24-i-j/10361/5
// this will cause onsetDate in Encounter summary to override misc billing so not perfect yet but fine for now
$tmp = ($claim->onsetDate()) ? $claim->onsetDate() : $claim->miscOnsetDate();
if (!empty($tmp)) {
	put_hcfa(32, 2, 2, substr($tmp, 4, 2));
	put_hcfa(32, 5, 2, substr($tmp, 6, 2));
	put_hcfa(32, 8, 4, substr($tmp, 0, 4));
	// Include Box 14 Qualifier
	put_hcfa(32, 16, 3, $claim->box14Qualifier());
}
#9

hi @luminosity, could you place this before the if statement
error_log("onset date is " . $tmp);
and then look for the value in the error log
tail /var/log/apache2/error_log and post it here? thanks

#10

[Sat Jun 23 21:05:42.428465 2018] [:error] [pid 7812:tid 1980] [client ::1:55900] PHP Warning: mysqli_real_connect(): MySQL server has gone away in C:\xampp\htdocs\openemr\library\ADODB_mysqli_log.php on line 185, referer: http://localhost/openemr/interface/main/tabs/main.php
[Sat Jun 23 21:05:42.569753 2018] [:error] [pid 7812:tid 1980] [client ::1:55900] PHP Warning: mysqli_real_connect(): MySQL server has gone away in C:\xampp\htdocs\openemr\library\ADODB_mysqli_mod.php on line 92, referer: http://localhost/openemr/interface/main/tabs/main.php
[Sat Jun 23 21:05:42.632260 2018] [:error] [pid 7812:tid 1976] [client ::1:55901] PHP Warning: mysqli_real_connect(): MySQL server has gone away in C:\xampp\htdocs\openemr\library\ADODB_mysqli_log.php on line 185, referer: http://localhost/openemr/interface/main/tabs/main.php
[Sat Jun 23 21:05:42.741648 2018] [:error] [pid 7812:tid 1976] [client ::1:55901] PHP Warning: mysqli_real_connect(): MySQL server has gone away in C:\xampp\htdocs\openemr\library\ADODB_mysqli_mod.php on line 92, referer: http://localhost/openemr/interface/main/tabs/main.php
[Sat Jun 23 21:15:42.539111 2018] [:error] [pid 7812:tid 1952] [client ::1:57044] onset date is 20180111, referer: http://localhost/openemr/interface/billing/billing_report.php

#11

ok, the onset date is coming through now at least :slight_smile: do you have any other customizations? i’m at a loss as to how

#12

Hi,

Do you mind if I send you 2 X12 files using 2 mock encounter entries via private message? The first is for the onset date with the treatment and the 2nd is for the following treatment date. Both of them need to indicate the onset date with “431” as the qualifier in 1500 and I assume in X12 file as well. However, I did not see the “431” qualifier in the onset date. If you compare both X12 files, you will see “431” did not show up in one of the files.

Perhaps you can figure out why our 1500 PDF did not show the onset date this way.

Thanks!

#13

I found the X12 file is not usable when I uploaded it to Availity after almost 1 week of struggle. Therefore, I would like to back up the database and uninstall the openemr with xampp totally. And then I will reinstall the whole again.

Could you or someone who already did this before help me out here?

Here are the steps I plan to take:

  1. Select “openemr” at http://localhost/phpmyadmin/
  2. Export 'openemr"
  3. Uninstall the whole thing by deleting the xampp directory in c:\xampp
  4. Reinstall the openEmr again.
  5. Install the patch file.
  6. Import and replace “openemr” at http://localhost/phpmyadmin/

Please let me know if these steps are good.

If this final resort works, then we don’t need to downgrade to v. 5.0.0 which we don’t have any problem to generate the x12 files and submit the claims successfully.

Thank you!

#14

hi @luminosity, no need to reinstall, there’s a bug in the genx12 script

you can comment out the if ($claim->miscOnsetDate() block and you’ll notice in the first if block that if the onset date is the same as the service date it will not be filled. Will look into this some more, thanks for the feedback.

#15

Hi,

I don’t think the current date with 431 indicator is the only problem. There must be something wrong with my installation otherwise other users with the newest version should have found the problems and received the error message we got from Availity already. Unless most of the users are still using the older version.

I think it’s better to decide what to do after you view the error messages we got last night from the Availity through your private message.

Please let me know if the above steps are correct to back up and reinstall just in case.

Thanks you!

#16

hi @luminosity, I replied to your message. Your bug reports are very much appreciated for the benefit of everyone who is or will be billing with OpenEMR.