Configuration

Assign the group ‘Stock Valuation Account Manual Adjustments’ to the users that should be allowed to list the valuation discrepancies and to reconcile them.

Usage

To use this module, you need to:

• Go to ‘Inventory / Inventory Control / Perpetual Inventory Valuation’
• Filter using the filter ‘Valuation Discrepancy’ which filters out products with no Valuation Discrepancy.
• Select the products that you wish to reconcile and press ‘Action / Adjust Stock Valuation Account Discrepancies’.
• You can provide Valuation Increase/Decrease Contra-Account. Otherwise the application will attempt to use the ones defined in the product category. Note that when the adjustment implies an increase of the valuation of your inventory (thus a debit), the account ‘Valuation Increase Contra-Account’) will be used in the credit side of the journal entry. And when the inventory valuation is going to decrease (credit), the account ‘Valuation Decrease Contra-Account’ will be used in the debit side of the journal entry. Typically the ‘Valuation Increase Contra-Account’ will be of type ‘Equity’ and ‘Valuation Decrease Contra-Account’ will be of type ‘Expense’.

Known issues / Roadmap

• In order to properly manage the inventory valuation from an accounting perspective all journal items created for inventory accounts should include the product.
• The price change function of Odoo creates journal entries to the inventory account without specifying the product. This is bad because you lose the ability to control the inventory valuation from accounting at the level of the product. In order to fix this, use the module ‘stock_inventory_revaluation’, to be found in the same OCA repository.

Points to be considered by contributors for future improvements are:

• This module does not support multi-company environments currently.
• Obtaining the valuation by product is currently mainly done by raw SQL queries. This could be improved to take advantage of ORM methods (like read_group)

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.

Credits

Maintainers

This module is maintained by the OCA.

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

This module is part of the OCA/stock-logistics-warehouse project on GitHub.

You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.