0 Replies Latest reply on Nov 29, 2019 7:40 PM by Ivan Ruiz

    Approve Purchase Orders via SQL script

    Ivan Ruiz

      Hello Team,


      We constantly have stuck PO in 'In Process' status (we think the workflow is not working correctly). We are already investigating the cause but meanwhile we need a workaround to 'force' the approval of those stuck PO.


      Is there any SQL script to force those PO to be  approved directly from the Database or from the workflow administrator?


      We are currently using another workaround which resets them into 'Incomplete' status to be approved again by the financial office but sometimes, even reseting them and trying to approve them again, they get stuck again in 'In process' status and that's why we are looking for a SQL script to approve them by force directly from the database.


      Thank you