How to access Customer User-Defined Field in a new Processing screen View Delegate

Question

Hi Team,I have create a new processing screen and in view delegate trying to access a Use Defined Field value from Customer screen to show on UI and I am using 22.106.0015 build version. I have referred some community posts but not been able to access the defined field value. Below are the samples I have verified:The customer’s user defined field value stored in BAccountKvExt table and in DB able to access it but in code not able to access this table. Access User Defined Field from business logic | Community (acumatica.com) from this community post tried to access using new cache object but that also does not helps. public sealed class SOLineExt : PXCacheExtension { public static bool IsActive() { return true; } #region UsrEmployer [PXString()] [PXUIField(DisplayName = "Employer")] public string UsrEmployer { get; set; } public abstract class usrEmployer : PX.Data.BQL.BqlString.Field { } #endregion} public class LineProcessMaint : PXGraph { #region Views public PXCancel Cancel; public PXProcessing KitAssemblyProcess; #endregion protected IEnumerable kitAssemblyProcess() { foreach (PXResult result in PXSelectJoin, And>>, InnerJoin>, InnerJoin>>>>, Where>, OrderBy>>.Select(this)) { SOLine line = result; SOOrder order = result; SOShippingContact shippingContact = result; InventoryItem inv = result; SOLineExt lineExt = line?.GetExtension(); BAccount bAccount = PXSelect>>>.Select(this, order?.CustomerID); PXCache cache = base.Caches[typeof(BAccount)]; var attributeEMPLOYER = (PXStringState)cache.GetValueExt(bAccount, "AttributeEMPLOYER"); lineExt.UsrEmployer = attributeEMPLOYER; } } } Can you please review and help, Thank you in Advance !

Naveen Boga · Accepted Answer

@vivekm I have not verified this but can you try like below and verify.

 public class LineProcessMaint : PXGraph<LineProcessMaint>
    {
        #region Views
        public PXCancel<SOLine> Cancel;
        public PXProcessing<SOLine> KitAssemblyProcess;

        #endregion

        protected IEnumerable kitAssemblyProcess()
        {
            CustomerMaint customerGraph = PXGraph.CreateInstance<CustomerMaint>();
            foreach (PXResult<SOLine, SOOrder, SOShippingContact, InventoryItem> result in PXSelectJoin<SOLine, InnerJoin<SOOrder, On<SOOrder.orderType, Equal<SOLine.orderType>, And<SOOrder.orderNbr, Equal<SOLine.orderNbr>>>,
                                                InnerJoin<SOShippingContact, On<SOShippingContact.contactID, Equal<SOOrder.shipContactID>>,
                                                InnerJoin<InventoryItem, On<InventoryItem.inventoryID, Equal<SOLine.inventoryID>>>>>,
                                                Where<InventoryItem.kitItem, Equal<True>>, OrderBy<Desc<SOLine.orderNbr>>>.Select(this))
            {
                customerGraph.Clear();
                SOLine line = result;
                SOOrder order = result;
                SOShippingContact shippingContact = result;
                InventoryItem inv = result;
                SOLineExt lineExt = line?.GetExtension<SOLineExt>();

                customerGraph.BAccount.Current = PXSelect<Customer, Where<Customer.bAccountID, Equal<Required<Customer.bAccountID>>>>.Select(this, order?.CustomerID);

                var row = customerGraph.BAccount.Current;
                var cache = customerGraph.BAccount.Cache;

                var attributeEMPLOYER = (PXStringState)cache.GetValueExt(bAccount, "AttributeEMPLOYER");

                lineExt.UsrEmployer = attributeEMPLOYER;
            }
        }

    }

Naveen Boga · Answer

Hi @vivekm Yes, I too have this my mind but I don’t think we have another approach to fetch the UDF field value.

But I suggest an alternate solution for your customization to avoid the performance issue, check if this can works for you.

You can have the internal field for the UDF field in the SOOrder Extension, and add logic to when UDF is added, your internal field should be updated accordingly. For old records, you can run a script.

So that, in this processing you can fetch the field value simply from SOOrder DAC.

Hope this helps!

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded