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

How to Treat Stock Valuation (Interim)

Subscribe

Get notified when there's activity on this post

This question has been flagged
accountinginventorylandedcostsinventoryValuationinventory valuation
1 Reply
1854 Views
Avatar
Kiko Cruz

For Odoo accountants and functional configurators out there: Need help if this is either a process issue or a configuration issue on how to balance accounts for inventory valuation where Landed Costs are concerned.

So when purchasing inventory, inventory value gets assigned to the journal account for inventory assets called "Inventory Valuation" (debit) and corresponding credit for "Stock Interim (Received)" account.

After the vendor bill for the inventory purchase is made, the "Stock Interim (Received)" is reversed/debited accordingly (balanced mainly by "Accounts Payable" double entry as expected).


The concern I have comes in when I introduce a landed cost (e.g., "Delivery Fees") in the vendor bill. Once bill is confirmed, the landed cost is entered as "Expense" (debit) in the journal entry. Okay.

To add the landed cost in the valuation, I click on the Landed Cost button and tag the WH receipt to rightfully tag the additional valuation cost on the inventory items purchased. This adds a journal entry with debit for "Inventory Valuation" (okay) and credit for "Stock Interim (Received)" (also okay).

But unlike when vendor bill is validated for payment, the increase in credit for "Stock Interim (Received)" doesn't seem to be reversed anywhere else in the process. So every time landed costs are added for inventory purchases, inventory valuation will accumulate credit value for "Stock Interim (Received)."

Am I missing a process step for inventory valuation? Nothing is mentioned in the documentation: https://www.odoo.com/documentation/saas-18.4/applications/inventory_and_mrp/inventory/product_management/inventory_valuation/landed_costs.html

0
Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

In Odoo flow,

1- Vendor Bill for Landed Cost product (service)

          - Post the bill with a special Landed Costs Clearing (balance‑sheet) account.

          - Entry:

                   *Dr Landed Costs Clearing

                  *Cr Accounts Payable

2- Landed Cost (Compute & Validate)

           - Odoo capitalizes the fee into stock value.

          - Entry:

                   *Dr Inventory Valuation

                   *Cr Landed Costs Clearing

These two moves offset in the clearing account. Your Stock Interim (Received) is not touched by the landed‑cost capitalization. Only Inventory Valuation increases.


Why you’re seeing credits in Stock Interim (Received) :-

Your landed‑cost line is likely posting to Stock Interim (Received) (or pulling stock interim from the product category) instead of a dedicated clearing (or expense) account. That makes the LC validation credit Stock Interim (Received), which won’t be auto‑reversed by any later step, hence the growing imbalance.


References:-

* https://www.cybrosys.com/blog/how-to-manage-product-pricing-with-landed-costs-in-odoo-18

* https://www.cybrosys.com/blog/an-overview-of-inventory-valuation-in-odoo-18


Hope it helps

1
Avatar
Discard
Kiko Cruz
Author

Hi Cybrosys - Thanks for responding. I'm getting what you're saying (I think) especially for #1. The debit for the Landed Cost should have been the Landed Costs Clearing (my "Stock Interim (Received)"). On looking at Odoo's reference as well, I saw that it's also what the screenshot showed (but not explained in the text that the Product item used as Landed Cost should use the "Stock Interim (Received)" account. I'm referencing the Odoo documentation here ("Create Vendor Bill" section) that aligns with your point #1 (but correct me if I'm wrong): https://www.odoo.com/documentation/saas-18.4/applications/inventory_and_mrp/inventory/product_management/inventory_valuation/landed_costs.html

The references to your blog posts are great by the way, but I hope you can have some updated one where Landed Cost is applied with automatic valuation in place as well.

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
How does the Landed Cost feature work if I receive Vendor Bills prior to receiving the Product?
accounting inventory landedcosts Odoo 18
Avatar
Avatar
1
May 25
1347
Landed Cost - value only being added for the first item
accounting inventory landed_cost landedcosts
Avatar
Avatar
1
Jan 25
1854
I need your opinions, I have new partner Solved
accounting inventory transfer inventoryValuation
Avatar
Avatar
1
Jun 24
2125
Landed costs without automated inventory valuation (and accounting app) V14 V15
accounting inventory landed_cost landedcosts inventario
Avatar
Avatar
2
Oct 22
3245
Inventory Valuation - moving from Manual (periodic) to Automated (real time) on Odoo 16
accounting inventory
Avatar
Avatar
Avatar
Avatar
Avatar
4
Sep 25
3034
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