I need to add “Subaccount Description” column to the DB grid on “Account by Subaccount” form (GL403000). The DAC “GLHistoryEnquiryResult” contains SubCD field which I want to use to link to “Sub” table to get the description. I extended the DAC as the following and modified ASPX. The column header is displayed, but no data in the new column. I tried to extend AccountHistoryBySubEnq Graph. But still not work.

public class GLHistoryEnquiryResultExt : PXCacheExtension<GLHistoryEnquiryResult>
{
    [PXString(60, IsUnicode = true)]
    [PXUIField(DisplayName = "Subaccount Description")]
    [PXDBScalar(typeof(Search<Sub.description, Where<Sub.subCD, Equal<GLHistoryEnquiryResult.subCD>>>))]
    public virtual string UsrSubaccountDescription { get; set; }
    public abstract class usrSubaccountDescription : PX.Data.BQL.BqlString.Field<usrSubaccountDescription> { }
}

enter image description here

This is for Acumatica 2024 R1 version. Has anyone done this before? I am new to Acumatica. If anyone has a example of adding a column to data grid, that would be helpful. Thanks!