Questions How to Add Customers name on Inventory Transaction History

Create a DAC extension off the INTran DAC and add the following code.  Then you can add the Customer ID and name to the grid.

using PX.Data;
using PX.Objects.CR;
using PX.Objects.SO;

namespace PX.Objects.IN
{
    // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active
    public sealed class INTranExt : PXCacheExtension<INTran>
    {
        #region UsrBAccountID
        [PXInt]
        [PXUIField(DisplayName = "Customer")]
        [PXFormula(typeof(Selector<INTran.sOOrderNbr, SOOrder.customerID>))]
        [PXSelector(typeof(Search<BAccount.bAccountID>),
            SubstituteKey = typeof(BAccount.acctCD),
            DescriptionField = typeof(BAccount.acctName))]
        public int? UsrBAccountID { get; set; }
        public abstract class usrBAccountID : PX.Data.BQL.BqlInt.Field<usrBAccountID> { }
        #endregion
    }
}

Hi Kurt,

Sorry to jump in, thank you for your information.

I have try to add a DAC Extension and the code, but I didn't see any column "Customer" or Customer ID and name to the grid.

Please advise.

Thanks,
Idrus

Hi Kurt,

Posted by: @kurtybauer

You would still need to add the field to the grid on the screen.

I didn't see the "Customer" field after adding it to DAC, which step I miss?

@kurtybauer 

It's working fine with version 2019 R1 and make an error during Shipment Process in 2021 R1 related to "UsrBAccountID", so I have to remove the code.

Please advise.

Thanks,
Idrus