Solved

How can the system automatically add previous Case history lines of the same customer to the "RELATED CASES" TAB?

  • 25 October 2023
  • 1 reply
  • 63 views

Userlevel 3
Badge

Hi Team,

We would like to implement the following feature.

When entering a customer into the Case screen => If that customer has had previous Cases, the system automatically adds rows of the previous Cases in “RELATED CASES” TAB and are arranged in CreatedDateTime of Cases.

 

 

I created Event RowInserted but haven't achieved results yet.
Please advise how to do this.

 

Note: Acumatica Version 2020R1

 

Best Regatrds,

NNT

 

//////////////////////////////////////////////////////

namespace PX.Objects.CR
{
  public class CRCaseMaint_Extension : PXGraphExtension<CRCaseMaint>
  {
    #region Event Handlers
   protected void CRCaseReference_RowInserted(PXCache cache, PXRowInsertedEventArgs e, PXRowInserted InvokeBaseHandler)
    {
      if(InvokeBaseHandler != null)
        InvokeBaseHandler(cache, e);
      var row = (CRCaseReference)e.Row;
            if (row == null)
            {
                return;
            }

            CRCase rRCa = Base.Case.Current;

            CRCase cRCase = PXSelect<CRCase,
                Where<CRCase.customerID, Equal<Required<CRCase.customerID>>>>.Select(Base, rRCa.CustomerID);
            if (cRCase == null) { return; }

            cache.SetValueExt<CRCaseReference.childCaseCD>(row, cRCase.CaseCD);
            cache.Update(row);
      
    }

    
    #endregion
  }
}

 

//////////////////////////////////////////////////////

 

 

icon

Best answer by Django 25 October 2023, 19:30

View original

1 reply

Userlevel 7
Badge +5

I think what you’re looking for is to add a view to the graph that pulls the records from CRCase that you want to display in the tab and the view will use .FromCurrent to filter based on the customer ID selected.

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