Odoo Help

3

2
2 Answers
2
Avatar

Mohammad Alhashash Egypt

--Mohammad Alhashash--
2103
| 6 5 10
October City, Egypt
--Mohammad Alhashash--

Developer

Mohammad Alhashash Egypt
2/23/13, 8:05 AM

The location type 'Inventory' is not a physical location. It is a virtual location to represent the source/destination of inventory adjustment operations (matching the physical quantities to the recorded quantities). May be it is a misnomer but the help text gives a clear description about its function.

The 'Stock Valuation Account (Incoming)/(Outgoing)' accounts should be an income/expense accounts that will be affected by the increase/decrease of inventory value as a result of inventory operation.

You do not need separate account per location to track the value of product in it as quantity per location is known. But, it is not possible to have different product cost per location in standard OpenERP.

10 Comments
Richard Lewis
2/25/13, 5:30 AM

But you can't set the valuation accounts on a location if the location type is not either Inventory or Production; the view definition makes them readonly.

Mohammad Alhashash Egypt
2/25/13, 6:41 AM

You cannot have an a different valuation accounts for internal locations. You can enable the fields by changing the view, but you will break a lot of things. The help clearly says 'This has no effect for internal locations'

Richard Lewis
2/25/13, 7:07 AM

OK. I don't believe I'm attempting to set valuation accounts for internal locations.

Mohammad Alhashash Egypt
2/25/13, 7:41 AM

May be I misunderstood. Could you describe what do you mean by "valuation based on locations". Perhaps with the business case and expected account moves.

Richard Lewis
2/25/13, 7:47 AM

I want to be able to value my stock without setting valuation accounts on the products (or product categories). I would set valuation accounts on a variety of locations (e.g. factory, warehouse) and would be able to see the value of my stock at each location. The value would have been recorded by the stock moves that have passed through those locations.

Mohammad Alhashash Egypt
2/25/13, 8:18 AM

That was my understanding. This is not possible currently in OpenERP. You do not need separate account per location to get its stock value. The stock value per location is the value of products in it, which can be easily obtained.

Richard Lewis
2/25/13, 8:22 AM

And easily reported on the balance sheet?

Mohammad Alhashash Egypt
2/25/13, 8:27 AM

No. You have to create a special balance sheet report for that.

Richard Lewis
2/25/13, 8:36 AM

OK, thanks. Wish I'd known this wasn't possible before :-(

AD LIBITOM, michel Guénard France
3/22/13, 7:19 AM

I understand that you need to add some new costs to products when they are moved from one location to another one; these may be an allocation of "location costs" over each of the products.

2
Avatar

michel Guénard France

--michel Guénard--

1098
| 5 5 10
VIROFLAY, France
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard France
7/3/13, 10:53 AM

The question raised by Richard Lewis did not receive a satisfactory answer - in my opinion -.

There is probably not any ready answer with the current release of OpenErp (modules and addons). However this issue is of interest as far as I understand it.

The underlying need is to consider that when products move from one location to another one they receive added value, because the receiving location is a place where there are transformed in bulk. In a sense this is an extension of a MRP process affecting every single product passing thru the said location.

This would require to enlarge the MRP module

How SAP or Oracle do this would be interesting to know!

Ask a Question
Writer
Keep Informed
2 follower(s)
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register
Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now