Skip to Content
Odoo Menú
  • Registra entrada
  • Prova-ho gratis
  • Aplicacions
    Finances
    • Comptabilitat
    • Facturació
    • Despeses
    • Full de càlcul (IA)
    • Documents
    • Signatura
    Vendes
    • CRM
    • Vendes
    • Punt de venda per a botigues
    • Punt de venda per a restaurants
    • Subscripcions
    • Lloguer
    Imatges de llocs web
    • Creació de llocs web
    • Comerç electrònic
    • Blog
    • Fòrum
    • Xat en directe
    • Aprenentatge en línia
    Cadena de subministrament
    • Inventari
    • Fabricació
    • PLM
    • Compres
    • Manteniment
    • Qualitat
    Recursos humans
    • Empleats
    • Reclutament
    • Absències
    • Avaluacions
    • Recomanacions
    • Flota
    Màrqueting
    • Màrqueting Social
    • Màrqueting per correu electrònic
    • Màrqueting per SMS
    • Esdeveniments
    • Automatització del màrqueting
    • Enquestes
    Serveis
    • Projectes
    • Fulls d'hores
    • Servei de camp
    • Suport
    • Planificació
    • Cites
    Productivitat
    • Converses
    • Validacions
    • IoT
    • VoIP
    • Coneixements
    • WhatsApp
    Aplicacions de tercers Odoo Studio Plataforma d'Odoo al núvol
  • Sectors
    Comerç al detall
    • Llibreria
    • Botiga de roba
    • Botiga de mobles
    • Botiga d'ultramarins
    • Ferreteria
    • Botiga de joguines
    Food & Hospitality
    • Bar i pub
    • Restaurant
    • Menjar ràpid
    • Guest House
    • Distribuïdor de begudes
    • Hotel
    Immobiliari
    • Agència immobiliària
    • Estudi d'arquitectura
    • Construcció
    • Gestió immobiliària
    • Jardineria
    • Associació de propietaris de béns immobles
    Consultoria
    • Empresa comptable
    • Partner d'Odoo
    • Agència de màrqueting
    • Bufet d'advocats
    • Captació de talent
    • Auditoria i certificació
    Fabricació
    • Textile
    • Metal
    • Mobles
    • Menjar
    • Brewery
    • Regals corporatius
    Salut i fitness
    • Club d'esport
    • Òptica
    • Centre de fitness
    • Especialistes en benestar
    • Farmàcia
    • Perruqueria
    Trades
    • Servei de manteniment
    • Hardware i suport informàtic
    • Sistemes d'energia solar
    • Shoe Maker
    • Serveis de neteja
    • Instal·lacions HVAC
    Altres
    • Nonprofit Organization
    • Agència del medi ambient
    • Lloguer de panells publicitaris
    • Fotografia
    • Lloguer de bicicletes
    • Distribuïdors de programari
    Browse all Industries
  • Comunitat
    Aprèn
    • Tutorials
    • Documentació
    • Certificacions
    • Formació
    • Blog
    • Pòdcast
    Potenciar l'educació
    • Programa educatiu
    • Scale-Up! El joc empresarial
    • Visita Odoo
    Obtindre el programari
    • Descarregar
    • Comparar edicions
    • Novetats de les versions
    Col·laborar
    • GitHub
    • Fòrum
    • Esdeveniments
    • Traduccions
    • Converteix-te en partner
    • Services for Partners
    • Registra la teva empresa comptable
    Obtindre els serveis
    • Troba un partner
    • Troba un comptable
    • Contacta amb un expert
    • Serveis d'implementació
    • Referències del client
    • Suport
    • Actualitzacions
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Programar una demo
  • Preus
  • Ajuda

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

  • CRM
  • e-Commerce
  • Comptabilitat
  • Inventari
  • PoS
  • Projectes
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Etiquetes (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Etiquetes (View all)
odoo accounting v14 pos v15
About this forum
Ajuda

What's the difference between inventory on hand and future inventory?

Subscriure's

Get notified when there's activity on this post

This question has been flagged
stockinventoryvaluation
1 Respondre
24030 Vistes
Avatar
Els Van Vossel (evv)

I want to know my current stock and the sales want to know what they can sell. Are these concepts available in Odoo? 

0
Avatar
Descartar
Avatar
Els Van Vossel (evv)
Autor Best Answer

The On Hand Inventory (or quantity on hand) is the quantity physically present in your warehouse.

The Forecasted Inventory (or future or virtual stock) is the actual quantity available, which is calculated according to the following formula: on hand inventory - outgoing + incoming. Virtual or forecasted stock is very useful because it shows what the salespeople can sell. If the forecasted stock is higher than the real stock, this means products will be coming in. If forecasted stock is smaller than on hand stock, certain products are reserved for other sales orders or work orders. 

Why these two concepts? 

It is clear that your forecasted inventory will decrease with each sale, but what about the on hand inventory?  If you have 10 products in your stock location and you sell one, your forecasted inventory will be 9, because there's one product less to sell.  However, the product is still physically present in your stock. The On Hand Inventory will remain at 10 until the product leaves your warehouse.  Depending on how many products still need to be shipped, your on hand inventory will usually be higher than your available inventory.

Of course, at some point in time on hand and forecasted quantity will synchronise when you receive and deliver all the orders that have been placed. But yet it is most likely that you want to offer more of a product then you have available, for instance in case of backorders or drop shipping, or that you might not want to sell the full quantity of a product, for instance if you want to use some of the products as samples. Whether you want to sell more than you have, or save some of what you have, these two concepts of On Hand and Forecasted Inventory can be very useful.

The Forecasted quantity is also used for Reordering Rules, meaning that such a rule takes into account the calculation of deliveries and receipts to come. To have Odoo generate stock replenishment proposals according to minimum / maximum stock for you, go to the menu Warehouse ‣ Configuration ‣ Reordering Rules (make sure Procurement is installed).

If the forecasted stock for the given location is lower than the minimum stock indicated in the rule, the system will automatically propose a procurement to increase the level of forecasted stock to the maximum level given in the rule.

In a reordering rule, when you indicate a warehouse, it suggests a stock location by default in that warehouse. You can change that default location when the scheduler completes.

Reporting

By default, in Product kanban view, the labels On hand and Forecasted show the stock figures for all stock locations where a product is stored. 

If you want to have more details about your future stock, go to the Product Variants menu and print the Stock Level Forecast, either by opening the product variant and selecting the option from the Print button, or from list view by selecting one or more product variants and selecting the option from the Print button. Odoo shows a graph of the changes in stock in the days to come, varying as a function of purchase orders, confirmed production and sales orders.

To check the value of your stock at date according to the on hand quantities, go to the menu Warehouse > Inventory Control > Current Inventory Valuation. This screen will show the current stock value for your locations, with the linked Purchase or Sales orders, if any. You can use the Group by options to change the grouping of the data. You can also display the data in Graph view.

Pie Chart grouped by Location and product

With extra info about the inventory value

2
Avatar
Descartar
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registrar-se
Related Posts Respostes Vistes Activitat
Account Stock Properties Stock Valuation
stock inventory valuation
Avatar
Avatar
Avatar
3
de gen. 18
15619
How to Allow Backdated Inventory Transactions with Real-Time Valuation?
stock manufacturing inventory valuation
Avatar
Avatar
Avatar
2
d’oct. 25
1077
Stock valuation: Average Costing uses Sales Price instead of Purchase Cost
stock inventory stockvaluation valuation
Avatar
Avatar
Avatar
2
d’oct. 25
1006
How to edit an inventory adjustment
stock inventory stockvaluation valuation
Avatar
0
de febr. 20
4241
stock valuation related query Solved
stock valuation
Avatar
Avatar
Avatar
Avatar
3
de maig 25
3785
Community
  • Tutorials
  • Documentació
  • Fòrum
Codi obert
  • Descarregar
  • GitHub
  • Runbot
  • Traduccions
Serveis
  • Allotjament a Odoo.sh
  • Suport
  • Actualització
  • Desenvolupaments personalitzats
  • Educació
  • Troba un comptable
  • Troba un partner
  • Converteix-te en partner
Sobre nosaltres
  • La nostra empresa
  • Actius de marca
  • Contacta amb nosaltres
  • Llocs de treball
  • Esdeveniments
  • Pòdcast
  • Blog
  • Clients
  • Informació legal • Privacitat
  • Seguretat
الْعَرَبيّة 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 és un conjunt d'aplicacions empresarials de codi obert que cobreix totes les necessitats de la teva empresa: CRM, comerç electrònic, comptabilitat, inventari, punt de venda, gestió de projectes, etc.

La proposta única de valor d'Odoo és ser molt fàcil d'utilitzar i estar totalment integrat, ambdues alhora.

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