Set default value for fields in Inventory Lookup dialog box in Sales Orders screen

In your Select Change the SiteID to SiteCD

Hi Reza,

Thanks for your response. This is how my code looks now, but unfortunately it still doesn’t work. Is it possible that this grid has some code in the business logic that is overriding my code?

Kind regards,

Andrew

protected void SOSiteStatusFilter_SiteID_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e)
    {
      if (e.Row == null) return;

      SOSiteStatusFilter row = (SOSiteStatusFilter)e.Row;
      INSite site = PXSelectReadonly<INSite, Where<INSite.siteCD, Equal<Required<INSite.siteCD>>>>.Select(Base, "MAIN");


      row.SiteID = site?.SiteID;
    }

When you trace, does “site” variable have value or is null?

Since this is a field defaulting event, you want to use

e.NewValue = site?.SiteID;
e.Cancel = true;

Or perhaps better, only assign a new value if the new value isn't null

if (site?.SiteID is null) return;

e.NewValue = site?.SiteID;
e.Cancel = true;

I have done something similiar on the PO line but i had to use a BQL data constant to hold the Code in my case ‘DropShip’

public class constantA : PX.Data.BQL.BqlString.Constant<constantA>
  {
  public constantA() : base("DROPSHIP") { }
  }

Then used this in the PXSelect to get the SiteID 

    INSite site = PXSelect<INSite, Where<INSite.siteCD, Equal<constantA>>>.Select(Base, row.SiteID);
      if (site !=null)
        {
    row.SiteID = site.SiteID;
          }

Hi @AndrewA were you able to find a solution? Thank you!