Odoo Help

Welcome!

This community 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.

0

update product categories account code

By
kim
on 7/15/13, 5:12 AM 1,250 views

Hi all,

I had import a lot of data in the system and now i want to change the product category Income Account do there have any way to update all the Income Account like using postgresql or any others way?

it said is product.category,property_account_income_categ but i go product_category from postgresql but cant found the property_account_income_categ

kim
on 7/15/13, 5:56 AM

or how to find the property_account_income_categ from postgresql, thanks you.

kim
on 7/15/13, 6:41 AM
0

Kevin McMenamin

--Kevin McMenamin--
804
| 5 2 6
Auckland, New Zealand
--Kevin McMenamin--
Kevin McMenamin
On 7/15/13, 8:02 PM

I think you will find these are property fields held in ir_property rather than directly on product category. Have a look at the data in the object - you should be able to sql update

Hi, Thanks alot finally i found it.

kim
on 7/16/13, 1:53 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 7/15/13, 5:12 AM
Seen: 1250 times
Last updated: 3/16/15, 8:10 AM