Topic
1 reply Latest Post - ‏2012-12-12T20:43:04Z by SASHULL
SystemAdmin
SystemAdmin
5842 Posts
ACCEPTED ANSWER

Pinned topic Changing status from CLOSED to INPR

‏2012-12-05T14:02:35Z |
Hi,

I have a requirement to change the status of a WO which was wrongly moved to CLOSED from APPR status.

Could we just change the status of the record from the DB to INPROG and remove the CLOSED status historical entry from the WOSTATUS table ?

Are there any other additional changes that I may need to consider to ensure a smooth transition?

Thanks heaps in advance.
Updated on 2012-12-12T20:43:04Z at 2012-12-12T20:43:04Z by SASHULL
  • SASHULL
    SASHULL
    249 Posts
    ACCEPTED ANSWER

    Re: Changing status from CLOSED to INPR

    ‏2012-12-12T20:43:04Z  in response to SystemAdmin
    If you're in V4, there was a script that allowed you to reopen a closed work order. If you're in a later version.. this is definitely not supported and there is definitely more you need to review. As an example, ASSETHISTORY table is populated when the work order is closed/comp depending on your setting. Another example is if it's a PM based work order, you need to handle the last completed date and understand how it impacts other fields (potentially even other work order records that now exist).

    There's a lot of logic that comes into play during the COMP/CLOSE that you need to be careful of when trying to reopen a work order. Depending on what you're needing to change, it's much better to try to do a history edit on the record.