← Back to team overview

openerp-india team mailing list archive

[Bug 1284238] [NEW] Stock valuation misscalculation for product quantities with more than 2 decimal positions

 

Public bug reported:

Using OpenERP 7.0, Postgres 9.1, modules warehouse, account, and mrp_jit

Steps to reproduce the error:
1. Create a Product "A" of type stockable, costing method average price, and set proper accounts for stock valuation in the product category.
2. Create a Stock Move (Menu Warehouse/Traceability/Stock Move) with product "A" and quantity 9.043 from "Virtual Locations / Inventory loss" to "Physical Locations / Your Company / Stock" (this are the stock locations for loading the oppening stock), confirm the move an go to product (Menu Warehouse / Products / Product), select product "A" and verify the quantity. Quantity shows as 9.040. Note that quantity is wrong, it should be 9.043.

Cause of error: I think the problem is related to stock valuation,
although the inventory move is saved with 3 decimal positions the field
quantity in account.move.line is saved with only 2 decimal positions
(saves 9.04). Then the product quantity (product.product) is also
updated with only 2 decimal positions (9.04).

Could you please help confirm this is a bug and provide tip on how to
fix it?

** Affects: openobject-addons
     Importance: Undecided
         Status: New

** Summary changed:

- Automatic inventory valuation works only with two decimal positions
+ Stock valuation misscalculation for product quantities with more than 2 decimal positions

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1284238

Title:
  Stock valuation misscalculation for product quantities with more than
  2 decimal positions

Status in OpenERP Addons (modules):
  New

Bug description:
  Using OpenERP 7.0, Postgres 9.1, modules warehouse, account, and
  mrp_jit

  Steps to reproduce the error:
  1. Create a Product "A" of type stockable, costing method average price, and set proper accounts for stock valuation in the product category.
  2. Create a Stock Move (Menu Warehouse/Traceability/Stock Move) with product "A" and quantity 9.043 from "Virtual Locations / Inventory loss" to "Physical Locations / Your Company / Stock" (this are the stock locations for loading the oppening stock), confirm the move an go to product (Menu Warehouse / Products / Product), select product "A" and verify the quantity. Quantity shows as 9.040. Note that quantity is wrong, it should be 9.043.

  Cause of error: I think the problem is related to stock valuation,
  although the inventory move is saved with 3 decimal positions the
  field quantity in account.move.line is saved with only 2 decimal
  positions (saves 9.04). Then the product quantity (product.product) is
  also updated with only 2 decimal positions (9.04).

  Could you please help confirm this is a bug and provide tip on how to
  fix it?

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1284238/+subscriptions


Follow ups

References