Question

Prepare Replenishment Data View Override

  • 28 April 2023
  • 2 replies
  • 52 views

Userlevel 1
Badge

Hi ,

Version -22R1

Added one Custom Ware house Selector Client wants to Change the Custom Selector of Warehouse When he changed the Selector Value According to the value in the Detail level three fields data has to change 

 

 

Tried Modified data view using delegate but it is not affecting and tried writing code in Row Selected event then also it is not working please suggest me with the Solution

 

        INReplenishmentFilterExt ext = filter.GetExtension<INReplenishmentFilterExt>();
        if (filter.ReplenishmentSiteID != ext.UsrPurchaseWarehouse)
        {
                foreach (INReplenishmentItem item in Base.Records.Select())
            {
                INReplenishmentItem Rep = PXSelectJoin<INReplenishmentItem, LeftJoin<INItemClass,
                On<INReplenishmentItem.FK.ItemClass>>,
        Where<INReplenishmentItem.siteID, Equal<Required<INReplenishmentItem.siteID>>,
            And2<Where<
                Current<INReplenishmentFilter.itemClassCDWildcard>, IsNull,
                Or<INItemClass.itemClassCD, Like<Current<INReplenishmentFilter.itemClassCDWildcard>>>>,
            And2<Where<
                INReplenishmentItem.launchDate, IsNull,
                        Or<INReplenishmentItem.launchDate,
                        LessEqual<Current<INReplenishmentFilter.purchaseDate>>>>,
            And<Where<
                INReplenishmentItem.terminationDate, IsNull,
                        Or<INReplenishmentItem.terminationDate,
                GreaterEqual<Current<INReplenishmentFilter.purchaseDate>>>>

              >>>>>.Select(Base, ext.UsrPurchaseWarehouse);

                    if (Rep != null)
                    {
                        item.QtyReplenishment = Rep.QtyReplenishment;
                        item.QtyPOOrders = Rep.QtyPOOrders;
                        item.QtyPOPrepared = Rep.QtyPOPrepared;
                        Base.Records.Update(item);
                    }   //yield return item;
                        //}

}


2 replies

Userlevel 1
Badge

 

Userlevel 7
Badge

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

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved