SELECT pEmployee.Emp_Last,pEmployee.Emp_First,pSchedules.Pay_ID, pPatients.Pt_City,pPatients.Pt_State, pPatients.Pt_Zip,pPatients.Pt_Street, pPatients.Patient_ID, pPatients.Pt_Last, pPatients.Pt_First,pPayer.Pay_Street, pSchedules.Schedule_ID, pSchedules.Total_Units,pSchedules.Assmt_ID, pSchedules.Invoice_ID,pSchedules.Visit_Date,pSchedules.Skill, Payments.WriteOffAmount,pPayer.Pay_Name, pSchedules.Total_Eclaim,Invoices.patientpayer_id, pRevenue_Code.Measure, pRevenue_Code.EClaim_Price , vp.Visit_Pay_ID, vp.Schedule_ID as vp_Schedule_ID ,vp.Payment_ID, IFNULL(vp.payment,0) AS payment, IFNULL(vp.write_offamount,0) AS first_wamount,IFNULL(vp.second_write_offamount,0) AS second_wamount, IFNULL(vp.third_write_offamount,0) AS third_wamount, IFNULL(vp.fourth_write_offamount,0) AS fourth_wamount, vp.write_offcode, vp.write_offcodesecond, vp.second_write_offcode,vp.second_write_offcodesecond, vp.third_write_offcode, vp.third_write_offcodesecond, vp.fourth_write_offcode, vp.fourth_write_offcodesecond FROM #Request.prefix_db_agency#.pSchedules JOIN #Request.prefix_db_agency#.Invoices ON Invoices.Invoice_Id = pSchedules.Invoice_ID JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = Invoices.PatientPayer_ID JOIN #Request.prefix_db_agency#.pRevenue_Code ON pRevenue_Code.Rev_CodeID = pSchedules.Rev_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Visits_payments vp ON vp.Schedule_ID = pSchedules.Schedule_ID AND vp.Status = 0 JOIN #Request.prefix_db_agency#.Payments ON vp.Payment_ID = Payments.Payment_ID AND Payments.Deleted = 0 JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.status < 2 JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.status = 0 LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee on pEmployee.Emp_ID = pSchedules.Emp_ID AND pSchedules.status = 0 WHERE pSchedules.Status = 0 AND Invoices.Deleted <> 1 AND pSchedules.Invoice_ID = '#url.Invoice_ID#' AND Payments.Payment_ID = '#url.Payment_ID#' GROUP BY vp.Visit_Pay_ID

Something Went wrong. Please connect with your admin

 INSERT INTO #Request.prefix_db_agency#.pat_Invoices ( Invoice_ID ,PatientPayer_ID ,Agency_ID ,Patient_ID ,Assmt_ID ,DateSent ,MethodSent ,Output ,WhereTreated ,Record_Created_By ,Record_Created_Date ,Record_Modified_By ,Record_Modified_Date ) VALUES ( '#url.Invoice_ID#' ,'#Getschedule.PatientPayer_ID#' ,'#session.agencyid#' ,'#Getschedule.Patient_ID#' ,'#Getschedule.Assmt_ID#' ,NOW() ,'PDF' ,'PDF' ,"" ,'#Session.EmployeeId#' ,#now()# ,'#Session.EmployeeId#' ,#now()# ) SELECT LAST_INSERT_ID() as LastInsertID
#UCase(getTimeZone.Agency_Name)#
 Invoice#: #invoiceid#
#UCase(getTimeZone.Agency_Address1)# Date: #DateFormat(now(), "mmmm dd, yyyy")#
#UCase(getTimeZone.Agency_City)# Amount Due: #DollarFormat(url.Amnt)#
#UCase(getTimeZone.Agency_State)# #getTimeZone.Agency_Zip# Due Date: 30 Days from invoice date

Bill To: #UCase(Getschedule.Pt_First)# #UCase(Getschedule.Pt_Last)#
#UCase(Getschedule.Pt_Street)#
#UCase(Getschedule.Pt_City)# #Getschedule.Pt_State# #Getschedule.Pt_Zip#
"> "> "> ">
Service Date Decription Charge Payment Adjustment Amount Adjustment Reason Payer Payment Due
#DateFormat(Visit_Date, 'mm/dd/yy')# #Skill# #DollarFormat(Total_Eclaim)# #DollarFormat(payment)# #DollarFormat(pt_row_total)# #adjust_reason# #Pay_Name# #DollarFormat(pt_row_total)#
Total #DollarFormat(total_pt_row_total)#
Send Payment to
#UCase(getTimeZone.Agency_Name)#
#UCase(getTimeZone.Agency_Address1)#
#UCase(getTimeZone.Agency_City)#
#UCase(getTimeZone.Agency_State)# #getTimeZone.Agency_Zip#
 		Cash or check. please make checks payable to:
#UCase(getTimeZone.Agency_Address1)#
#UCase(getTimeZone.Agency_City)#
#UCase(getTimeZone.Agency_State)# #getTimeZone.Agency_Zip#
To make payment by creditcard please call
#UCase(getTimeZone.Agency_Name)# at #getTimeZone.Agency_Contact_Phone#
UPDATE #Request.prefix_db_agency#.pSchedules SET pat_Invoice_ID = #invoiceid# WHERE Schedule_ID in (#Schids#) AND Assmt_ID = #Getschedule.Assmt_ID# UPDATE #Request.prefix_db_agency#.pat_Invoices SET InvoiceTotal = '#total_pt_row_total#', PayerBalance = '#total_pt_row_total#' WHERE pat_Invoice_ID in (#invoiceid#)
Page #cfdocument.currentpagenumber#