Enable Dark Mode!
how-to-set-up-initial-inventory-in-odoo.png
By: Anusha

How to set up initial inventory in Odoo?

Functional Odoo 10 Sales

Odoo inventory management is one of the important modules of Odoo ERP. The inventory management system keeps track of every product handled by an organization. The module can generate a dynamic inventory analysis report, which will help the user to keep the inventory healthy. Here in this blog, I will explain about Inventory adjustment operations in Odoo ERP.   

How to set up initial inventory in Odoo?
Initial inventory entry is made while creating the product, we have an option in product creation form to set the initial inventory of a product.
But you have to mark the ‘Inventory Adjustments’ option under the inventory tab of product form.

 - Create a product or product type Stackable product

how-to-setup-initial-inventory-in-odoo-1-cybrosys

 - Update the quantity on hand of the product by clicking on the Update Qty on Hand Button.
 - Now update the new quantity on hand
how-to-setup-initial-inventory-in-odoo-2-cybrosys

 - You can see a new inventory of the product is automatically created and validated by the system.

how-to-setup-initial-inventory-in-odoo-3-cybrosys

Other than the initial inventory adjustment, the user has the option to update the inventory of.
 * All products
 * One product category
 * Single product 
 * Selected products 
 * Single Lot/Serial Number
 * A Pack of products

1. Inventory adjustment of all products
 Through this option, we can update the inventory details of all products.  Choose the 'Inventory of' option as "All product" while creating a new inventory.

how-to-setup-initial-inventory-in-odoo-4-cybrosys

Inventory date: The date that will be used for the stock level check of the product and validation of the stock move related to the inventory.
Include Exhausted Products: Mark this, if you want to include the exhausting product in inventory.
Force Accounting Date: Choose the accounting date at which you want to value the stock moves related to this inventory.
Click start the inventory and system will display all the products with their Real quantity and Theoretical quantity.
Make adjustments in the quantity of the products and validate the inventory to update the new quantity.  Updated quantity will be displayed on the Inventory adjustment tab.

2. Inventory of one product category
If we want to make adjustments in the inventory of a single product category, we can select the one product category “inventory of” option. We have to specify the product category (to which we want to make changes) in the inventory adjustment form.

how-to-setup-initial-inventory-in-odoo-5-cybrosys

The rest of the procedures are as usual. Start the inventory adjust the stocks and validate the inventory. 

3. Inventory of One product only
Through this option, we can update the inventory of a single product.  We will have the option to specify the product in the inventory adjustment form.

For eg:- Suppose we want to update the inventory of a product's 'IPad retina display', then we can choose this option.  
When we validate the inventory we can see the stock quantity of that product.  We can edit the real quantity if any changes are there. 

Here in this example, I have updated the real quantity as 100.

how-to-setup-initial-inventory-in-odoo-6-cybrosys

how-to-setup-initial-inventory-in-odoo-7-cybrosys

Once the updates have been made validate the inventory. 
The updated product quantity, its source location, destination location as well as status can be seen under the inventory adjustment tab.

how-to-setup-initial-inventory-in-odoo-8-cybrosys

4.  Select products manually
Suppose we want to update the inventory of a number of items at a time.  In such cases, we can choose this method. 
We will have the option to select all the products we want to adjust. 

5. Inventory of One Lot/Serial Number
We can change the inventory status of products that bear a particular Lot/Serial Number. 
This is useful for updating the quantity of a large number of products in a particular Lot/Serial Number

how-to-setup-initial-inventory-in-odoo-9-cybrosys

When we start the inventory the products with corresponding lot numbers will be displayed under the inventory details.  

6. Inventory of a Pack
We can also create the inventory of a particular pack of products.
Select the inventory option Pack and we can add products to the inventory. Or when we start the inventory, we can see all the products of this particular pack in the inventory details.


If you need any assistance in odoo, we are online, please chat with us.



3
Comments

Harsha

Hi Anusha, Nice article. But I have a small doubt on Quantity on hand button, how did you enable that button. Now I am using Odoo 12 edition. Can you please help in updating the Quantity on hand for product. Thanks in advance. - Harsha

25/07/2019

-

4:11AM

Anusha

Hi Francisco Montano, You should enable the inventory valuation method to "Automatic". You can enable the feature in product category.

05/10/2018

-

4:36AM

Francisco Montano

i made a inventory initial adjustment, but it didnt generate accounting. what do you think I might be missing? thanks in advance

02/10/2018

-

1:42PM



Leave a comment

 


whatsapp_icon
location

Calicut

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

location

Kochi

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

location

Bangalore

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

Send Us A Message