Skip to Content
Average Costing Warehouse
€ 99.00 € 99.00

Technical Name : eg_warehouse_average_costing
Odoo Apps Dependencies :
Community Apps Dependencies :
  • Version

Our Most Suggested Products

Warehouse Costing Management

Warehouse Costing Management is an advanced Odoo module designed to simplify and optimize product cost tracking across multiple warehouses. Managing different landed costs, service charges, and inventory valuations per location can be complex, especially for businesses operating with multiple storage points. This module introduces warehouse-wise average costing, enabling accurate cost calculation, precise inventory valuation, and better financial control



Features

Warehouse Wise Average Costing

The module automatically calculates and maintains the average cost of products separately for each warehouse. Every stock movement, receipt, or adjustment updates the warehouse-specific cost instead of relying on a global product cost

Warehouse Wise Inventory Valuation

Warehouse Wise Inventory Valuation Inventory valuation is calculated independently for each warehouse, providing precise stock value based on the actual cost incurred at that location.

Warehouse Wise Costing Table in Products

A dedicated costing table is available within the product form, displaying detailed cost information for each warehouse.

Landed Cost in Internal Transfers

The module supports landed cost allocation during internal warehouse transfers. Additional costs such as transportation, handling, or service charges are accurately distributed to the destination warehouse.

Warehouse Selection in Revaluation

Users can select specific warehouses while performing product revaluation, offering greater control over cost corrections.

Warehouse Wise Purchase Costing

Purchase costs are tracked and managed at the warehouse level, ensuring that each location maintains its own accurate cost structure.

Screenshot

1.) Enable Multiple Stock Locations and Warehouses

Activating this option allows users to manage multiple warehouses and stock locations within the same database.


Navigation : Settings → Users & companies → User


Odoo Studio

2.) Enable Warehouse Average Costing

Warehouse-wise average costing is enabled from user settings to activate warehouse-specific cost calculations.



Odoo Studio

3.) Assign Accounting Features to User

Accounting permissions are assigned to the responsible user to ensure full access to costing, valuation, and financial entries.



Odoo Studio

4.) Create Multiple Warehouses for Average Costing

Multiple warehouses are created to manage stock and product costs independently.



Odoo Studio

5.) Set Product Category Costing Method

The product category is configured with the Average Cost (AVCO) method and Automated Inventory Valuation.



Odoo Studio

6.) Create a Storable Product

A storable product is created to enable inventory tracking and costing features. Only storable products support warehouse-wise cost calculations and inventory valuation.



Odoo Studio

7.) Warehouse-Wise Costing Tab in Product

The product form includes a dedicated Warehouse-wise Costing tab.



Odoo Studio

8.) Purchase Product for Different Warehouses

Purchase orders are created for different warehouses with varying quantities



Odoo Studio

9.) Warehouse-Wise On-Hand Quantity and Cost

The warehouse-wise costing tab reflects updated on-hand quantities and average costs after purchases.



Odoo Studio

10.) Add Landed Cost to Purchased Product

Additional expenses such as freight or service charges are added as landed costs.



Odoo Studio

11.) Updated Cost Price After Landed Cost

After applying landed costs, the product average cost is recalculated automatically.



Odoo Studio

12.) Create Sale Order for Product

A sale order is created for the product, allowing stock to be delivered from a selected warehouse.



Odoo Studio

13.) Select Warehouse in Sale Order

The warehouse selection in the sale order ensures that stock, cost, and valuation are deducted from the correct location.



Odoo Studio

14.) Invoice and Journal Entries for Sale Order

An invoice is generated for the sale order, and the corresponding journal entries are created automatically.



Odoo Studio

15.) Journal Entries After Product Delivery

Once delivery is completed, inventory valuation and accounting entries are updated



Odoo Studio

16.) Product Costing Table Before and After Sales

The product costing table provides a clear comparison of costs and quantities before and after the sales order.



Odoo Studio

17.) Purchase Same Product at Different Price

A new purchase order is created for the same product with a different price.



Odoo Studio

18.) Updated Cost After Incoming Shipment

After validating the incoming shipment, the warehouse-wise cost and on-hand quantity are recalculated.



Odoo Studio

19.) Inventory Valuation by Date and Warehouse

Inventory valuation can be reviewed by selecting a specific warehouse and date range.



Odoo Studio

20.) Valuation Report for Selected Warehouse

A detailed valuation report is generated for the chosen warehouse.



Odoo Studio

21.) Stock Valuation for Another Warehouse

Switching the warehouse filter allows users to compare inventory valuation across different warehouses.



Odoo Studio

22.) Warehouse Costing Table Before Internal Transfer

Before performing an internal transfer, the warehouse-wise costing table shows the current quantity and average cost for each warehouse.



Odoo Studio

23.) Internal Transfer Between Warehouses

Stock is transferred from one warehouse to another while maintaining accurate cost allocation.



Odoo Studio

24.) Updated Quantity and Cost After Transfer

After the internal transfer, both warehouses reflect updated on-hand quantities and average costs.



Odoo Studio

25.) Warehouse Selection in Revaluation Wizard

The revaluation wizard allows users to select a specific warehouse for cost adjustments.



Odoo Studio

26.) Manual Inventory Valuation Adjustment

Manual valuation adjustments update the total inventory value based on business requirements.



Odoo Studio

27.) Product Cost Update During Adjustment

During stock or valuation adjustments, the product form updates the on-hand quantity and average cost in real time.



Odoo Studio

28.) Stock Adjustment in Specific Warehouse

Stock adjustments are performed for a selected warehouse to correct inventory levels.



Odoo Studio

29.) Updated Quantity and Cost After Stock Adjustment

After completing the stock adjustment, the warehouse-wise costing tab reflects the corrected on-hand quantity and updated average cost, keeping inventory and accounting data aligned.



Odoo Studio

User Guide

Email

Watch Video Tutorial

Teams

Suggested Products