Help

1

How can i import initial inventory stock via inventory adjustment.

Avatar
Ahsan Islam

Please guide me a proper way to import initial inventory stock.

Avatar
Discard
3 Antwoorden
1
Avatar
Paresh Wagh
Best Answer

Hi Mohsin:

Assuming you have set up the Product Categories, Products, Costing/Valuation Method, Product Removal Method and mapped the Accounts, here are the steps to follow:

  • Activate Developer mode

  • Go to Inventory > Operations > Inventory Adjustments

  • Create a new Inventory Adjustment, enter a description, select All Products and Start Inventory

  • Odoo will copy all the Products into the Inventory Adjustment

  • Click the Details smart button on the top right of the adjustment

  • You can now Export all the products into a csv file, update the quantity in the csv file and re-import the file

  • Go back to the Inventory Adjustment and click Validate Inventory

This will create the corresponding stock/product moves and accounting entries.

NOTE: If you are using multi-warehouse/multi-location, you should set these up too before starting the inventory adjustment process since you will be doing the inventory adjustment for each stock location.

7 Comments
Avatar
Discard
Avatar
Ahsan Islam
-

Thanks Dear, you got my intention right :)

If there are multi locations and warehouses then how it'll be mentioned in my csv?

Avatar
Paresh Wagh
-

If you have multi warehouse/location, you will have to create an inventory adjustment for each stock location. When you activate multi warehouse/location, you will get a location field on the inventory adjustment firm. Specify the location and when you go into details, specify the quantities for that location only.

Avatar
Ahsan Islam
-

Got it :)

Thanks a lot.

Avatar
Ahsan Islam
-

I am facing an error.My environment is multi company. I have imported LOT nos and inventory adjustment and it worked fine but when i try to do the same in another company it gives a conflict on lot no. if lot no matches with other company it is not allowing me to access that existing nor nor it allows me to create it in another company.

Avatar
Ahsan Islam
-

Odoo Server Error - Access Error

×

The requested operation cannot be completed due to security restrictions. Please contact your system administrator.

(Document type: Stock Move, Operation: read) - (Records: [105], User: 2)

Avatar
ABDOU NASSER
-

actually I looked for the product_name but I don't see this field in the data to export when I choose "Export compatible with import". However, I want the product_name to appear in the csv or excel file after the export. How can I do that?

Avatar
Paresh Wagh
-

Expand the Product node on the left in the screen where you select the fields to be exported. One of fields will be Product/Name

0
Avatar
Johnny Solano
Best Answer

I am trying to do this with the steps described, but I receive this message "There is already one inventory adjustment line for this product, you should rather modify this one instead of creating a new one" any idea

Avatar
Discard
0
Avatar
Fernando La Chica Mera
Best Answer

The import of the initial stock does not have much complexity. What you should review is:

Do you have all the company's products registered?
Do you have their category correctly established?
Are stock valuation methods correctly set?
Do you have automatic posting? If yes, the accounting notes will be created and this should be taken into account

Avatar
Discard