Community mailing list archives

community@mail.odoo.com

Re: Realtime inventory valuation

by
John
- 09/03/2015 14:29:21
I don't have time to look incredibly closely yet to see if it is the same issue, but I did submit a similar issue and pull request a while back:

 
~John Walsh




On Thursday, September 3, 2015 12:20 PM, Mohamed M. Hagag <mohamedhagag1981@gmail.com> wrote:


Ok, I found the bug in the anglo-saxon module, and I attached a patch for it here.

here is the same journal entry for the same operation with the bug solved :

As we can see from the relative credits and debits, all journal items in the entry uses the same UoM which in this case is the Kg .

Items in red was before 21,597 which was caused by the bug computing the cost price of a Ton not Kg .

Invoice 
Name 
Partner
Account 
Due date 
Debit
Credit
Analytic Account 
Amount Currency 
Currency
__
__ 
Status 
Reconcile
Partial Reconcile
SALE/15090315/0001 / cust 120010 Account Receivable 03/09/2015 28.00 0.00 0.00 0.00 Balanced
SALE/15090315/0001 prod1 cust 529000 Purchases - Resale Items 21.60 0.00 0.00 0.00 Balanced
SALE/15090315/0001 prod1 cust 100402 Sold stock 0.00 21.60 0.00 0.00 Balanced
SALE/15090315/0001 prod1 cust 479100 Product Sales 0.00 28.00 0.00 0.00 Balanced


I made a comment describing the bug on github here:
https://github.com/odoo/odoo/commit/fb57514cf05953e4f22f75ead2503d05b9542610

BTW , if this is a bug - yes I'm still not sure - so it may be exist in v. 9 also .

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,

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe