We currently have a series of checkboxes on Service Contract that are checked/unchecked to show what "features" are associated with the
Service Contract, i.e. which products are included
So for example, we might have Service Contract 1 that has features A,B and C where A,B and C are Contract Line Items, when they are in
date and are therefore Active, we want the appropriate checkbox on the Service Contract to be checked.
This is all working fine except for when items that were created with future dates i.e. Inactive cross the date boundary and become Active.
We would like the trigger to fire for this occurrence so that we can update the checkbox, but it does not.
Is there a way to force the trigger to fire? I can't find a way of telling when the Status changes as this does not seem to create any events.
Any ideas gratefully received.
Regards,
David
답변 2개
As far as i got you question , this can be a possible solution for this:{considering you have contract as master and child contract line items}
1. You need to write a trigger on the contract line item with event After Update.
2.In your trigger get the id of the master (contract)
3. update the status on the master(contract).
