Skip to main content
Join the official 2019 Python Developers SurveyStart the survey!

Shows in the product inventory stock value and the accounting value and allows to reconcile them

Project description

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

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 smashing 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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for odoo10-addon-stock-valuation-account-manual-adjustment, version 10.0.1.0.0.99.dev2
Filename, size File type Python version Upload date Hashes
Filename, size odoo10_addon_stock_valuation_account_manual_adjustment-10.0.1.0.0.99.dev2-py2-none-any.whl (186.6 kB) File type Wheel Python version py2 Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page