Community mailing list archives

community@mail.odoo.com

Re: Realtime inventory valuation

by
Mohamed Hagag
- 09/03/2015 06:44:06
Dears,

What's the code responsible for stock sale real time valuation ?

I looked in stock_account module but it doesn't seem to have any issue.

And the below table I'm selling 10 Kg priced 2.8 for 1 kg and it's OK for sale and AR entries but stock valuation entries are wrong as they use the value of 10 Tons not Kg .

Am I the only one get this issue ? - also I tried many real time stock valuation accounts configs and all have the same results.

Plz help me find a solution. Also please keep in mind that this happens in sales only - purchases are OK .

Should I report a bug ? can anyone confirm this is a bug ?

Regards,

On 09/02/2015 11:46 PM, Mohamed M. Hagag wrote:
<blockquote cite="mid:55E76E44.5010804@gmail.com" 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 ) .


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,