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