Changing payment sort order

This forum is for programmers who have questions about the source code.
Post Reply
Mifa
Posts: 137
Joined: Wed Nov 21, 2007 7:52 pm

Changing payment sort order

Post by Mifa » Fri Dec 21, 2018 10: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

User avatar
adearmondsattler
Posts: 166
Joined: Fri Aug 23, 2013 11:29 am

Re: Changing payment sort order

Post by adearmondsattler » Thu Dec 27, 2018 10: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 DeArmond-Sattler
Open Dental Software
http://www.opendental.com

Mifa
Posts: 137
Joined: Wed Nov 21, 2007 7:52 pm

Re: Changing payment sort order

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

Thanks Allen, this is what I was looing for.

Post Reply