I'm trying to enable stock valuation based on locations of stock moves, rather than on product category.
I created a new 'Inventory'-type location for the purpose and set its Stock Valuation Account (Incoming) and Stock Valuation Account (Outgoing) accounts to some appropriate balance sheet accounts. But when I try and process a stock move from a supplier location to this new Inventory location I get this error:
Can not create Journal Entry, Output Account defined on this product and Valuation account on category of this product are same.
This is because the destination location's account and the valuation account are both False; it's not retrieving the valuation_in_account from the move.location_dest_id. And I'm not setting a valuation account because there's no option to do so for a location.
Is this because I've configured this wrongly?
So just to make clear: what I'd like to be able to do is stock valuation based on locations only, not on product or product category.
Here's another example of how this fails. When receiving stock moves from suppliers, the moves cannot successfully create valuation account moves because the source of the move (the supplier location) does not---and cannot---have a valuation account; the stock location form view prevents setting valuation accounts for supplier locations.
Perhaps I need to define an intermediate location between supplier and physical stock, configure that location to create valuation account moves, and set up stock move chaining from supplier, through this intermediate location, to physical stock location?
I want to be able to report value of stock at locations on the balance sheet using automatically created account moves from stock moves, but setting the accounts for the automatically created moves using only the move locations, not the product or product categories.
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.
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!
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 2/22/13, 1:59 PM|
|Seen: 6401 times|
|Last updated: 3/16/15, 8:10 AM|