Nowadays in this fast forwarding world most of businesses who have storable products, they have multiple warehouses at different place. So the problem is one product have different landed cost and some service cost and company need to maintain demand of products at multi warehouses. At the end company are get different cost price of that products in each warehouses, and that things you can not manage in odoo. But Don't worry here we have solution for that. Our this app will help to manage your average costing warehouse wise.
First thing first, enable multi warehouse and locations.
Enable Warehouse Average Costing to display warehouse wise costing in product form.
Assign Full Acounting Features to responsible users.
Create Multi Warehouses.
In Product Category, Costing Method : Average and Inventory Valuation : Automated.
Create a product, make sure that is storable.
Warehouse wise costing tab inside the product. Here you find the warehouse wise cost of related products.
Purchase product at 10/units.
Make sure warehouse selection is correct in purchase order.
Receipt order Done.
As you can see the costing price added in warehouse wise cost tab in that product.
Now add some landed cost in purchased product.
As you can see the cost price are updated.
Now purchase same product with different price and different warehouse.
Different warehosue selection in purchase order.
Receipt order done
As you can see the another cost are added in costing table.
Now added another landed cost for last purchased product
As you can see the cost price is updated after adding landed cost.
Now make sale order for that product.
Warehouse selection in sale order.
Make invoice for that sale order and check the journal entries.
Journal entries after make delivery done.
Create another purchase order for same product but different price.
Warehouse selection in purchase order.
Incoming order successfuly done.
As you can see the cost price is update in products costing tab.
Check inventory valuation. Just select date and warehouse.
Valuation report for selected warehouse
Valuation report for another warehouse
Warehouse Field Added In RFQ Form
Form view of the RFQ, you can select the warehouse in order lines.
On Hand QTY Added In Warehouse Wise Cost Tab
Warehouse-wise on-hand quantity and cost in the warehouse-wise cost tab.
Added Landed Cost in Internal Transfer
In the landed cost form view, you can view the transfer order number and product cost.
The source and destination warehouse locations are visible in the internal transfer order. Click on the selected product.
Product form view with warehouse, on-hand qty and cost.
Warehouse Selection In Revaluation
Tree view of the stock valuation, where warehouse2 is showcased.
Warhouse name is visible in the product revaluation wizard.
After making a manual valuation adjustment, the total value will changed.
Product Cost Take From Warehouse Cost Tab While Adjustment
Product form view with on-hand qty and cost.
Do the adjustment in warehouse1.
Now, you can see the warehouse-wise on-hand quantity and cost information updated.
Version 16.0.2 | Released on : 15th June 2022
Version 16.0.1 | Released on : 19th November 2022
- Yes, this app works perfectly with Odoo Enterprise (Odoo.sh & Premise) as well as Community.
- No, this application is not compatible with odoo.com(odoo saas).
- Yes, we provide free support for 100 days.
- Yes, you will get free update for lifetime.
- No, you don't need to install addition libraries.
- Yes, You have to download module for each version (13,14,15) except in version 12 or lower.
- No, We do not provide any kind of exchange.