I am currently researching the reasons for consistent undistributed funds after uploading an ERA to OpenEMR. It seems that smaller files generally don’t leave funds undistributed but when a large ERA file is uploaded the payer shows the adjustments but when loaded to OpenEMR adjustments aren’t reflected.
After going through the code I found some depreciated code using sqlQ() in the sl_eob_process.php file on 3 lines.
My customer is using OpenEMR500 but after checking openEMR501 I see the same mistakes. Since this code is depreciated and most folks are using PHP7.0 and above, could this code be the root of some of the issues?
If someone has some general insight the the causes of undistributed funds, that would be great.