Odoo Help


For the Existing product , How to update/change the product quantity stock in OpenERP having the same serial number ?

Rajesh Narayanan T K
on 12/3/15, 9:10 AM 2,514 views

Hi all,

In Product Master- some product X ,  using Update in Inventory Tab, I updated the product  initial stock as 2000 units with serial number 1111.  So my stock becomes 2000 units. Later I purchased 1000 units on first day  with serial number 2222. My stock becomes 3000 units. Later I sold 1500 units  second day with serial number 1111.Remaining is 1500 units.

Later there is requirement to change the initial stock from 2000 to 3000 with same serial number 1111., so thatit becomes 4000 units after purchase on 1st day. After sales on second day remaining stock should be totally 2500 units ( 1500 with serial number 1111 and 1000 with serial number 2222).

How to update/change  this initial stock without affecting the sales and purchase product and its serial numbers.

When I tried changing the using the same Update in Product master , stock gets replaced. For Example I tried adding additional 1000 units with same serial number 1111 and unfortunately  stock value showing wrong number instead of remaining stock 1500 and stock valuation report gets messed up.

Kindly clarify and help me to update the correct stock. Thanks in advance.


Rajesh T K

Ritz Ann Alfaro
On 8/7/17, 8:49 PM

You can export and update the existing data then import the product with updated qty and serial to avoid time consuming and mistake. Go to Inventory>Inventory Control>Inventory Adjustment>List view>Click the import serial number.



I found the solution for this. Inventory adjustment in the Warehouse menu will make the stock increase or decrease based on the adjustment.

Real quantity and Theoretical Quantity will help to identify and change as per latest stock and serial number also can be updated.

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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 12/3/15, 9:10 AM
Seen: 2514 times
Last updated: 8/7/17, 8:49 PM