Adding a new column to the Inventory Summary grid using PXDBScalar?

Hi, @brothe58  I also verified from my end, PXDBScalar is not fetching the values by considering LocationID and SiteID.

As an alternative, I checked with the FieldSelecting event and it is working as expected. Below is the code for your reference.

Hope this helps!

using PX.Data;
using PX.Objects.IN;

namespace Test
{
    public class InventorySummaryEnqExt : PXGraphExtension<PX.Objects.IN.InventorySummaryEnq>
    {
        protected virtual void InventorySummaryEnquiryResult_UsrPickPriority_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e)
        {
            InventorySummaryEnquiryResult row = e.Row as InventorySummaryEnquiryResult;
            if (row != null)
            {
                INLocation objINLocation = PXSelect<INLocation, Where<INLocation.locationID, Equal<Required<InventorySummaryEnquiryResult.locationID>>,
                        And<INLocation.siteID, Equal<Required<InventorySummaryEnquiryResult.siteID>>>>>.Select(Base, row.LocationID, row.SiteID);
                if (objINLocation != null)
                {
                    e.ReturnValue = objINLocation.PickPriority;
                }
            }
        }
    }
    public class InventorySummaryEnquiryResultExt : PXCacheExtension<PX.Objects.IN.InventorySummaryEnquiryResult>
    {
        #region UsrPickPriority
        [PXInt]
        [PXDBScalar(typeof(Search<INLocation.pickPriority,
            Where<INLocation.locationID, Equal<Current<InventorySummaryEnquiryResult.locationID>>,
                And<INLocation.siteID, Equal<Current<InventorySummaryEnquiryResult.siteID>>>>>))]
        [PXUIField(DisplayName = "Pick Priority")]

        public virtual int? UsrPickPriority { get; set; }
        public abstract class usrPickPriority : PX.Data.BQL.BqlInt.Field<usrPickPriority> { }
        #endregion
    }
}