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

FIFO: wrong value on partial receipt

Subscribe

Get notified when there's activity on this post

This question has been flagged
fifoinventoryPurchase
3 Replies
3133 Views
Avatar
Gabriel P Hauser

Given topic: 

1 Purch. Order contains a defined item, qty = 3, each 10 EUR in price = 30 EUR total amount. 

You receipt 1 item, value equals 10 EUR - that is correct. 

Now, the purch. invoice comes and confirms this price. Everything is ok so far in an all perfect world. 


Let's assume that the second delivery also contains 1 item. You'll receipt that and Odoo assumes 20 EUR in stock value. Until now everything is also correct. 

Unfortunately, your supplier needs to higher the price and sends an invoice for the second item which differs to 20 EUR due to higher prices in raw materials. Not uncommon in volatile markets. 

At that moment, when you register the second invoice, Odoo must adjust the previous receipt to 20 EUR, so that the total stock value is 30 EUR as this is what you've paid and also what has been posted to the general ledger. 

Am I missing any recurring, automated correction report/tool or is this a serious mistake in inventory value calculation? 

0
Avatar
Discard
Avatar
Wim Audenaert
Best Answer

Changing the PO manually is not the right solution here. There are more issues related to it.

You receive in inventory at a price, and you get afterwards the bill at another price. The value of inventory must be changed, but there should also be a correction journal entry to get the right values in accounting.

I made a quick fix for it with python code on account_move (to change the value in stock_valuation_layer) and on stock_valuation_layer (to make the correction journal entry), but this is not enough. There are more problems with it when you return the 2nd receipt when the first is still in inventory.

I made a ticket at Odoo for it.

0
Avatar
Discard
Avatar
Gabriel P Hauser
Author Best Answer

I can't adapt the PO! I don't have the information, yet. This comes when the supplier sends the invoice. 

Rather then doing it manually I'd expect the system to correct it afterwards automatically at the moment when the purchase invoice arrives. The problem in the current behavior is that the inventory value doesn't equals the P&L postings. Easy to check that for an auditor and that is sth you don't want to happen in your company, right? 

0
Avatar
Discard
Avatar
Mindaugas
Best Answer

not perfect world and solution some has to be done by hand :)
so you have PO 3 qty. price 10eur.

when you receive 1 and bill, and waiting for others. you need to correct PO.

so i correct PO. one line -1 unit 10 eur(which received already). and other line 2 units, for 20eur. and when i validate receipt. validation ok. because transfer get value from PO.


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
[Odoo v11] Issue with FIFO and back orders
fifo inventory backorder
Avatar
Avatar
1
Jul 18
4196
[Odoo v11] How do I allow product cost of a product to be 0
purchase fifo inventory
Avatar
Avatar
1
Jul 18
4820
How to Reset Valuation or cut off fifo Inventory Valuation ?
fifo inventory valuation odoo11community
Avatar
Avatar
1
Sep 20
5171
How to handle inventory valuation depreciation in Odoo11 with FIFO?
fifo inventory valuation realtime
Avatar
0
Aug 20
4629
Odoo Inventory Valuation Report
inventory
Avatar
Avatar
Avatar
Avatar
3
Nov 25
7343
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