Skip to Content

Stock Valuation By Unique Serial Number

by
Odoo

$ 285.28

v 15.0 Third Party 2
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Invoicing (account)
• Discuss (mail)
Lines of code 156
Technical Name stock_valuation_serial_number
LicenseLGPL-3
Websitehttps://www.eezee-it.com/
Versions 13.0 14.0 15.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Invoicing (account)
• Discuss (mail)
Lines of code 156
Technical Name stock_valuation_serial_number
LicenseLGPL-3
Websitehttps://www.eezee-it.com/
Versions 13.0 14.0 15.0

Stock Valuation By Unique Serial Number

Eezee-It

Features
  • Inventory valuation by unique serial number for product with AVCO(Average Costing) method.
Description

Standard Odoo Flow:

In Odoo Standard it is possible to select the following Costing Method : Average Cost (AVCO). This method allow to make a stock valuation in inventory. However this method is based on the units of the items entering and exiting the inventory. It is not based on the serial number level.

Customized Flow:

If a product is set as tracked 'By Unique Serial Number' and AVCO (Average Costing), this costing method will make the inventory valuation based on serial number.


Example

Consider the following example::

Product A is tracked 'By Unique Serial Number' with AVCO costing method.

Input1 (by a Purchase) of 10 units of product A with a price of 10 €/unit, all serial numbers are identified.
Input2 (by a Purchase) of 5 units of product A with a price of 5 €/unit, all serial numbers are identified.

Output1 (by a sales) of 5 units of product A (the 5 serial numbers are the ones from input2 at a price of 5€/unit)


Difference in valuation:

Standard Odoo Flow:

Input (10 units * 10 € + 5 units * 5 €) / 15 = 8.33€/unit or stock valuation 125 €.
Output ( 5 units * 8.33 €) = 41.65 € or stock valuation of 83.35 €.


Customized Flow:

Input (10 units * 10 € + 5 units * 5 €) / 15 = 8.33€/unit or stock valuation 125 €.
Output ( 5 units * 5 €) = 25 € or stock valuation of 100 €.


Odoo Services

Odoo Training Odoo Customization Odoo Migration
Odoo Integration Odoo Implementation
Odoo Consultancy Odoo Support

Odoo Support Services

We are building enterprise solutions available for all small & medium organisations with a higher growth rate.



         
Copyright Eezee-It All Rights Reserved | Privacy Policy

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 or have a question related to your purchase, please use the support page.
There are no ratings yet!
Functional
by
Ade Anshori
on 6/21/22, 5:18 PM

I need to put value on serial number when change manualy when do transfer

Valuation should be done for FIFO or AVCO too

Re: Functional
by
Gunther Clauwaert
on 6/23/22, 5:19 AM

Hi Ade, the module makes it possible to split the stock valuation layer by adding a serial numbers (lot_id), the rest is standard Odoo and both (FIFO and AVCO) costing methods are considered. Rgds, Gunther

Demo
by
Ade Anshori
on 6/21/22, 3:36 PM

Demo env

Re: Demo
by
Gunther Clauwaert
on 6/21/22, 4:15 PM

Hi Ade, Sorry we don't have a demo environment with this feature. Can you explain what you expect from the functionality that is explained?

Demo
by
Ade Anshori
on 6/21/22, 11:12 AM

Do you have demo?

Re: Demo
by
Gunther Clauwaert
on 6/21/22, 12:33 PM

Hi, Thanks for your interest in our modules. Do you mean a video or a Odoo demo environment with this feature? Rgds, Gunther