Community mailing list archives

community@mail.odoo.com

Realtime inventory valuation

by
Mohamed Hagag
- 09/02/2015 17:46:44
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 ) .


nvoice 
Name 
Partner
Account 
Due date 
Debit 
Credit 
Analytic Account 
Amount Currency 
Currency
__
__ 
Status 
Reconcile
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 ?!

Regards,