For the Existing product , How to update/change the product quantity stock in OpenERP having the same serial number ?
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
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
|Asked: 12/3/15, 9:10 AM|
|Seen: 531 times|
|Last updated: 5/9/16, 3:24 AM|