v 8.0 v 9.0 v 10.0 Third Party 535
Download for v 10.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Inventory Management (stock)
Invoicing (account)
Community Apps Dependencies
Technical Name stock_valuation_account_manual_adjustment
LicenseAGPL-3
Websitehttps://github.com/OCA/stock-logistics-warehouse
Versions 9.0 8.0 10.0
You bought this module and need support? Click here!

Stock Inventory Account Manual Adjustment

Beta License: AGPL-3 OCA/stock-logistics-warehouse Translate me on Weblate Try me on Runboat

This module shows in the product inventory stock value and the accounting value, and allows to create accounting adjustment entries to align the accounting value to match with the inventory stock value.

Table of contents

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

Authors

  • Eficent

Contributors

Maintainers

This module is maintained by the OCA.

Odoo Community Association

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.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.