We have setup new odoo account and want to import to our warehouse previous stock. Using the Inventory Adjustments "Physical Inventory" will allow us to enter the stock into our warehouse. In the stock valuation we can see the new stock allocated and a total value assigned to this stock.

However, we want this valuation to be assigned to the "Opening Balance Equity" account so we can run our financial report to show the opening stock balance and valuation. When we sell this historical stock we also want the "Opening Balance Equity" account to reflect the sale and reduce the total historical valuation by the amount that maps to the sale.

Not sure what is needed to do this or if there is another way to manage accounting for historical stock in odd v17? 

Looking for how to automate journal entry to the "Opening Balance Equity" account or if this is a manual step and how to ensure this old stock when sold will remove the value from the "Opening Balance Equity" account.

Any help much appreciated.