Skip to Content
Menú
This question has been flagged
1 Respondre
6536 Vistes

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.

Avatar
Descartar
Best Answer

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.

Avatar
Descartar