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

How to change all products income account?

By
Jim Biergans
on 10/8/13, 10:32 PM 1,345 views

I want to change all of my products assigned income account to a different income account. Is there a way to do this in OpenERP for all existing products? There are several thousand products, and I don't want to go through each one manually.

0
kalmenchia
On 10/8/13, 11:08 PM

Hi ,

you can use mass editing module , here is the detail , http://www.youtube.com/watch?v=9BH0o74A748

and all the useful module can be found here, https://code.launchpad.net/~server-env-tools-core-editors/server-env-tools/7.0

and for your case , after you check out the youtube , you can set up your mass edit configuration by selecting either the product.product or product.template , please look for the field , incoming account , then you should be able to do the changes.

hope that helps.

thank you! but i ran into 2 problems: 1. there's no "incoming account" field in either product table. 2. after adding the sidebar button, when i switch over to products, mass editing doesn't appear in the dropdown list, just share, embed, etc. (i used incoming_qty to test, saved it, etc.) i must have missed something...?

Jim Biergans
on 10/9/13, 5:58 PM

those informations are stored in the ir_property table. For product income account, look for "property income account" in name column and the column "res_id" for the product id, and "value_reference" for the reference to the account.

cd
on 10/10/13, 6:00 PM

got it working. thanks! big help!

Jim Biergans
on 11/14/13, 4:06 PM

Hi, I am facing the same issue, the mass editing does not appear in the drop-down list for product module.could you elaborate more on how you fixed your issue. Appreciate it a lot :)

Elie H. Nassif
on 2/18/14, 7:16 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: 10/8/13, 10:32 PM
Seen: 1345 times
Last updated: 3/16/15, 8:10 AM