Odoo Help

3

0
1 إجابة
1
Mohamed arif الهند
9‏/4‏/2013 7:07 ص

Since you need those purchase order only for reference, better to directly update its state to done by a invoking direct sql in database. You have to set 'done' for field 'state' in the table purchase_order.

3 التعليقات
ton123 هولندا
9‏/4‏/2013 10:31 ص

This answer is to short for me. Can you be more specific or give an example?

Nikolaj
9‏/4‏/2013 1:19 م

If you use pgAdmin3 you can access the DB tables by opening your DB in the Object browser then navigating to Tables by expanding DB > Schemas > public > Tables. Find purchase_order in the list and edit away - I am just testing this method now. Thanks Arif!

Nikolaj
9‏/4‏/2013 1:44 م

I ran an update script using pgAdmin3 which updated all states from 'draft' to 'done'. Here is a tutorial on SQL Update http://www.w3schools.com/sql/sql_update.asp

اطرح سؤالاً
Writer
الوسوم
Keep Informed
0 متابعين
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register
Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now