Stock Valuation Layer Usage

Trace where has the stock valuation been used in, including the quantities taken.

https://odoo-community.org/web/image/product.template/9085/image_1920?unique=4e4bb62
  • Odoo Version

Terms and Conditions 

Stock Valuation Layer Usage

Alpha License: AGPL-3 OCA/stock-logistics-workflow Translate me on Weblate Try me on Runboat

This module allows to trace the usage of stock valuation layer. That is, makes it possible to identify in what stock moves was a given valuation layer used, and how much quantity was taken by the particular stock move.

This kind of traceability is important in case that at some point you want to conduct an revaluation (for example, in case that the purchase order price changes after the products have been received into stock).

Also, it changes the way the outgoing layers are created in order to respect the MTO case. When creating the out svl, Odoo takes the first layer available with value. The module stock_valuation_layer_usage arises an issue with that Odoo process. Odoo will take always the oldest svl. However, that is not the case for MTO. When there is a fixed link between the incoming move and the outgoing move, at the time of creating the outgoing svl the system should take the specific incoming svl not just the oldest one. Also, when the case is not MTO, the system should avoid using svl that are "reserved".

Important

This is an alpha version, the data model and design can change at any time without warning. Only for development or testing purpose, do not use in production. More details on development status

Table of contents

Installation

This module depends on the OCA module 'stock_account_product_run_fifo_hook', available in the same OCA repository https://github.com/OCA/stock-logistics-workflow.

Usage

  • Create a product with that uses a category with automatic inventory valuation and FIFO costing method.
  • Create a purchase order for this product and receive it into stock.
  • Deliver the product to a customer and check the completed stock move in 'Inventory / Reporting / Stock Moves'. You will see a section 'Valuation Layers' where you will be able to identify the valuation layers that were used to value this move, and the quantity and value that was taken.
  • Create several MTO order
  • Deliver the products to a customer in a random way and check the section 'Valuation Layers Usage'. The MTO logic is respected, then FIFO applies.

Changelog

13.0.1.0.0 (2020-01-03)

  • [13.0][MIG] stock_valuation_layer_usage Create module

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

  • ForgeFlow

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-workflow project on GitHub.

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

This is a preview of the recently viewed products by the user.
Once the user has seen at least one product this snippet will be visible.

Recently viewed Products