Changing payment sort order

This forum is for programmers who have questions about the source code.
Post Reply
Mifa
Posts: 141
Joined: Wed Nov 21, 2007 6:52 pm
Location: Saint-Bruno, QC, Canada
Contact:

Changing payment sort order

Post by Mifa » Fri Dec 21, 2018 9:16 pm

Hi everyone,

In a previous version of OD I was able to make a small change into FormRpPaySheet.cs in order to have checks in the daily payment report ordered by check number instead of OD's default sorting. I don't seem to find a way to do that in 18.3. I've been looking at FormRpPaySheet and QueryObjects but could not find a function that would allow me to replace the default sorting. Any chance someone could point me in the right direction?

Thanks and a Happy Holiday Season to everyone!

Mifa

allends
Posts: 235
Joined: Fri Aug 23, 2013 11:29 am

Re: Changing payment sort order

Post by allends » Thu Dec 27, 2018 9:28 am

To be clear, you are asking about changing code in FormRpPaySheet.cs to order differently correct?

If so, the table which fills the Daily Payments report is filled in RpPaySheet.
Which method you use is dependant on if you have selected providers or not.
In our current HEAD version, this is what the code looks like.

Code: Select all

			DataTable tableIns=new DataTable();
			if(listProvNums.Count!=0) {
				tableIns=RpPaySheet.GetInsTable(date1.SelectionStart,date2.SelectionStart,listProvNums,listClinicNums,listInsTypes,
					listSelectedClaimPayGroupNums,checkAllProv.Checked,checkAllClin.Checked,checkInsuranceTypes.Checked,radioPatient.Checked,
					checkAllClaimPayGroups.Checked,checkShowProvSeparate.Checked);
			}
			DataTable tablePat=RpPaySheet.GetPatTable(date1.SelectionStart,date2.SelectionStart,listProvNums,listClinicNums,listPatTypes,
				checkAllProv.Checked,checkAllClin.Checked,checkPatientTypes.Checked,radioPatient.Checked,checkUnearned.Checked,checkShowProvSeparate.Checked);
You will want to look at those two methods.
Allen
Open Dental Software
http://www.opendental.com

Mifa
Posts: 141
Joined: Wed Nov 21, 2007 6:52 pm
Location: Saint-Bruno, QC, Canada
Contact:

Re: Changing payment sort order

Post by Mifa » Fri Dec 28, 2018 1:45 pm

Thanks Allen, this is what I was looing for.

Post Reply