Can you check, if adding commitchanges = true will make any difference:

<px:PXMultiSelector runat="server" ID="CstPXSelector2" DataField="UsrWarehouse" CommitChanges="True" />

Hi @Yuriy Zaletskyy, 

thank you for your response. 

I have added commitchanges=true already but it doesn’t work :(

Can you attach here customization package, which I can play with on Sales demo?

Hi @Yuriy Zaletskyy,

please find the package in attachment.

You could find the source code in the description of topic. (data field DAC extension and Graph extensions)

Hi one more time. I wanted to see C# code, but I see only dll. Can you make package with C# code inside, or provide a class library?

Hi @Yuriy Zaletskyy , 

I attached class library. could you please check it?

Thanks

Before I’d suggest you workaround, want to explain, what I found.

1. Searching by SiteCD is not the best idea, because SiteCD is bound via PXProjection mechanism, and it seems, like it has some hard to catch bug
2. Seems like nice example of impedance mismatch, or Contains function doesn’t have nice reflection in SQL ( either MS SQL or MySQL )
3. In Request profiler I have found, that different versions of Contains, IsIn, In, etc.,,, generated = ‘warehouse 1; warehouse2; warehouse3’

As alternative, I’d suggest you to use code below, but with addiional tuning, as I’ve did my best to provide you with MVP only:

    public class INReplenishmentFilterExt : PXCacheExtension<PX.Objects.IN.INReplenishmentFilter>
    {
        #region UsrWarehouse
        bPXSelector(typeof(INSite.siteCD), typeof(INSite.siteCD), typeof(INSite.descr), ValidateValue = false, DescriptionField = typeof(INSite.siteCD))]
        bPXUIField(DisplayName = "Warehouse")]

        public virtual string UsrWarehouse { get; set; }
        public abstract class usrWarehouse : PX.Data.BQL.BqlString.Field<usrWarehouse> { }
        #endregion
    }

    public class INReplenishmentCreate_Extension : PXGraphExtension<PX.Objects.IN.INReplenishmentCreate>
    {
        public override void Initialize()
        {
            base.Initialize();
            BqlCommand cmd =
                new SelectFrom<INReplenishmentItem>();
            var f1 = new PXSelectDelegate(
                () =>
                {
                    return records1(Base);
                });
            Base.Views "Records"] = new PXView(Base, false, cmd, f1);
        }

        public virtual IEnumerable records1(PXGraph graph)
        {
            var cr = Base.Filter.Current;
            if (cr != null)
            {
                var ext = cr.GetExtension<INReplenishmentFilterExt>();

                var objs = ext.UsrWarehouse.Split(';').ToList().Select(a => a.Trim()).ToArray<String>();
                var listResults = new List<INReplenishmentItem>();

                var warehouses = SelectFrom<INSite>.Where<INSite.siteCD.IsIn<@P.AsString>>.View.Select(graph, newc]{ objs}).ToList(100);

                var wsIds = warehouses.Select(a => a.GetItem<INSite>().SiteID).ToList();

                return SelectFrom<INReplenishmentItem>.Where<INReplenishmentItem.siteID.IsIn<@P.AsInt>>.View.Select(graph, wsIds.ToArray());
            }
            else
            {
                return Base.Records.Select(Base);
            }
        }

overall want to say, that provided code is kind of ugly, but it worked on my machine. 

One more point, you can try to play with .In, IsIn instead of contains, but instead of passing SiteCD, try to pass SiteID. It increases chanced of success. 

Second point, provided code is kind of “hack” which I don’t like, but still allow myself to use, if other ideas doesn’t work.

Hello @Yuriy Zaletskyy, thank you very much for your answer.

It helps me a lot

Hello @Yuriy Zaletskyy,

Sorry for this inconvenient, I have a further question: Is it possible to add groupby InventoryID then sum QtyOnHand?

I spent a day on the internet but can’t research for a result. Could you please give me suggestion?

Thank you in advanced.

I’d prefer to have separate question for suchlike situations. Potentially someone else may use it for improving their reputation.

But this code seems working:

                return SelectFrom<INReplenishmentItem>
                    .Where<INReplenishmentItem.siteID.IsIn<@P.AsInt>>
                    .AggregateTo<GroupBy<INReplenishmentItem.inventoryID>, Sum<INReplenishmentItem.qtyOnHand>>
                    .View.Select(graph, wsIds.ToArray());

@Yuriy Zaletskyy thank you in advanced. I will create another topic next time with this kind of situation.

@Yuriy Zaletskyy can you please elaborate why did you introduce a view delegate for “Records” in  the graph initialization and added a new Method “records1” instead of directly overriding the “Records” view using a View Delegate?

@aaghaei because direct overriding of Records didn't work in scope of "Prepare Replenishment" page. Acumatica team implemented view Records in a quite different way 

Thanks for the clarification @Yuriy Zaletskyy