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.