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.

​@harutyungevorgyan - I’ve just published to multiple tenants and it still gave me the same error.

Hi ​@MarkD 

As of now, you are following all the steps correctly. I believe the issue might be coming from the DAC field. There could be something in the DAC definition that needs to be reviewed. Could you please share the DAC code so we can check and identify the root cause?

​@aryanjadhav50 - Here you go. Please note, the Rental Agreement Nbr field in Application history tab of Payments and Applications screen is inherited from AR Invoice

Hello ​@MarkD ,

Great news!! I’ve found a solution! It was a bit of a puzzle, but rest assured: you were doing everything correctly.

The issue is that the field you need doesn't exist in the ARRegisterAlias DAC. Since this specific DAC can't be modified using the standard no-code customization tools, we'll need to use a small code snippet to bridge the gap.

Here is the step-by-step guide to fixing this.

• Navigate to the Code Section: In your customization project, go to the Code tab on the left-hand sidebar.

• Create a New Entry: Click the + (Add) button.

• Select the File Template: Choose DAC Extension.

  • Base DAC: Search for and select ARRegisterAlias.

  • Click OK.

Update the Code: The system will generate a template and open the code editor. Locate the placeholder for UsrCustomField and replace it with your specific field code, which you can find below.
 

​​​​​​You can use the snippet below:

#region UsrRANbr
[PXDBString(50)]
[PXUIField(DisplayName = "Rental Agreement Nbr.")]

public virtual string UsrRANbr { get; set; }
public abstract class usrRANbr : PX.Data.BQL.BqlString.Field<usrRANbr> { }
#endregion