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 can I assign Landed Costs to my cost price?

Subscribe

Get notified when there's activity on this post

This question has been flagged
stockv8landedcosts
5 Replies
33248 Views
Avatar
Els Van Vossel (evv)

I have invoices for transport and insurance costs related to my incoming shipments. How can I attribute such landed costs to the pickings concerned? 

3
Avatar
Discard
Avatar
Els Van Vossel (evv)
Author Best Answer

To be able to attribute Landed Costs in Odoo, some options need to be set.

From the Settings > Configuration > Warehouse, in the Accounting options, make sure to tick the options Generate accounting entries per stock movement and Calculate landed costs on products.

From the Settings > Configuration > Purchases, tick the option Use 'Real price' or 'Average' costing methods.

Start by creating specific products to indicate your various Landed Costs, such as freight, insurance and customs duties. You can add these products either from Warehouse > Products > Products or from the Warehouse > Configuration > Landed Cost Type menu (limited view). Make sure to tick the option Can constitute a landed cost for the product. Select the default split method used to attribute the landed costs.

For the products you buy (other than services), apply costing method Real Price on the Product Variant, because landed costs can only be applied to this costing method. The actual cost price is stored per quant.

Make sure to also set the Inventory Valuation (Accounting tab of the Product Variant) to Real Time (automated). Enter your Stock Input, Stock Output and Stock Valuation accounts in the product's Product Category to allow automatic stock entries to be posted.

  • If you have entered Stock Input and Stock Output ascounts for the product category, but you want to have different accounts for this product only, you can use the Accounting tab of the Product Variant and add a different Stock Input or Stock Output account.

On receipt of your invoices, encode your landed cost invoices as normal purchase (supplier) invoices (or add them to existing draft invoices).

To be able to attribute these landed costs to one or more pickings, you can enter the landed costs from the menu Warehouse > Landed Costs > Landed Costs.

In Landed Costs, click the Create button and select the picking(s) to which you want to attribute landed costs. Select the account journal in which to post the landed costs. 

  • Stock journal: we recommend you to create a specific journal for landed costs, e.g. from the stock journal type, so it will be easy to keep track of postings. If you want the generated landed cost entries to be posted automatically, tick the Autopost Created Moves option in the Journal definition screen. If you do not tick this option, a draft entry will be created which you can validate afterwards.

When you select a picking, the product lines with the correct settings (real price costing and real-time inventory valuation), will be added automatically to the Valuation Adjustments block. In the Cost Lines block, select the Landed Costs products that apply to these pickings. The default Split Method for the cost will be proposed, but as for any other default value in Odoo, you can change it.

Click the Compute button to see how the landed costs will be split accross the picking lines. Click Validate to confirm the landed costs attribution.

 

The landed cost will be deducted from the cost account linked to the landed costs product (this is the expense account defined in the product category) and transferred to the stock valuation account.

The Quant will now be updated to the correct inventory value (inclusive of the landed costs).

Reporting

To get an overview of the attributed landed costs, go to the menu Accounting > Reporting > Journals and select Journals. Select the Landed Costs journal and the periods for which you want to print the landed costs overview.

Another option is to go to the menu Accounting > Journal Entries and select Journal Items. Select the journal for your landed costs and the period.

12
Avatar
Discard
Emipro Technologies Pvt. Ltd.

@Els - When I am trying to validate the landed cost it is not posting the journal entries. When I traced the code, it tries to find the 'move id' under valuation adjustment lines, but unable to find the move id under it and therefore is not able to generate the accounting entries. Can you help me out for this?

Els Van Vossel (evv)
Author

Have you set the corresponding stock accounts for the product category concerned? Stock Input, Stock Output and Stock Valuation?

Emipro Technologies Pvt. Ltd.

@Els - Thank you for the reply. Yes I did set the stock input , output and valuation accounts. I have installed "stock_landed_costs". I traced the "def button_validate" method under stock_landed_costs.py, which calls "_create_account_move" method from it where it just creates the new account.move, but no code for setting that new move id under valuation adjustment lines. Am I going wrong?

Derek Anderson

When I follow these instructions, I get a page that looks like your image above, including the Valuation Adjustment entries, except when I try to validate, it says "You cannot validate a landed cost which has no valid valuation lines." What could make my lines invalid?

Avatar
Edwin Adkins
Best Answer

The total cost of a product once it has been delivered to the buyer is referred to as the "landed cost." This includes the fee for transportation, the duty, and any other applicable handling fees. The final price of the item is calculated by adding all of these prices together and then dividing the total by one. The landed cost is traditionally calculated by adding up all of the expenses and then allocating those costs proportionately across all of the products. The manner in which landed cost is computed will differ from business to business and product to product, among other factors, among other things.

Additionally, you may refer to this blog.

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

Landed cost is the total price of a product once it has arrived at buyers’ hand. This includes the transportation fee, duty, handling fees, etc. These prices are added and divided to get the actual selling price of the product. The traditional way of calculating landed cost is adding up all the expense and divide them equally into the products. The way of calculating landed cost will vary according to the company and products which they are handling, etc.

You can also refer this blog: Landed Cost in Odoo

0
Avatar
Discard
Avatar
Jean Marc Le Goff
Best Answer

hello,


we have made a french documentation :

https://www.auneor-conseil.fr//blog/tutoriels-et-documentation-1/post/couts-logistiques-17#

0
Avatar
Discard
Avatar
Juan Cuevas
Best Answer

Hi @Els, what is the reason for this statement: "For the products you buy (other than services), apply costing method Real Price on the Product Variant, because landed costs can only be applied to this costing method".

In our company, we use the Average costing method. Is it a limitation of Odoo, or does it have any reasonable explanation for working only with Real Price?.

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
How can I define replenishment stratygy in odoo?
stock v8
Avatar
Avatar
Avatar
2
Nov 21
7059
Supplier stock not shown in stock value report v8
stock v8
Avatar
1
Mar 15
5278
stock_move where did type go? [v8]
stock v8 stock.move
Avatar
0
Jan 16
3976
How to get starting inventory of product between two dates? Solved
stock v8 inventory
Avatar
Avatar
1
Mar 15
4773
How can I see for one of my products where the stock is located? Solved
stock v8 product
Avatar
1
Mar 15
7855
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