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.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
1
Reply
6442
Views
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...?
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.
got it working. thanks! big help!
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 :)
You can write server action and update all the records from ui or by some scrypt: https://www.youtube.com/watch?v=TXBjlnfbZg8&list=PLqRRLx0cl0hoOYZzwtNH_0bqgF_ROGa8w&index=4
Also check the module mass editing