Allow Column Sorting in custom column

​@MarkD 

I don’t think you actually have to specify anything to be able to sort by that column. I am able to sort on my custom fields just after adding them to the screen.

Hi ​@aiwan maybe the rental agreement nbr field was added incorrectly. I’m also unsure, how the field was added into Invoices and Memos screen and extended as a column in Payments and Applications screen, but here’s what I found (see screenshots below). Could you please share how you added a custom field and how to extend it as a column on a different table?

That looks fine.

You will want to go into the ‘Screens’ section in the left hand toolbar, then click into ‘Payments and Applications (AR302000)’.

Then expand ‘Tab’ and then expand ‘Application History’.

From here you will be able to find the field, then remove it using the bin icon, to add it back you should go to ‘Add data fields’

Here, you should tick the field you want to use in the leftmost column, then press create controls.

Hope this helps.

If I understand it correctly, you want me to re-add the custom field and republish it?

Yes please.

Hi ​@aiwan - I got the same error after re-adding and republishing. There must be something missing. Any other thoughts?

Could you share the trace please?

Here you go:

Hello ​@MarkD ,

Since you are working with a bound field, start by verifying that the column actually exists in the ARRegister table within SQL. A missing column is a likely source of this issue.

Sorry, not so tech savvy. How do I actually verify that in Customization Project Editor?

To verify the field, first check the Database Scripts section within your customization project to ensure the UsrRANbr field is included in the ARRegister table script. Once confirmed, use the Publish to Multiple Tenants option in the Customization Projects screen, making sure to select Execute All Database Scripts.

However, the most direct method is to run a query via MySQL to confirm the column physically exists within the ARRegister table. This remains the simplest and most reliable way to verify the database schema.

Please try this, and if you still see an error, I will help to check if the column is actually located there without technical knowledge.
 

​@harutyungevorgyan - Sorry, I just got back. Looks like I need to unpublish customizations first before I can publish to multiple tenants and execute all database scripts.

I’ll let you know if that solves the issue.