how-to-set-up-initial-inventory-in-odoo.png
Blogger_636313953779118730.jpg
By: Anusha

How to set up initial inventory in Odoo?

Odoo inventory management is one of the important modules of Odoo ERP. The inventory management system keeps the track of every product handled by an organization. The module can generate 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 exhausted 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 inventory adjustment form.

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

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 inventory adjustment form.

For eg:- Suppose we want to update the inventory of a product '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 number 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.




Comments

2

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


Francisco Montano

02/10/2018 - 1:42PM

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




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