Enable Dark Mode!
landed-cost.png
By: Sreejith

How to configure Landed cost in Odoo?

Functional Warehouse

Landed cost is the total price of a product once it has arrived at the buyers’ hands. 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 expenses 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.


 

Contents:

> Configuring the Landed Cost in ERP.

> Configure the Landed Cost Type.

> Compute Landed Cost for a warehouse transfer.


Configuring the Landed Cost in ERP:
 

Step 1: Login as admin user

Step 2: Go to Settings>>configuration>>Warehouse

Step 3: Check the field calculate landed costs on products and Make sure that the field called Generate accounting entries per stock movement is checked as in screenshot no:1


landed-cost-cybrosys

 

Step 4: Go to  Settings>configuration>Purchase

Make sure that the field called “Use 'Real Price' or 'Average' costing methods” is checked.

Before going to landed cost we have to set accounts, costing methods and inventory valuation.

In product master under accounting tab

Select “Real Time(automated)” as Inventory Valuation

 

In product master under Procurement tab.

Select Real Price as Costing method.

Define stock accounts for the Product category.

Go to Sales >> Configuration >> Product Categories & Attributes>>Product category.

Select 

- Stock input account

- Stock output account

- Stock valuation account

- Stock journal

- Income account

- Expense account

 

Configure the Landed Cost Type

Landed cost types are created as products. These are the expenses which are added as landed cost.

Step 1: Go to warehouse->Configuration->Landed Cost Type

Create a landed cost for transportation, make product type as service and splitting method as required.

 

Splitting Methods
Equal
- Quantity
- By current Cost Price
- By Weight
- By Volume


landed-cost-cybrosys

1.Equal:
It equally splits the expenses for the product lines
 
2.Quantity:
It computes greater expense for higher quantity Product
 
3.By current Cost Price:
It divides the expense on a cost basis. Higher expense for high-cost product
 
4.By weight and Volume:
It divides the expense on weight and volume of a product.
Provide the cost price for the landed cost type and the expense account needed. And then save the form.

 

Compute Landed Cost for a warehouse transfer

Step 1: Create a landed cost for the picking

Warehouse -> Landed Cost -> Landed Costs


Here some fields are given. In that select the journal from the drop-down list. Then, in the  ‘pickings’ field select the picking (warehouse transfer eg: Chic/IN/00002). In ‘cost lines’ select the landed cost type and then click on compute. Once you click on the compute button you will get the landed cost computed for each line.


landed-cost-cybrosys

Now click on validate and the accounting entries will be generated for the same.

This blog is created with reference to odoo v8.


If you need any assistance in odoo, we are online, please chat with us.



1
Comments

Tariq

For our sales we add landed cost in product but when we file our income tax return, all cost should be considered as expense whether zero product was sold from that stocks. How to do that?

13/05/2022

-

12:32AM



Leave a comment

 


whatsapp
location

Calicut

Cybrosys Technologies Pvt. Ltd.
Neospace, Kinfra Techno Park
Kakkancherry, Calicut
Kerala, India - 673635

location

Kochi

Cybrosys Technologies Pvt. Ltd.
1st Floor, Thapasya Building,
Infopark, Kakkanad,
Kochi, India - 682030.

location

Bangalore

Cybrosys Techno Solutions
The Estate, 8th Floor,
Dickenson Road,
Bangalore, India - 560042

Send Us A Message