Apparently, the inventory import is significantly different in V8 from what it was like in V7. What I had done in V7 no longer works. Any clues as to the proper method?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
1
Reply
7571
Views
The easiest way is to input Inventories per stock location, which will create the stock moves, and at validation the stock.quant to have Qty on hand.
I am trying to import by location, but nothing seems to work. I have created an inventory record/reference, and put the reference in my import, but after importing, the QoH still shows as 0.00 for all products.
I think you're on the right track with stock moves. I am able to import quantities in various locations through the Stock Moves screen. However, there doesn't appear to be any way to confirm (set status to "Done") all of the imported records at once. You end up with one stock move record per item/location you import. I could go through each record manually, clicking the "Process Entirely" button, but there *must* be a better way!
Oh, forgot to add that I was using a value of "Virtual Locations / Procurements" for the Source Location field, in order to get an initial QoH.
Unfortunately, the imported QoH number is not shown in the Product page. It does appear if you go to a location and click the "Current Stock" button.
Are youre products set as 'product' and with 'make_to_stock' route?
Looks like all products have "product" in the "type" field, and either "Buy" or "Manufacture" in the route field. I think that's how I imported them. We discovered yesterday that if you import to the default location of "WH/Stock", then the QoH will be reflected on the Products page. However, we need to have multiple stock locations, an have the QoH show the sum on the products page.
Perhaps I imported "routes" incorrectly? In OpenERP 7, there was a "procure_method" field, which we had populated with either "Buy" or "Manufacture". I didn't see this in Odoo 8, but it looked like the "routes" field had those two options, so that's what I used.
Then you can put all this locations as childs of stock or change the code of qty avail to take all internal locations into consideration...
I just had that lightbulb moment. Going to try re-structuring my locations now. Thanks! :)
Is it not possible to set a stock location for a warehouse in v8? This is kind of getting away from the original question, so I started a new one: https://www.odoo.com/forum/help-1/question/how-do-you-specify-the-stock-location-for-a-warehouse-in-odoo-8-64486
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
|
1
Mar 15
|
3439 | ||
|
5
Jul 20
|
6688 | ||
|
0
Jul 15
|
3918 | ||
|
1
Mar 15
|
10971 | ||
|
2
Dec 23
|
44163 |
Quantity on hand is now based on Quants, which is a table that didn't exist before v8. Those would probably have to be generated to migrate a v7 database. No idea how to do that unfortunately.