How to add patient.ChartNumber to Daily Payments Report

[dieutan]

Dear Everyone,

How to add patient.ChartNumber column to "Daily Payments Report" sheet?
I can add a patient.ChartNumber to SQL query, and a column to FormRpWriteOffSheet.cs using SetColumn but I don't know how to add the column to Daily Payments Report sheet.

Thanks in advance,
Dennis

[Tom Zaccaria]

In searching the database documentation I found that 'chart number' was used for previous programs'. I guess this means for docs that converted from another PMS.
OpenDental uses PatientNumber.

Does this help?

drtmz

[dieutan]

Hi Tom,
Chart Number is used in 14.1.18.0 version. I would like to know how to add a column in to "Daily Payments Reports".
I tried to edit PaymentRDL.txt file but I got following errors:
System.NullReferenceException: Object reference not set to an instance of an object.
at OpenDental.FormRpPaySheet.butOK_Click(Object sender, EventArgs e) in e:\work\OpenDental_12_4\OpenDental\Forms Reports\FormRpPaySheet.cs:line 537
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at OpenDental.UI.Button.OnClick(EventArgs ea) in e:\work\OpenDental_12_4\OpenDental\UI\Button.cs:line 153
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Thanks,
Dennis

[tgriswold]

As dieutan mentioned chart numbers are still in use. They are used for various reasons but are user editable. If you are looking on guidance on how to go about editing the code of that report to show chartnumber, I would urge you to create a post in the developer forums instead. Our payments report is very complex and has been changed a few times in the past few versions.

[dieutan]

Thanks Travis,
I'll post the question in developer forums.
Dennis