Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How to import quantity on hand?

By
Jeff Beidler
on 8/12/14, 1:53 PM 3,065 views

I have tried importing physical inventory via the Warehouse --> Physical Inventories screen, but it doesn't seem to have any effect.  The imported quantity shows up in the "General Information" tab, but after clicking on the "Confirm Inventory" and "Validate Inventory" buttons, the "Quantity On Hand" field in the Products screen still shows a zero.  Am I missing something?

Will you please tell us in which version you are working on and if possible can you please post screenshot of your warehouse records and physical inventory OR the structure of your warehouse (stock, input and output location)?

Serpent Consulting Services Pvt. Ltd.
on 8/13/14, 2:48 AM
0
Jeff Beidler
On 8/15/14, 12:41 PM

We are working in 7.0. We discovered, late yesterday, that it was the location field that seemed to be interfering. Or, more likely, the QoH field in the Products screen wasn't seeing the quantities from the location selected in the import. We were using "Physical Locations / Inventory" in our import file, and this would validate and import. It wasn't until we left this field empty that our imported quantities appeared in the Products screen. OpenERP defaults "Physical Locations / Your Company / Stock" as the location. This is okay for the moment, as we are just testing/evaluating, but we will need to be able to import quantities into different locations in the future.

Jeff, Usually, you should use the Physical Inventory utility for the Initial QoH field and choose the right location. You have to make sure to use the right CSV format while uploading the o2m field. In an another approach, create stock.move with destination location as stock and source as any virtual location, and set all moves done! Thanks.

Serpent Consulting Services Pvt. Ltd.
on 8/28/14, 12:17 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 8/12/14, 1:53 PM
Seen: 3065 times
Last updated: 3/16/15, 8:10 AM