Odoo 도움말

3

0
1 응답
1
Mohamed arif India
13. 4. 9. 오전 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 Netherlands
13. 4. 9. 오전 10:31

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

Nikolaj
13. 4. 9. 오후 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
13. 4. 9. 오후 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