SELECT pDeposit.*, (SELECT SUM(Amount + WriteOffAmount) FROM #Request.prefix_db_agency#.Payments WHERE Payments.Invoice_ID = Invoices.Invoice_ID AND Payments.Deleted <> 1) AS payment_count FROM #Request.prefix_db_agency#.pDeposit JOIN #Request.prefix_db_agency#.Invoices ON Invoices.Internal_Control_number = pDeposit.Internal_Control_number LEFT OUTER JOIN #Request.prefix_db_agency#.pSchedules ON pSchedules.Invoice_ID = Invoices.Invoice_ID 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 GROUP BY pDeposit.Dep_ID ORDER BY pDeposit.Date_Deposit DESC SELECT GetpDeposit.Pay_Name FROM GetpDeposit GROUP BY GetpDeposit.Pay_Name ORDER BY GetpDeposit.Pay_Name ASC

Search Remittance List

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	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#	#Writeoff_Amount#	#Internal_Control_number#	#DateFormat(Visit_Date,"mm/dd/yyyy")#	#Pay_Name#	#Net_Total#	#Internal_Control_number#