About sc_request status management

[Kentaro Numata]

Hello, It's Ken.

Currently, we are using Flow Designer to update the status of sc_request records in our environment. Specifically, when an sc_req_item is closed, we use the "Update Record" action to update the parent sc_request status to Closed as well.

However, I am wondering if this approach to status management is a best practice. By design, a single sc_request can have multiple sc_req_items associated with it. Since our current implementation assumes a 1-to-1 relationship, it doesn't seem quite right.

So my question is: Is there an OOTB (Out-of-the-Box) feature that automatically closes an sc_request once all of its associated sc_req_items are closed?

[Ankur Bawiskar]

@Kentaro Numata 

my thoughts

-> there is this OOTB BR "Close Parent if Required" but for that you need to ensure your catalog item flow updates stage as that BR is handling stage change

-> if you are not managing stage then have custom after update BR on RITM table and close the REQ once the last RITM under that REQ is closed

Business Rule to close Parent REQ when all RITM is closed 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏