Hi All,

I hope everyone is doing good. I turned up here for a valuable advise from all of you experts.

My usecase is as below:

We have 2 objects "Accounts" and "Orders". I need to update one field on account object called as "Upgrade Order Status"(API Name- Upgrade_Order_Status__c) which is a text field with the value of "Order Status" field of only that Order where new Order is being created as Order Type = 'Upgarde Order' or an already existing order with Order type='Upgarde Order' and status is getting changed.

Order type is a picklist field on Order object having multiple values in which "Upgrade Order" is one of among them. Account can have multiple Orders with different Order Type.But my use case is to populate account's "Upgrade Order Status" field with the Order status field value of recently created order having order type= "Upgarde Order' OR there is a change in Order Status field of an already existing Orders of type "Upgrade Order".

Illustartion:
Account Name: Account Demo
has 5 Orders with different Order Type
1. Order1 with Order Type= "ABC" with Order Status= "New"
2. Order2-with Order Type= "Upgrade Order" with Order Status="Open"
3. Order3 with Order Type= "XYZ" with Order Status="Open"
4. Order4 with Order Type="Upgrade Order" with Order Status= "New"
5. Order 5 with Order Type="ABCQRS"with Order Status= "Closed"
So we need to populated "Upgrade Order Status" with the status value of recently created/changed Orders's Status where Order Type= "Upgrade Order".So if suppose among 5 above mentioned orders if Order 4 is recently created  orders with Order Type="Upgrade Order" then "Upgrade Order Status" on account should be populated with value "New" because Order 4 is having Order Status= "New".
In case if we modify Order 2 and changed the status from "Open" to "Closed" then "Upgrade Order Status" on account should be populated with value "Closed" because Order 2 is recently modified order with order type=Upgarde Order.

My issues is
Trigger is working for when I am creating new Order and status is getting copied to account's field OR when I am changing the status of Order then also status is getting copied to account's field. But its is working only for the recently cretaed Orders.It is not working when I tried to change the status of an older Orders with Order type= Upgarde Order then status is not getting copied to Account's field. 

Below is my Trigger Code:
 

trigger OrderTrigger on Order (after insert, after update) {

 Map<ID, Account> parentAccts = new Map<ID, Account>(); //Making it a map instead of list for easier lookup

Set<Id> setIds=new Set<Id>();

  for (Order childObj : Trigger.new) {
    setIds.add(childObj.Bill_to_Customer__c);
  }

 system.debug('The value is: ' + parentAccts);
  parentAccts = new Map<Id, Account>([Select id,Type,Upgrade_Order_Status__c,(Select id,Type,OrderNumber,Bill_to_Customer__c,Status from Orders where Type ='Upgrade Order') from Account WHERE ID IN :setIds]);


  for (Order order: Trigger.new){
      
      if(Order.Type=='Upgrade Order'){
      
     Account myParentAcct = parentAccts.get(order.Bill_to_Customer__c);
       system.debug('The value is: ' + myParentAcct.Upgrade_Order_Status__c );    
     myParentAcct.Upgrade_Order_Status__c = order.Status;
     
      }
  }
system.debug('The value is: ' + parentAccts);
  update parentAccts.values();
}

Account is Parent Object
Order is related object.

Kindly help/suggests on above.

Any help will be greatly appreciated

Many thanks in advance

Thanks & Regards,
Harjeet​