Get status changed date into a report.

Hi @apallawala21 ,

This can be achieved through customization.

Create a custom field in the table to update the date whenever the status changes from 'Open' to 'Completed.

You can include the custom field in the report.

Sample code:

1. Add the Custom Field in the DAC Extension

   public class SOOrderExt : PXCacheExtension<SOOrder>
       {
           [PXDBDate]
           [PXUIField(DisplayName = "Status Changed Date")]
           public DateTime? UsrStatusChangedDate { get; set; }
           public abstract class usrStatusChangedDate : PX.Data.BQL.BqlDateTime.Field<usrStatusChangedDate> { }
       }

    

2.  Implement the FieldUpdated Event Handler in the Graph Extension

   public class SOOrderEntryExt : PXGraphExtension<SOOrderEntry>
       {
           protected void _(Events.FieldUpdated<SOOrder, SOOrder.status> e)
           {
               SOOrder order = e.Row;
               if (order == null) return;
   
               // Check if the status changed to "Completed"
               if (order.Status == SOOrderStatus.Completed)
               {
                   SOOrderExt orderExt = PXCache<SOOrder>.GetExtension<SOOrderExt>(order);
                   orderExt.UsrStatusChangedDate = PXTimeZoneInfo.Now;
               }
           }
       }