average-landed-cost-odoo-12-app.png
Blogger_636881918488007730.png
By: Varsha Vivek K

Average Landed Cost - Odoo 12 App

Landed cost is the total price of a product when it arrives at the buyer’s hand and this cost includes the sum of additional charges like transportation fees, shipping charges, customs duties, handling fees and more.


Currently, in Odoo the user can’t view the average landed cost for each product. When computed the landed cost, it only shows the additional landed cost. However, Odoo will calculate the average landed cost without showing it anywhere and automatically adds them to each product cost.


In this blog, I am going through a module which implements a new feature in Odoo Inventory. The module named Average Landed Cost helps us to calculate and shows the average landed cost for each product. So we can easily calculate the product cost (i.e, Cost of product = Purchasing price of product + Average Landed Cost of product).



Landed costs can only be applied to products with a FIFO(Real Price) costing method and an automated(Real-Time) inventory valuation (which requires the accounting application to be installed).


For calculating average landed cost for each product, first you need to install Average Landed Cost module.


average-landed-cost-odoo-12-app-cybrosys


Then activate the landed costs option in Inventory -> Configuration -> Settings.


average-landed-cost-odoo-12-app-cybrosys


Then go to Inventory -> Operations -> Landed Costs and click on the “Create” button to create a new one.


average-landed-cost-odoo-12-app-cybrosys


Then you have to select the Transfers (Purchase Order) on which you want to attribute additional costs and the costs lines you want to add up.


In the cost lines, create a landed cost for Transport, make product type as service and splitting method as required.


Splitting Methods:

1. Equal - It equally splits the expenses for the product lines.

2. Quantity - It computes the greater expense for higher quantity product.

3. By Current Cost - It divides the expense on a cost basis. The higher expense for costlier product.

4. By Weight - It divides the expense on weight of a product.

5. By Volume - It divides the expense on volume of a product.


average-landed-cost-odoo-12-app-cybrosys


Once it's done, click on the Compute button to see - how the cost lines will be split across your transfers lines.


average-landed-cost-odoo-12-app-cybrosys


After that, click on the Compute Average button to see the average landed cost adding up each product.


average-landed-cost-odoo-12-app-cybrosys


To confirm landed costs attribution, click on the Validate button and now you can see the status changed to posted state.


average-landed-cost-odoo-12-app-cybrosys


When you sell a product (Selling quantity must be greater than the purchased quantity in the Transfer) the calculated average landed cost is added upon the product cost.


Example: We purchased 10 qty products named ‘Product 1’, its purchasing price(Former Cost(Per Unit)) is 100rs and its calculated average landed cost is 5.14.


After selling 11 qty of ‘Product 1’ the product cost becomes changed to 105.14rs.


average-landed-cost-odoo-12-app-cybrosys


Cybrosys has developed several modules across different industry verticals. Our Odoo Apps, ensure that you no longer feel deficient in performing a certain kind of task at your workplace. We envision in further extending the functionality of each Odoo modules accessible to the end-user.  




Comments

0


Leave a comment

 
Calicut

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

London

Cybrosys Limited
Alpha House,
100 Borough High Street, London,
SE1 1LB, United Kingdom

Kochi

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

Bangalore

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

Send Us A Message