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

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

By
Rajesh
on 12/3/15, 9:10 AM 656 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.


Regards,

Rajesh T K


0
Rajesh
On 5/9/16, 3:24 AM

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.

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

1 follower(s)

Stats

Asked: 12/3/15, 9:10 AM
Seen: 656 times
Last updated: 5/9/16, 3:24 AM