Hi Marven,
As suggested by Steven, WO re-open from CLOSED status is not supported.
But, I understand that there are a number of scenarios where you would need to reopen the work order and I believe one such is your scenario.
There is also a way to use 'Edit History Work Order' as suggested by Peter McDonald.
If Edit History Work Order does not satisfy your situation, like you can't create invoices using edit history work orders, then you can need to reopen the work order to COMPLETED status using backed update queries.
As suggested by Steven, there are a number of things that happen in Work Order closure and the update queries suggested here only works for invoicing. If you have any other scenario then that is not tested for this kind of back end reopening of Work Order and you might face errors or exception which will need fixing.
Here below are the things I used to do to reopen closed work orders to COMP status using sql update queries:
1. Set the Work Order status to COMP
2. Update WOSTATUS table entry for CLOSED with status value as REOPENED( you can use your own value) and update memo with more information related to the reopening of work order
3. Clear entries in the Assethistory table for the work order which gets created during closure of work order
4. Update work order history flat to 0.
5. I think you will have to remove entry in the asset hierarchy table as well but not sure.
Please note again, I do not recommend this approach and it must be done if absolute necessary.
Also, I would recommend reevaluating the 90 days Work Order closure logic. You can move the Work Order to some intermediate status post COMP and restrict Work Tracking to fetch work order with this status. Later close the work order may be after 6 month or more.
Thanks,
------------------------------
Biplab Choudhury
BPD Zenith Australia
------------------------------
Original Message:
Sent: 09-16-2022 17:20
From: Marvin R
Subject: can "Closed" status be revert back to "Completed"
Greetings fellow Maxusers,
we completed an escalation segment which closed WO's after 90 days, however there is an issue with a group of job plans that need to remain with status "completed" so is there any way we can revert back from "Closed" status to "Completed" I would highly appreciate any information that can be shed into this matter.
Thank you.
#EverythingMaximo
------------------------------
Marvin R
------------------------------