openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #27327
[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