Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

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
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Current Inventory Valuation - Showing Zero Inventory Value

Subscribe

Get notified when there's activity on this post

This question has been flagged
warehousesinventorylocationsvaluestockzero
4 Replies
15349 Views
Avatar
Ahmed Amer

I am trying to get a report from the system in Odoo 8 from the warehouse module > Current Inventory Valuation, I am using FIFO in the location configuration and I have configured the item to be real price not standard price or average price, but the issue is the item cost price is coming zero after making any transaction on the item and in the current inventory valuation it give me zero inventory value. So how to solve this issue?

0
Avatar
Discard
Avatar
Caffe Parigi Istvan Kurtosi
Best Answer

Hin I think you need to check these:

- the realtime costing changes in case the ptoduct is sold (the batch exactly). So it could be 0 if the cost at PO was 0, than it was in a SO later.

- Value after PO colud be 0, if pricelist setting is incorrect

- Inventory valuation uses the cost price of the product, so it could become 0 for the reasons above.

- Do you really need realtime vs. average costing? I think realtime is good where inventory changes are not frequent, and PO prices change significantly.

Check these, as some ideas.

2
Avatar
Discard
Avatar
Mubaris ct
Best Answer

Hai, 

I also had the same issue . it might be because purchase might not be created .thank you. please note i am a beginner so my knowledge is limited.

0
Avatar
Discard
Avatar
Ahmed Amer
Author Best Answer

I already did that to be real time instead of periodical, but still the same 

0
Avatar
Discard
Zbik

You test full product life cycle, from purchase to sale with stock qty = 0 at start. Also check the values on the quants list - menu Warehouse/Quants.

Ahmed Amer
Author

At the first I have make inventory adjustment with the quantities I have, and then I have created some purchase orders, delivery orders and so on. But it showing that the inventory value for that item is zero. I have checked the item configuration, I have set the inventory valuation for the item to be real time and also the costing method to be real price. If I chaged the costing method to be average price, or standard price, the inventory value will come but it will not be FIFO. it will take the cost price as a fixed price. but If I changed it again to be real price it will come zero in the inventory valuation.

Avatar
Zbik
Best Answer

You should probably switch field "Inventory Valuation" (in product view) from "Periodical (manual)" to "Real Time (automated)".

0
Avatar
Discard
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
Stock location capacity
warehouses inventory locations
Avatar
Avatar
Avatar
2
Sep 25
3281
Urgent help on Missing on-hand quantity in Inventory of Odoo 12
warehouses inventory locations
Avatar
0
Feb 22
5570
Warehouse
warehouses view inventory locations
Avatar
Avatar
1
Mar 24
2388
Different locations in one warehouse for multiple companies
warehouses inventory locations multicompany
Avatar
Avatar
2
Mar 21
3901
Inventory Receipt receive in multiple bin/boxes at once
warehouses inventory locations bin #receipt
Avatar
Avatar
2
Aug 24
2328
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة 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