SELECT Pay_ID, Pay_Name FROM #Request.prefix_db_agency#.pPayer WHERE Status = 0 ORDER BY Pay_Name SELECT * FROM ( SELECT 'Invoice' AS adj_kind, i.Invoice_ID AS rec_id, i.Invoice_ID AS inv_id, i.adjusted_from_id, src.DateSent AS orig_date, src.lock_date AS orig_lock_date, src.ContractTotal AS orig_amount, i.DateSent AS new_date, i.ContractTotal AS new_amount, 0 AS new_writeoff, i.lock_date AS new_lock_date, i.Record_Created_Date AS created_date, CONCAT(IFNULL(emp.Emp_Last, ''), ', ', IFNULL(emp.Emp_First, '')) AS created_by, py.Pay_ID, py.Pay_Name, p.Patient_ID, p.Pt_Last, p.Pt_First, p.Pt_Agy_ID FROM #Request.prefix_db_agency#.Invoices i LEFT JOIN #Request.prefix_db_agency#.Invoices src ON src.Invoice_ID = i.adjusted_from_id LEFT JOIN #Request.prefix_db_agency#.pPayer py ON py.Pay_ID = i.PatientPayer_ID LEFT JOIN #Request.prefix_db_agency#.pPatients p ON p.Patient_ID = i.Patient_ID AND p.Status IN (#Request.patient_status#) LEFT JOIN #Request.prefix_db_lookup#.pEmployee emp ON emp.Emp_ID = i.Record_Created_By WHERE i.Agency_ID = AND i.Deleted <> 1 AND i.adjusted_from_id > 0 UNION ALL SELECT 'Payment' AS adj_kind, pm.Payment_ID AS rec_id, pm.Invoice_ID AS inv_id, pm.adjusted_from_id, src.PaymentDate AS orig_date, src.lock_date AS orig_lock_date, src.Amount AS orig_amount, pm.PaymentDate AS new_date, pm.Amount AS new_amount, IFNULL(pm.WriteOffAmount, 0) AS new_writeoff, pm.lock_date AS new_lock_date, pm.Record_Created_Date AS created_date, CONCAT(IFNULL(emp.Emp_Last, ''), ', ', IFNULL(emp.Emp_First, '')) AS created_by, py.Pay_ID, py.Pay_Name, p.Patient_ID, p.Pt_Last, p.Pt_First, p.Pt_Agy_ID FROM #Request.prefix_db_agency#.Payments pm JOIN #Request.prefix_db_agency#.Invoices i ON i.Invoice_ID = pm.Invoice_ID LEFT JOIN #Request.prefix_db_agency#.Payments src ON src.Payment_ID = pm.adjusted_from_id LEFT JOIN #Request.prefix_db_agency#.pPayer py ON py.Pay_ID = i.PatientPayer_ID LEFT JOIN #Request.prefix_db_agency#.pPatients p ON p.Patient_ID = i.Patient_ID AND p.Status IN (#Request.patient_status#) LEFT JOIN #Request.prefix_db_lookup#.pEmployee emp ON emp.Emp_ID = pm.Record_Created_By WHERE i.Agency_ID = AND pm.Deleted <> 1 AND pm.adjusted_from_id > 0 ) adj WHERE 1 = 1 AND adj.Pay_ID = AND (adj.new_date IS NULL OR DATE(adj.new_date) >= ) AND (adj.new_date IS NULL OR DATE(adj.new_date) <= ) ORDER BY adj.created_date DESC, adj.rec_id DESC

Billing Adjustments

Back

Bill / Payment Date FROM TO

to

Copies with no date entered yet are always listed.

Payer

Type

Adjustment Copies of Locked Invoices and Payments

Month locking is not set up for this agency yet (the ##10745 migration has not been run), so there are no adjustments.

No billing adjustments found.

Type	Adjustment	Copied From	Payer	Patient	Original Date / Amount	New Date	New Amount	Status	Created
#getAdjustments.adj_kind#	###getAdjustments.rec_id# Invoice ###getAdjustments.inv_id#	###getAdjustments.adjusted_from_id#	#getAdjustments.Pay_Name#	#getAdjustments.Pt_Last#, #getAdjustments.Pt_First# (#getAdjustments.Pt_Agy_ID#)	#DateFormat(getAdjustments.orig_date, "mm/dd/yyyy")# / #DollarFormat(Val(getAdjustments.orig_amount))# locked #DateFormat(getAdjustments.orig_lock_date, "mm/dd/yyyy")#	#DateFormat(getAdjustments.new_date, "mm/dd/yyyy")# Date not entered	#DollarFormat(Val(getAdjustments.new_amount))# write-off #DollarFormat(getAdjustments.new_writeoff)#	Locked (#DateFormat(getAdjustments.new_lock_date, "mm/dd/yyyy")#) Open – locks #DateFormat(billingLock.monthLockDate(getAdjustments.new_date), "mm/dd/yyyy")# Open – enter a date	#DateFormat(getAdjustments.created_date, "mm/dd/yyyy")# #getAdjustments.created_by#