select CONCAT(p.Last_Name_M0040,' ',p.First_Name_M0040,' ','(',pr.PayName,')',' ',Date_Format(a.Certification_End,'%m/%d/%Y')) as Name, CONCAT(p.City,',',p.State_M0050,' ',Zip_M0060) as Addr, i.Invoice_Id, i.DateSent, i.MethodSent, i.Comment, i.InvoiceTotal, i.PayerBalance, i.Assessment_Tracker_Id ,DATEDIFF(CURDATE(), i.DateSent) AS age , p.Patient_Id, p.Status, p.Last_Name_M0040, p.First_Name_M0040, p.Middle_Initial_M0040 , a.Certification_Start AS START, a.Certification_End AS END , a.Assessment_Reason_M0100 AS TYPE, pr.PayName, pr.Payer_Id, pr.Output_Type AS PayerOutputType , (SELECT SUM(Amount) FROM #Request.prefix_db_agency#.Payments WHERE Invoice_Id = i.Invoice_Id) AS Paid , (SELECT SUM(WriteOffAmount) FROM #Request.prefix_db_agency#.Payments WHERE Invoice_Id = i.Invoice_Id) AS wOff , (SELECT Invoice_Id FROM #Request.prefix_db_agency#.Invoices WHERE Assessment_Tracker_Id = i.Assessment_Tracker_Id AND InvoiceTotal = '0.00' and Deleted <> 1 LIMIT 1) AS FinalBilling , (SELECT DATEDIFF(CURDATE(), DateSent) FROM #Request.prefix_db_agency#.Invoices WHERE Assessment_Tracker_Id = i.Assessment_Tracker_Id AND InvoiceTotal = '0.00' and Deleted <> 1 LIMIT 1) AS FinalAge, (select Output_Type from #Request.prefix_db_agency#.ScheduleItems where invoice_id = i.invoice_id AND Total_EClaim > 0 AND Deleted <> 1 limit 1 ) as Output_Type, (select Total_Eclaim from #Request.prefix_db_agency#.ScheduleItems where invoice_id = i.invoice_id AND Total_EClaim > 0 AND Deleted <> 1 limit 1 ) as Total_Eclaim FROM #Request.prefix_db_agency#.Invoices i, #Request.prefix_db_agency#.Payer pr, #Request.prefix_db_agency#.patient p, #Request.prefix_db_agency#.Assessment_New a WHERE i.Agency_ID = '#session.agencyid#' AND i.Deleted <> 1 AND i.InvoiceTotal > 0 AND i.InvoiceTotal = '#form.amount_filter#' AND SUBSTR(i.DateSent,1,10) >= #CreateODBCDate(url.df)# AND SUBSTR(i.DateSent,1,10) <= #CreateODBCDate(url.dt)# AND DATEDIFF(CURDATE(), i.DateSent) >= '#url.age#' AND (p.Last_Name_M0040 LIKE '%#url.patfilter#%' OR p.First_Name_M0040 LIKE "%#url.patfilter#%") AND pr.PayName LIKE '%#url.payname#%' AND ( (i.InvoiceTotal - (select sum(amount + writeoffamount) from #Request.prefix_db_agency#.Payments where invoice_id = i.invoice_id) > 0) OR (select sum(amount + writeoffamount) from #Request.prefix_db_agency#.Payments where invoice_id = i.invoice_id) is null ) AND p.patient_id = i.patient_id AND i.Assessment_Tracker_ID = a.Assessment_Tracker_ID AND pr.payer_id = i.patientpayer_id and i.QBExport = 0 ORDER BY Last_Name_M0040, First_Name_M0040, i.Invoice_Id select CONCAT(p.Last_Name_M0040,' ',p.First_Name_M0040,' ','(',pr.PayName,')',' ',Date_Format(a.Certification_End,'%m/%d/%Y')) as Name, CONCAT(p.City,',',p.State_M0050,' ',Zip_M0060) as Addr, i.Invoice_Id, i.DateSent, i.MethodSent, i.Comment, i.InvoiceTotal, i.PayerBalance, i.Assessment_Tracker_Id ,DATEDIFF(CURDATE(), i.DateSent) AS age , p.Patient_Id, p.Status, p.Last_Name_M0040, p.First_Name_M0040, p.Middle_Initial_M0040 , p.Street_Address, p.Mailing_Address, p.City, p.State_M0050, p.Zip_M0060, a.Certification_Start AS START, a.Certification_End AS END , a.Assessment_Reason_M0100 AS TYPE, pr.PayName, pr.Payer_Id, pr.Output_Type AS PayerOutputType , (SELECT SUM(Amount) FROM #Request.prefix_db_agency#.Payments WHERE Invoice_Id = i.Invoice_Id) AS Paid , (SELECT SUM(WriteOffAmount) FROM #Request.prefix_db_agency#.Payments WHERE Invoice_Id = i.Invoice_Id) AS wOff , (SELECT Invoice_Id FROM #Request.prefix_db_agency#.Invoices WHERE Assessment_Tracker_Id = i.Assessment_Tracker_Id AND InvoiceTotal = '0.00' and Deleted <> 1 LIMIT 1) AS FinalBilling , (SELECT DATEDIFF(CURDATE(), DateSent) FROM #Request.prefix_db_agency#.Invoices WHERE Assessment_Tracker_Id = i.Assessment_Tracker_Id AND InvoiceTotal = '0.00' and Deleted <> 1 LIMIT 1) AS FinalAge, (select Output_Type from #Request.prefix_db_agency#.ScheduleItems where invoice_id = i.invoice_id AND Total_EClaim > 0 AND Deleted <> 1 limit 1 ) as Output_Type, (select Total_Eclaim from #Request.prefix_db_agency#.ScheduleItems where invoice_id = i.invoice_id AND Total_EClaim > 0 AND Deleted <> 1 limit 1 ) as Total_Eclaim FROM #Request.prefix_db_agency#.Invoices i, #Request.prefix_db_agency#.Payer pr, #Request.prefix_db_agency#.patient p, #Request.prefix_db_agency#.Assessment_New a WHERE i.Agency_ID = '#session.agencyid#' AND i.Deleted <> 1 AND i.InvoiceTotal > 0 AND i.InvoiceTotal = '#form.amount_filter#' AND SUBSTR(i.DateSent,1,10) >= #CreateODBCDate(url.df)# AND SUBSTR(i.DateSent,1,10) <= #CreateODBCDate(url.dt)# AND DATEDIFF(CURDATE(), i.DateSent) >= '#url.age#' AND (p.Last_Name_M0040 LIKE '%#url.patfilter#%' OR p.First_Name_M0040 LIKE "%#url.patfilter#%") AND pr.PayName LIKE '%#url.payname#%' AND ( (i.InvoiceTotal - (select sum(amount + writeoffamount) from #Request.prefix_db_agency#.Payments where invoice_id = i.invoice_id) > 0) OR (select sum(amount + writeoffamount) from #Request.prefix_db_agency#.Payments where invoice_id = i.invoice_id) is null ) AND p.patient_id = i.patient_id AND i.Assessment_Tracker_ID = a.Assessment_Tracker_ID AND pr.payer_id = i.patientpayer_id and i.QBExport = 0 Group by Patient_ID ORDER BY Last_Name_M0040, First_Name_M0040, i.Invoice_Id Update #Request.prefix_db_agency#.Invoices SET QBExport = 1 ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# Where Invoice_Id = #gets.Invoice_Id# » 1. Print all fields - Please Right Click Here and choose "Save Target As..." to download the Exported data file and save it to your computer.


» 2. Print Patient Information only - Please Right Click Here and choose "Save Target As..." to download the Exported data file and save it to your computer.


» 3. Print New Format - Please Right Click Here and choose "Save Target As..." to download the Exported data file and save it to your computer.


« Click Here to start Outstanding Invoices Report search. No data could be found based on your search criteria.

Please try again.