SELECT pDeposit.*, IFNULL(payByIcn.payment_count,0) AS payment_count, IFNULL(remitAdjByIcn.adjustment_amount_total,0) AS adjustment_amount_total FROM #Request.prefix_db_agency#.pDeposit LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer payer ON payer.Pay_ID = pDeposit.Payer_ID LEFT OUTER JOIN ( SELECT i.Internal_Control_number, SUM(pay.Amount + pay.WriteOffAmount) AS payment_count FROM #Request.prefix_db_agency#.Invoices i JOIN #Request.prefix_db_agency#.Payments pay ON pay.Invoice_ID = i.Invoice_ID AND pay.Deleted <> 1 WHERE i.Deleted = 0 GROUP BY i.Internal_Control_number ) payByIcn ON payByIcn.Internal_Control_number = pDeposit.Internal_Control_number LEFT OUTER JOIN ( SELECT pd.Remit_No, SUM( CASE WHEN IFNULL(pr.Output,'') = 'Medicare' THEN IFNULL(pay.WriteOffAmount,0) ELSE IFNULL(vpAdj.visit_adjustment_total,0) END ) AS adjustment_amount_total FROM #Request.prefix_db_agency#.pDeposit pd JOIN #Request.prefix_db_agency#.Invoices i ON i.Internal_Control_number = pd.Internal_Control_number AND i.Deleted = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer pr ON pr.Pay_ID = i.PatientPayer_ID JOIN #Request.prefix_db_agency#.Payments pay ON pay.Invoice_ID = i.Invoice_ID AND pay.Deleted <> 1 LEFT OUTER JOIN ( SELECT Payment_ID, SUM( (CASE WHEN write_offcode <> 'PR' THEN IFNULL(write_offamount,0) ELSE 0 END) + (CASE WHEN second_write_offcode <> 'PR' THEN IFNULL(second_write_offamount,0) ELSE 0 END) + (CASE WHEN third_write_offcode <> 'PR' THEN IFNULL(third_write_offamount,0) ELSE 0 END) + (CASE WHEN fourth_write_offcode <> 'PR' THEN IFNULL(fourth_write_offamount,0) ELSE 0 END) ) AS visit_adjustment_total FROM #Request.prefix_db_agency#.Visits_payments WHERE Status = 0 GROUP BY Payment_ID ) vpAdj ON vpAdj.Payment_ID = pay.Payment_ID WHERE pd.Status = 0 GROUP BY pd.Remit_No ) remitAdjByIcn ON remitAdjByIcn.Remit_No = pDeposit.Remit_No WHERE pDeposit.Status = 0 AND pDeposit.Date_Deposit BETWEEN #CreateODBCDate(form.df)# AND #CreateODBCDate(form.dt)# AND pDeposit.Pay_Name like '#form.payer#' AND pDeposit.Payer_ID != 0 ORDER BY pDeposit.Remit_No DESC SELECT GetpDeposit.Pay_Name FROM GetpDeposit GROUP BY GetpDeposit.Pay_Name ORDER BY GetpDeposit.Pay_Name ASC

Search Remittance List

#remittance_error_message#

Enc_Agency_ID=encrypt(#getTimeZone .Agency_ID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex"); Upload 835 files New Remittance

Deposit From Date To Date

" /> to " />

Date Format: mm/dd/yyyy

Payer

Remittance Manager

Date Deposit	Date Check	Deposit Type	Check Total	Remit No	HCPCS	SVC04	SVC03	Adjustment Amount	Posted ICN	Visit Date	Pay Name	Net Total	Unposted payment
#DateFormat(Date_Deposit,"mm/dd/yyyy")#	#DateFormat(Date_Check,"mm/dd/yyyy")#	#Deposit_Type#	#Check_Total#	#Remit_No#	#HCPCS#	#SVC04#	#SVC03#	#DollarFormat(adjustment_amount_total)#	#Internal_Control_number#	#DateFormat(Visit_Date,"mm/dd/yyyy")#	#Pay_Name#	#Net_Total#	#Internal_Control_number# - style="color:red;font-weight:bold;" style="color:green;font-weight:bold;"> #DollarFormat(Net_Total)#