Inventory-valuation-product-categorization-odoo.png
Blogger_636842438619363816.jpg
By: Meera K

Inventory Valuation and Product Categorization in Odoo

Having a precise inventory valuation is critical on the grounds that,  it is the reported measure of the stock or the inventory that influences the expense of goods sold, the net profit, and the overall gain on the income statement. Also, the accurate inventory valuation measures the current resources, working capital, investors' or proprietor's equity reported on the balance sheet.


This blog tales you down how to configure inventory valuation and product category in Odoo ERP.


One can easily categorize products in Odoo using the product category option. To enable, go to 


Inventory> configuration > products > product category


You can see the list of product categories in Odoo.


Inventory valuation and product categorization in odoo


Also one can create a new product category by clicking “create” button.


Inventory valuation and product categorization in odoo


Category Name: One can provide the new category name in the corresponding field.

 

Parent category: One can create the hierarchy of the product category by choosing the parent category.

 

Routes: Odoo enables the provision to define routes i.e. the option to describe a path for the product to move in accordance.

 

Force removal strategy: Select a specific removal strategy that will be used regardless of the source location for the product category.

 

There are 3 types of force removal strategy available in odoo,

 

1.First In First Out (FIFO): The product which has arrived first will get removed first from the stock.

2.Last In First Out (LIFO): The product which has arrived last will get removed first from the stock.

3.First Expiry First Out (FEFO): The product which gets firstly expired will be removed first from the stock.

 

Inventory Valuation


Costing Method:


1.Standard Price: The products are valued at their standard cost defined on the product.

2.First In First Out (FIFO): The products are valued supposing those that enter the company first and will also leave first.

3.Average Cost (AVCO): The products are valued at weighted average cost.

 

Inventory valuation:


1.Manual: The accounting entries to value the inventory are not posted automatically when a product enters or leaves the company.

2.Automated: An accounting entry is automatically created to value the inventory when a product enters or leaves the company.


For example, if the end user created two products namely automated product (inventory valuation is automated) and manual product(inventory valuation is manual). Then these two products are sold.


In the below picture you can see the sales order for the two products.



Inventory valuation and product categorization in odoo


When you process the delivery, the accounting entries to value the inventory for the automatic product are automatically generated. But for the manual product, accounting entries to value the inventory are not posted.


In the below image you can see the accounting entries to value the inventory for automatic products are posted.


Inventory valuation and product categorization in odoo


Product cost variation according to the inventory valuation:

When you select a standard price as costing the cost of the product will not be changed automatically.


You can only update the cost manually. By processing a sales order or purchase order it will not affect the standard price of the product.


Inventory valuation and product categorization in odoo


In the above image, the cost of the product is Rs 80. If you sell some product quantity, product cost remains the same.

 

Inventory valuation and product categorization in odoo


The above image shows that the sales order for the 3 Kg product (dragon fruit). After processing the sales order, the product costs remains the same. The below image shows the cost of the product, which is not changed after the sales.


Inventory valuation and product categorization in odoo


But when you choose the costing method as average cost and also purchasing the product with different price,  then the product cost changes automatically. But when you sell some quantity of this it will not affect the product cost. Here the cost of the product is 80 (When I created a product named dragon fruit, cost of the product was zero, then I purchased 10kg dragon fruit having price 80 Rs per kg, the cost of the product becomes 80. When you purchase another quantity of this product with different price, it will change the cost of the product. For example, purchasing 15kg of dragon fruit having price 90 Rs per kg.)


Inventory valuation and product categorization in odoo


Then the cost becomes 86.

[cost = (10*80+15*90) / 25=86]


Inventory valuation and product categorization in odoo


When you choose the costing method as FIFO and thereby selling the product, then the product cost will change automatically.


Here I am selling 5 products. (changed the costing method to FIFO).

 

Inventory valuation and product categorization in odoo


In FIFO, the product entering the stock will also leave first. So when I sold 5kg dragon fruits, it was taken from the stock in the purchased order. Which means products that I have purchased first will be sold first. Also, the cost of the product becomes the cost of the last moved product from the inventory.


Inventory valuation and product categorization in odoo


So the product cost becomes rs 80.

 

Variation in inventory value when choosing different costing method

 

1.Standard price

Value = Total quantity*Standard Price


For example ,quantity=15 and standard price of the product = 80 then value= 15 * 80 = 1200


Inventory valuation and product categorization in odoo


2.Average cost(AVCO)

Value = Quantity * cost of the product

(I have purchased 10 products at Rs 80 and 15 product at Rs 90 ,and sold 10 products Then, Cost of the product = 86 Quantity = 15,)

Value = 15 * 86 = 1290


Inventory valuation and product categorization in odoo


3.First in First Out(FIFO)

First I have purchased 10 products at Rs 80 , then 15 product at Rs 90 ,and sold 5 products Then, Value = 5 * 80 + 15 * 90 = 1750


Inventory valuation and product categorization in odoo


Account Properties:

Price Difference Account: The account will be used to value price difference between purchase price and accounting cost.


The price difference account is only applicable to Anglo-Saxon accounting.


If the price for a product in the purchase order and price in the purchase invoice is different, then the price difference account is used to hold the difference between these two product prices.


Income Account: This account will be used when validating a customer invoice, which means it will hold the details of invoiced amount (without tax). If you process a sales order which contains different products of different categories, then you can use different accounts for different product categories. So that you can easily understand the accounting details(product category wise income) of different product categories.


Expense Account: This account will be used when validating a vendor bill, which means it will hold the details of tax excluded amount in the vendor bill. If you process a purchase order which contains different products of different categories, then you can use different accounts for different product categories. So that you can easily understand the accounting details (product category wise expense) of different product categories.


Account Stock Properties:

Stock Input Account: If you are doing real-time inventory all incoming stock moves will be posted in this account Unless there is a specific valuation account set on the source location.


Stock Output Account: If you are doing real-time inventory valuation, all outgoing stock moves will be posted in this account, Unless there is a specific valuation account set on the destination location.


Stock Valuation Account: If you are doing real-time inventory valuation, this account is used to hold the current value of the products.


Stock Journal: When stock moves are processed all entries will be automatically posted in this account if the real-time inventory valuation is enabled.





Comments

2

Jôvani Moura

13/03/2019 - 4:20AM

What is the type of Accounts used in Account Stock Properties?


How this works in case of production? For example, Raw material A (1 unit) and Raw material B (1 unit) is consumed to produce Finished Product C. Cost of A = 100 Cost of B = 150 Finished Good product would be C = 150. However, the Inventory Valuation report is showing for C as still 0. How can we rectify this?




Leave a comment

 
Calicut

Cybrosys Technologies Pvt. Ltd.
Neospace, Kinfra Techno Park
Kakkancherry
Kerala, India - 673635

London

Cybrosys Limited
Alpha House, 100 Borough High Street,
London, Greater London,
SE1 1LB, United Kingdom

Kochi

Cybrosys Technologies Pvt. Ltd.
1st Floor, Thapasya Building,
Infopark, Kakkanad,
Kochi, India - 682030.

Bangalore

Cybrosys Techno Solutions
The Estate, 8th Floor,
Dickenson Road,
Bangalore, India - 560042

Send Us A Message