Odoo Aide

3

0
1 Réponse
1
Mohamed arif Inde
09/04/2013 07: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 Commentaires
ton123 Pays-Bas
09/04/2013 10:31

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

Nikolaj
09/04/2013 13: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
09/04/2013 13: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

Poser une question
Writer
Étiquettes
Keep Informed
0 Abonné(e)s
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