Hi,
I would like to set the quantity of all my products to 0 quickly (20.000 products).
By the web interface or even with a SQL request.
Any idea ?
Thanks
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Бухгалтерия
- Склад
- PoS
- Project
- MRP
Этот вопрос был отмечен
3
Ответы
20094
Представления
Hi,
Quantity On Hand is a function field. this is a calculated field so you can not change it.
in help :Quantity On Hand :Current quantity of products. In a context with a single Stock Location, this includes goods stored at this Location, or any of its children. In a context with a single Warehouse, this includes goods stored in the Stock Location of this Warehouse, or any of its children. In a context with a single Shop, this includes goods stored in the Stock Location of the Warehouse of this Shop, or any of its children. Otherwise, this includes goods stored in any Stock Location with 'internal' type.
to modifiy this quantity should be used import in Physical Inventory : Warehouse --> Inventory Control --> Physical Inventories .
doc openerp :https://doc.openerp.com/7.0/book/5/5_14_Stock/5_14_Stock_inv/#initial-inventory
Another solution is a small piece of python in your cutomisation module which loops on all products and sets quantities to zero (I'd say this is about 10 lines og python at most)
Can you write the code for multiwarehouse?
@arian_shariat yes you can. for assistance with low cost contact me on mujmi2@yahoo.fr
Go to Warehouse -> Products -> Click on 1 - 80 of ### -> Select Unlimited -> Use the checkbox on the left to select all -> Export -> Select Export All Data -> Add the field "Name" and "Quantity on Hand" -> Set to 0 -> Import back to OpenERP
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Регистрация| Related Posts | Ответы | Просмотры | Активность | |
|---|---|---|---|---|
|
1
мар. 15
|
5870 | ||
|
2
апр. 18
|
5605 | ||
|
1
окт. 23
|
1898 | ||
|
1
мар. 16
|
6854 | ||
|
1
мар. 15
|
6964 |
