loader
  • Welcome to Odoo Professional Consulting Agency

Testing

How To Configure Landed Cost In Odoo 13 ?

How To Configure Landed Cost In Odoo 13 ?

Integrate Landed Costs In Odoo 13


Landed Cost means, It is the total price of the product when it has arrived at buyers. This cost includes Transportation Fee, Handling Fees and Duty etc. These prices are added and divided by the products to get the actual selling price of the product. 


Traditional way of landed cost calculation is the sum of all expenses divided with equal amounts into the products so calculation of landed cost varies according to the company and its products. 


This blog is related to how to configure Integrate Landed Costs In odoo 13.Please check the procedure and their description along with their respective screen-shots.

First make sure that you have installed the Purchase, Inventory and Accounting applications in your database.

Odoo Purchase, Inventory and Accounting

Now Go to Inventory →  Configuration →  Settings,

Under Valuation section make the checkbox true of Landed Costs.

Landed Cost In Odoo 13
Landed Cost In Odoo 13

Now Go to Inventory →  Configuration →  Product Categories,

Go inside the All Product Category record. 

Landed Cost In Odoo 13
Landed Cost In Odoo 13
Here make sure that under the Inventory Valuation section, Costing Method selected to Average Cost (AVCO) and Inventory Valuation to Automated ; if it is selected Manual our landed costs won’t get calculated.

Inventory Valuation Odoo 13
Inventory Valuation Odoo 13
Now Go to Master Data →  Products

Product Configuration In Odoo
Click on Create Button
Product Configuration In Odoo

Here I have created a product named Show Case Table, Now add the following information under the General Information section.


  • Product Type - Storable Product  

  • Product Category - All

  • Internal Reference - SCT_004 [ In order to identify product easily we add inter reference ]

  • Sales Price $ 250


Click on Update Cost button set cost price as $ 350 and click on Apply button and click on Save Button.

Create Product In Odoo 13
Create Product In Odoo 13
Create Product In Odoo 13
Now Again click on Create button
Create Product In Odoo 13

Add a product name as Transport, now add the following information under General Information section.


  • Product Type - Service 

  • Product Category - All

  • Internal Reference - TRNS_001


Under the Purchase Section set the checkbox as true of Is a Landed Cost and click on the Save button.

Create Product In Odoo 13
Create Product In Odoo 13
Now create a Request For Quotation
RFQ In Odoo 13
Here I have selected Azure Interior as a vendor ,and our product we have recently created a Showcase Table with 4 quantity and unit price of $ 350, now click on the Save button and then click Confirm Order.
Request For Quotation In Odoo
Request For Quotation In Odoo

Now click on the Receive Products button, Here our Inventory Transfer record sequence is WH/IN/0018, click on the Validate Button and hit Apply. 

Request For Quotation In Odoo
Request For Quotation In Odoo
Request For Quotation In Odoo

Now Go To Inventory →  Reporting →  Click on Inventory Valuation.

Inventory Valuation In Odoo

Here you can see our Showcase Product valuation.

Inventory Valuation In Odoo

In our Purchase Quotation click on the Create Bill button,

Here add a line of Transport with its Price,

Here you can see Landed Costs checkbox is true, then click on Save and Post the record. 

Inventory Valuation In Odoo

In our Purchase Quotation click on the Create Bill button,

Here add a line of Transport with its Price,

Here you can see Landed Costs checkbox is true, then click on Save and Post the record. 

Request For Quotation In Odoo
Request For Quotation In Odoo
Request For Quotation In Odoo

Now Click on the Create Landed Costs button,

Here Edit the record and add our Transfer,Which was WH/IN/00018, also you can split your method with differently but here I have selected Equal, Now click on the Save and Validate this record.

Landed Cost In Odoo 13
Landed Cost In Odoo 13
Landed Cost In Odoo 13
Landed Cost In Odoo 13

Under Valuation Adjustments Section you can see all details cost line, Product, Quantity, Original value, New value and additional landed cost and you can also its valuation by clicking on the Valuation smart button.

Landed Cost In Odoo 13
Landed Cost In Odoo 13
Stock Valuation Odoo 13

Now Go to Inventory →  Reporting →  Click on Inventory Valuation
 

Here you can see both values of Product and our Landed Cost details.

Inventory Valuation In Odoo 13
Inventory Valuation In Odoo 13
Odoo Service Provider Company
There are no comments for now.