Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Working around Open ERP since a long, a generic issue most comes is workflow stucked.
We create daily 100s of sales order, some of sales order stucked in workflow.
Like when sale order workflow at create invoice, & when try to create invoice related to it.
It just create new blank , just ugly openerp/odoo, never idetify what problem their.
Hi zahin,
same problem for me, I resolved it by sql query in "wkf_workitem" table.
The problem is that the status of the order lines is draft instead of done.
If you have managed it, please share!!
Sincerly,
Create an account today to enjoy exclusive features and engage with our awesome community!
Înscrie-te
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
@Zahin,
have you tried checking your logs, or changing the logs to debug sql or debug? This may help point you in the right direction of what is going wrong.
SOLUTION 1 Q1 => UPDATE wkf_workitem SET act_id = 128, state = 'complete' WHERE inst_id IN (SELECT id from wkf_instance WHERE res_id IN (SELECT distinct(s.id) FROM sale_order AS s LEFT JOIN sale_order_line AS l on s.id = l.order_id WHERE s.state = 'manual' AND l.state != 'done' ORDER BY s.id) AND res_type='sale.order' AND state='active') Q2 => UPDATE sale_order_line SET state = 'done' WHERE order_id IN (SELECT distinct(s.id) FROM sale_order AS s LEFT JOIN sale_order_line AS l on s.id = l.order_id WHERE s.state = 'manual' AND l.state != 'done' ORDER BY s.id) SOLUTION 2 Module sale_set_to_draft
act_id = 128, state = 'complete 128 => workflow action in manual state