Community mailing list archives

Re: Realtime inventory valuation

Mohamed Hagag
- 09/03/2015 16:01:17
Finally a PR & Commit

On 09/02/2015 11:46 PM, Mohamed M. Hagag wrote:
<blockquote cite="" type="cite"> Hi,

On odoo v. 8

Anyone got 100% accurate realtime inventory valuation accounts working with different UoM ( sell with KG and buy in Ton for ex.) ?

I have a problem in the stock out account that it never consider the UoM specified in the stock move and always uses the product sale UoM .

for example have a look at this journal entry:

in the below journal entry:

stock moves uses ton UoM while the sale UoM is Kg and the Ton cost is 2159.7 and the sale price is 2800 for Ton which is 2.8 for Kg .

It's expected for all journal items to use Kg prices ( 2.6 for cost and 2.8 sale ) .

Due date 
Analytic Account 
Amount Currency 
Partial Reconcile
SALE/15090221/0001 / cust 120010 Account Receivable 02/09/2015 28.00 0.00 0.00 0.00 Balanced this item computed in Kg sale price
SALE/15090221/0001 Prod1 cust 529000 Purchases - Resale Items 21,597.00 0.00 0.00 0.00 Balanced but this in Ton cost price
SALE/15090221/0001 prod1 cust 100402 Stock Out 0.00 21,597.00 0.00 0.00 Balanced
SALE/15090221/0001 prod1 cust 479100 Product Sales 0.00 28.00 0.00 0.00 Balanced

I believe this is a bug in the Real time valuation of the stock code - stock moves does not consider the UoM of the order / invoice .

Can anyone confirm this is bug ?!