Odoo Help


Stock Movement

George Wong
on 3/19/13, 5:22 PM 1,309 views

When I review the Stock by Location for a product, it seem that certain transactions are not created to insure integrity via double entry. The following are some issues:

  1. When a purchase order is confirmed for a product no offsetting entry is created in the Partner/Supplier location but there is a transaction to move from Partner/Supplier to Location Stock so the Stock by Location is a negative number which decreases upon each PO.
  2. When the product is used as a component within production location the Stock by Location value always increases. There is a inventory move from stock location to the production location thus positive amount but no offsetting transaction when the product is consumed.
  3. When a product is manufactured at a production location the stock is not increased so when the product is delivered to next location the stock is negative and grows negatively with each manufacturing order.
  4. When a Sales Order is created, I would expect an entry would be created in the Partner/Customer location so when a delivery of the product would offset the SO. the delivery order does create the in entry into the Partner /Customer location but no offsetting entry.

It seems the SO, PO and MO does not create the initial stock entries for the products.


AJ Schrafel Paper Corp

--AJ Schrafel Paper Corp--
| 4 5 8
Bronx, United States
--AJ Schrafel Paper Corp--

Exploring OpenERP for business

AJ Schrafel Paper Corp
On 3/19/13, 5:28 PM

The stock_move table holds all the entries for verifying inventory transactions.

You would have to view it in the database because I don't believe there is a way to display a listing of stock_move in the openERP user interface.

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: 3/19/13, 5:22 PM
Seen: 1309 times
Last updated: 3/16/15, 8:10 AM