select * from #Request.prefix_db_agency#.pPayer WHERE Loc_ID = '#session.AgencyID#' and status =0 SELECT p.Patient_ID, p.Pt_Last, p.Pt_First, p.Status FROM #Request.prefix_db_agency#.pPatients p WHERE p.Loc_ID = '#session.agencyid#' ORDER BY Pt_Last SELECT i.Invoice_Id,i.errors, i.DateSent, i.MethodSent, i.Comment, i.InvoiceTotal, i.PayerBalance, i.Assmt_ID ,DATEDIFF(CURDATE(), i.DateSent) AS age , i.User_defined_Status, p.Patient_Id, p.Status, p.Pt_Last, p.Pt_First, p.Pt_Middle ,p.Pt_Agy_ID, a.F177 AS START, a.F178 AS END , a.F26 AS TYPE, i.claim_status,i.Error_description, pr.Pay_Name, pr.Pay_ID, pr.Pay_Contact, pr.Pay_Phone,pr.Pay_Phone AS Contact_Phone_Ext, pr.Output AS PayerOutputType , (SELECT SUM(Amount) FROM #Request.prefix_db_agency#.Payments WHERE Invoice_Id = i.Invoice_Id and deleted <> 1) AS Paid , (SELECT SUM(WriteOffAmount) FROM #Request.prefix_db_agency#.Payments WHERE Invoice_Id = i.Invoice_Id and deleted <> 1) AS wOff FROM #Request.prefix_db_agency#.Invoices i join #Request.prefix_db_agency#.pSchedules s on s.patient_id = i.patient_id AND s.Status = 0 join #Request.prefix_db_agency#.pPatients p on p.patient_id = s.patient_id AND p.Status IN (#Request.patient_status#) join #Request.prefix_db_agency#.pAssessments a on i.Assmt_ID = a.Assmt_ID AND a.Status = 0 join #Request.prefix_db_agency#.pPayer pr on i.PatientPayer_ID = pr.Pay_ID AND pr.Status = 0 WHERE i.Agency_ID = #session.AgencyId# AND i.Deleted <> 1 AND i.DateSent BETWEEN '#DateFormat(url.df,"yyyy-mm-dd")#' and '#DateFormat(url.dt,"yyyy-mm-dd")#' AND i.DateSent = '#DateFormat(Now(),"yyyy-mm-dd")#' AND p.patient_id = i.patient_id AND i.Assmt_ID = a.Assmt_ID AND a.Assmt_ID = s.Assmt_ID and i.PatientPayer_ID = pr.Pay_ID AND pr.Pay_ID = #url.ID# AND i.InvoiceTotal > 0 AND i.Output is not null Group by i.Invoice_Id ORDER BY Pt_Last, Pt_First
Receivables Totals Export File
Back
(SELECT Min(Visit_Date) as MIN,Max(Visit_Date) as MAX FROM #Request.prefix_db_agency#.pSchedules where Assmt_ID = #Assmt_ID# AND Invoice_ID = #Invoice_ID# and Status = 0 ORDER BY Visit_Date)

» 1.Please Click Here and choose "Save Target As..." to download the Exported data file and save it to your computer.

«2. Click Here to start Daily Billing Report Details Report search.


No data could be found based on your search criteria.

Please try again.