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
    • Artificial Intelligence
    • 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
    • Property 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
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

AVCO Vendor Return Creates Inventory Valuation Difference – Correct Accounting Treatment?

Subscribe

Get notified when there's activity on this post

This question has been flagged
accounting
1 Reply
539 Views
Avatar
Ahmed Hamada

Hello Odoo Community,

I am facing an issue related to Inventory Valuation using Average Cost (AVCO).

Scenario:

  1. I had existing stock of Product A.

  2. I purchased 1 unit at a cost of 1,700.

  3. After the purchase, the product average cost became 1,665 per unit.

  4. Later, I returned the purchased unit to the vendor using the standard Return flow.

After the return, the Inventory Valuation Report shows a difference of 35, indicating that the Inventory Account should increase by 35.

Questions:

  1. What is the correct accounting treatment for this difference?

  2. Is this behavior expected in Odoo when using Average Cost?

  3. What is the recommended business process to handle such valuation differences without using Serial Number Valuation?

  4. If I generate a journal entry based on the Inventory Valuation Report adjustment, what should be the corresponding debit and credit accounts?

  5. How do companies typically handle these AVCO return differences in production environments?

Additional Information:

  • Costing Method: Average Cost (AVCO)

  • Automated Inventory Valuation

  • No Serial/Lot Cost Tracking

  • Vendor Return performed through standard Odoo return process

Any guidance or best practices would be appreciated.

Thank you.

0
Avatar
Discard
Avatar
Zehntech Technologies Inc.
Best Answer

Hello Ahmed,

Yes, this behavior can be expected when using Average Cost (AVCO) with Automated Inventory Valuation.

Under AVCO, Odoo values inventory based on the moving average cost of all available stock rather than tracking the exact cost of individual units. As a result, when a vendor return is processed, the valuation reversal may not exactly match the original purchase value, which can create a small valuation difference such as the 35 you are seeing.

From an accounting perspective, companies typically review these differences and post them to an appropriate inventory adjustment, price difference, or cost variance account based on their accounting policy.

The exact debit/credit treatment depends on your chart of accounts and local accounting requirements, but the behavior itself is generally normal in AVCO environments where specific cost tracking (Serial/Lot valuation) is not used.

For production environments, it is common to periodically reconcile inventory valuation differences and define clear variance accounts for such adjustments.

Hope this works for you! If you need any help implementing this or want a more optimized approach, feel free to reach out for further discussion.

Regards,

Zehntech Technologies Inc.

santosh.sekwadia@zehntech.com

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
in odoo 19 the amount does not appear distributed Profits/Losses  after closing the balance
accounting
Avatar
Avatar
2
Jun 26
1821
Receipt
accounting
Avatar
Avatar
Avatar
2
Jun 26
1481
New date format odoo 19 Solved
accounting
Avatar
Avatar
Avatar
Avatar
Avatar
4
Jun 26
5298
Customer Statements Solved
accounting
Avatar
Avatar
Avatar
Avatar
Avatar
5
May 26
7082
What accounting software are small businesses using besides Odoo?
accounting
Avatar
0
May 26
4
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 Svenska ภาษาไทย 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