Skip to Content
Odoo Menu
  • Prijavi
  • Try it free
  • Aplikacije
    Finance
    • Knjigovodstvo
    • Obračun
    • Stroški
    • Spreadsheet (BI)
    • Dokumenti
    • Podpisovanje
    Prodaja
    • CRM
    • Prodaja
    • POS Shop
    • POS Restaurant
    • Naročnine
    • Najem
    Spletne strani
    • Website Builder
    • Spletna trgovina
    • Blog
    • Forum
    • Pogovor v živo
    • eUčenje
    Dobavna veriga
    • Zaloga
    • Proizvodnja
    • PLM
    • Nabava
    • Vzdrževanje
    • Kakovost
    Kadri
    • Kadri
    • Kadrovanje
    • Odsotnost
    • Ocenjevanja
    • Priporočila
    • Vozni park
    Marketing
    • Družbeno Trženje
    • Email Marketing
    • SMS Marketing
    • Dogodki
    • Avtomatizacija trženja
    • Ankete
    Storitve
    • Projekt
    • Časovnice
    • Storitve na terenu
    • Služba za pomoč
    • Načrtovanje
    • Termini
    Produktivnost
    • Razprave
    • Odobritve
    • IoT
    • Voip
    • Znanje
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industrije
    Trgovina na drobno
    • Book Store
    • Trgovina z oblačili
    • Trgovina s pohištvom
    • Grocery Store
    • Trgovina s strojno opremo računalnikov
    • Trgovina z igračami
    Food & Hospitality
    • Bar and Pub
    • Restavracija
    • Hitra hrana
    • Guest House
    • Beverage Distributor
    • Hotel
    Nepremičnine
    • Real Estate Agency
    • Arhitekturno podjetje
    • Gradbeništvo
    • Estate Management
    • Vrtnarjenje
    • Združenje lastnikov nepremičnin
    Svetovanje
    • Računovodsko podjetje
    • Odoo Partner
    • Marketinška agencija
    • Law firm
    • Pridobivanje talentov
    • Audit & Certification
    Proizvodnja
    • Tekstil
    • Metal
    • Pohištvo
    • Hrana
    • Brewery
    • Poslovna darila
    Health & Fitness
    • Športni klub
    • Trgovina z očali
    • Fitnes center
    • Wellness Practitioners
    • Lekarna
    • Frizerski salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Sistemi sončne energije
    • Izdelovalec čevljev
    • Čistilne storitve
    • HVAC Services
    Ostali
    • Neprofitna organizacija
    • Agencija za okolje
    • Najem oglasnih panojev
    • Fotografija
    • Najem koles
    • Prodajalec programske opreme
    Browse all Industries
  • Skupnost
    Learn
    • Tutorials
    • Dokumentacija
    • Certifikati
    • Šolanje
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Prenesi
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Dogodki
    • Prevodi
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Sklici kupca
    • Podpora
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Določanje cen
  • Pomoč

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Knjigovodstvo
  • Zaloga
  • PoS
  • Projekt
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
Pomoč

How do you import Quanity on Hand in Odoo 8?

Naroči se

Get notified when there's activity on this post

This question has been flagged
v8importQOH
1 Odgovori
8334 Prikazi
Avatar
Jeff Beidler

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?

1
Avatar
Opusti
Brett Lehrer

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.

Avatar
NextERP Romania SRL
Best Answer

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.

0
Avatar
Opusti
Jeff Beidler
Avtor

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.

Jeff Beidler
Avtor

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!

Jeff Beidler
Avtor

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.

Jeff Beidler
Avtor

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.

NextERP Romania SRL

Are youre products set as 'product' and with 'make_to_stock' route?

Jeff Beidler
Avtor

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.

Jeff Beidler
Avtor

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.

NextERP Romania SRL

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

Jeff Beidler
Avtor

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

Jeff Beidler
Avtor

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!

Prijavi
Related Posts Odgovori Prikazi Aktivnost
Where are the rest of the records? Solved
v8 import
Avatar
1
mar. 15
4133
CSV import : how not to update a record's field ?
v8 import csv
Avatar
Avatar
Avatar
5
jul. 20
7745
Import pricelist items
v8 import pricelist
Avatar
0
jul. 15
4563
What the heck does this MissingError message mean?
v8 import supplier
Avatar
Avatar
1
mar. 15
11829
ImportError: cannot import name controllers, why? Solved
v8 import models controllers
Avatar
Avatar
Avatar
2
dec. 23
45559
Community
  • Tutorials
  • Dokumentacija
  • Forum
Open Source
  • Prenesi
  • Github
  • Runbot
  • Prevodi
Services
  • Odoo.sh Hosting
  • Podpora
  • Nadgradnja
  • Custom Developments
  • Izobraževanje
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Sredstva blagovne znamke
  • Kontakt
  • Zaposlitve
  • Dogodki
  • Podcast
  • Blog
  • Stranke
  • Pravno • Zasebnost
  • Varnost
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now