Skip to main content
Question

Prepare Replenishment Data View Override

  • April 28, 2023
  • 2 replies
  • 79 views

Forum|alt.badge.img

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

Forum|alt.badge.img
  • Author
  • Freshman I
  • April 28, 2023

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • June 14, 2023

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