Add customer order number on add payments on the bank deposit screen

Question

I am trying to add the customer order number on the add payments smart panel. I read that this can be done by using delegates, but I am struggling to get this to work.
I added the dac:

using PX.Data;
using PX.Objects.CA;
using PX.Objects.SO;

namespace PX.Objects.CA
{
public class PaymentInfoExt : PXCacheExtension<PaymentInfo>
{
#region UsrCustomerOrderNbr
[PXString(40)]
[PXUIField(DisplayName = "Customer Order Nbr", Enabled = false)]
public virtual string UsrCustomerOrderNbr { get; set; }
public abstract class usrCustomerOrderNbr : PX.Data.BQL.BqlString.Field<usrCustomerOrderNbr> { }
#endregion
}
}

using PX.Data;
using PX.Objects.AR;
using PX.Objects.CA;
using PX.Objects.SO;
using System.Collections;

namespace PX.Objects.CA
{
public class CATranEntryExt : PXGraphExtension<CATranEntry>
{
[PXOverride]
public virtual IEnumerable payments(Func<IEnumerable> baseMethod)
{
foreach (PXResult<PaymentInfo, ARPayment, ARInvoice, SOOrder> result in
PXSelectJoin<PaymentInfo,
LeftJoin<ARPayment,
On<ARPayment.docType, Equal<PaymentInfo.origDocType>,
And<ARPayment.refNbr, Equal<PaymentInfo.origRefNbr>>>>,
LeftJoin<ARInvoice,
On<ARInvoice.docType, Equal<ARPayment.docType>,
And<ARInvoice.refNbr, Equal<ARPayment.refNbr>>>>,
LeftJoin<SOOrder,
On<SOOrder.orderType, Equal<ARInvoice.soOrderType>,
And<SOOrder.orderNbr, Equal<ARInvoice.soOrderNbr>>>>>>
.Select(Base))
{
PaymentInfo payment = result;
SOOrder order = result;

var ext = PXCache<PaymentInfo>.GetExtension<PaymentInfoExt>(payment);
ext.UsrCustomerOrderNbr = order?.CustomerOrderNbr;

yield return payment;
}
}
}
}

Am I approaching this the correct way?

Abhishek Niikam · Accepted Answer

Hi ​@LungileNjakazi37I’m attaching the package that worked for me just publish it & look whether its working or not.

Abhishek Niikam · Answer

@LungileNjakazi37Hello,You can populate the custom field using the RowSelected event on PaymentInfo as shown below:public class CADepositEntry_Extension : PXGraphExtension{ protected void _(Events.RowSelected e) { if (e.Row == null) return; var ext = PXCache.GetExtension(e.Row); if (string.IsNullOrEmpty(ext.UsrCustomerOrderNbr)) { ARPayment arPayment = PXSelect>, And>>>> .Select(Base, e.Row.RefNbr, e.Row.DocType); if (arPayment != null) { ARAdjust adj = PXSelect>, And>>>> .Select(Base, arPayment.DocType, arPayment.RefNbr); if (adj != null) { ARInvoice invoice = PXSelect>, And>>>> .Select(Base, adj.AdjdDocType, adj.AdjdRefNbr); if (invoice != null) { SOOrder soOrder = PXSelectJoin, And>>>, Where>>> .Select(Base, invoice.RefNbr); if (soOrder != null) { ext.UsrCustomerOrderNbr = soOrder.CustomerOrderNbr; } } } } } }}This method ensures your custom field gets populated dynamically at runtime based on the associated Sales Order, without requiring database persistence.I hope it will help!