Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
7599 Tampilan

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?

Avatar
Buang

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.

Jawaban Terbai

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.

Avatar
Buang
Penulis

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.

Penulis

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!

Penulis

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.

Penulis

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?

Penulis

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.

Penulis

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...

Penulis

I just had that lightbulb moment. Going to try re-structuring my locations now. Thanks! :)

Penulis

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

Post Terkait Replies Tampilan Aktivitas
1
Mar 15
3449
5
Jul 20
6740
0
Jul 15
3933
1
Mar 15
11011
2
Des 23
44197