Extending GLTran DAC to have customer/vendor class.

Based on what you’ve described, you’ve added the column to the database table and the DAC.  The value, however, will be null until you assign it.

What’s your intention on how to populate the contents of this field?  Automatically based on the value of another field in the same record? Or during data entry?

Hey @ddunn,

Yeah that makes sense.

I am trying to make it happen automatically, I am thinking that I can pull form the referenceID column and work my way back to a customer class with a search. 

at one point I was trying to us just:

[PXFormula(GLTran.referneceID)]

and that way filling in the referenceID, however when I tried to expand it into a search I couldn’t get it to show anything.

EDIT

@AidenMission i guess you noticed it but I meant to check == null then return not != null for return. 😝

 Thank you @aaghaei I haven’t gotten a chance to test it yet, ill be sure to make that little change when I can :^)

Reporting for completeness sakes, The customization works exactly as expected!

As @aaghaei said you have to fix the null checks against account, so I am going to paste the fixed code here to make it easier for others to see.

using PX.Data;
using PX.Objects.AP;
using PX.Objects.AR;

namespace PX.Objects.GL
{

    [PXNonInstantiatedExtension]
    public sealed class GLTranExt : PXCacheExtension<PX.Objects.GL.GLTran>
    {
        public static bool IsActive() => true;

        #region UsrMissionCustomerClass
        public abstract class usrMissionCustomerClass : PX.Data.BQL.BqlString.Field<usrMissionCustomerClass> { }
        [PXString(60, IsUnicode = true)]
        [PXUIField(DisplayName = "Customer Class", Enabled = false, Visible = true)]
        public string UsrMissionCustomerClass { get; set; }
        #endregion
    }

    // Graph Ext
    public class JournalEntryExt : PXGraphExtension<PX.Objects.GL.JournalEntry>
    {
        public static bool IsActive() => true;

        protected void _(Events.FieldSelecting<GLTran, GLTranExt.usrMissionCustomerClass> e)
        {
            var row = (GLTran)e.Row;
            if (row == null) return;

            if (row.Module == "AR" && row.ReferenceID != null)
            {
                Customer account = PXSelect<Customer,
                    Where<Customer.bAccountID, Equal<Required<Customer.bAccountID>>>>.Select(Base, row.ReferenceID);

                if (account == null) return;
                CustomerClass accountClass = PXSelect<CustomerClass,
                    Where<CustomerClass.customerClassID, Equal<Required<CustomerClass.customerClassID>>>>.Select(Base, account.CustomerClassID);

                if (accountClass == null) return;
                e.ReturnValue = accountClass.Descr;
            }

            if (row.Module == "AP" && row.ReferenceID != null)
            {
                Vendor account = PXSelect<Vendor,
                    Where<Vendor.bAccountID, Equal<Required<Vendor.bAccountID>>>>.Select(Base, row.ReferenceID);

                if (account == null) return;
                VendorClass accountClass = PXSelect<VendorClass,
                    Where<VendorClass.vendorClassID, Equal<Required<VendorClass.vendorClassID>>>>.Select(Base, account.VendorClassID);

                if (accountClass == null) return;
                e.ReturnValue = accountClass.Descr;
            }
        }
    }

    //Do not forget to ADD the "UsrClassName" to the Grid in your screen and set the CommitChanges = True
}

@AidenMission happy to hear you got what you needed.