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
2.) Enable Warehouse Average Costing
Warehouse-wise average costing is enabled from user settings to activate warehouse-specific cost calculations.
3.) Assign Accounting Features to User
Accounting permissions are assigned to the responsible user to ensure full access to costing, valuation, and financial entries.
4.) Create Multiple Warehouses for Average Costing
Multiple warehouses are created to manage stock and product costs independently.
5.) Set Product Category Costing Method
The product category is configured with the Average Cost (AVCO) method and Automated Inventory Valuation.
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.
7.) Warehouse-Wise Costing Tab in Product
The product form includes a dedicated Warehouse-wise Costing tab.
8.) Purchase Product for Different Warehouses
Purchase orders are created for different warehouses with varying quantities
9.) Warehouse-Wise On-Hand Quantity and Cost
The warehouse-wise costing tab reflects updated on-hand quantities and average costs after purchases.
10.) Add Landed Cost to Purchased Product
Additional expenses such as freight or service charges are added as landed costs.
11.) Updated Cost Price After Landed Cost
After applying landed costs, the product average cost is recalculated automatically.
12.) Create Sale Order for Product
A sale order is created for the product, allowing stock to be delivered from a selected warehouse.
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.
14.) Invoice and Journal Entries for Sale Order
An invoice is generated for the sale order, and the corresponding journal entries are created automatically.
15.) Journal Entries After Product Delivery
Once delivery is completed, inventory valuation and accounting entries are updated
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.
17.) Purchase Same Product at Different Price
A new purchase order is created for the same product with a different price.
18.) Updated Cost After Incoming Shipment
After validating the incoming shipment, the warehouse-wise cost and on-hand quantity are recalculated.
19.) Inventory Valuation by Date and Warehouse
Inventory valuation can be reviewed by selecting a specific warehouse and date range.
20.) Valuation Report for Selected Warehouse
A detailed valuation report is generated for the chosen warehouse.
21.) Stock Valuation for Another Warehouse
Switching the warehouse filter allows users to compare inventory valuation across different warehouses.
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.
23.) Internal Transfer Between Warehouses
Stock is transferred from one warehouse to another while maintaining accurate cost allocation.
24.) Updated Quantity and Cost After Transfer
After the internal transfer, both warehouses reflect updated on-hand quantities and average costs.
25.) Warehouse Selection in Revaluation Wizard
The revaluation wizard allows users to select a specific warehouse for cost adjustments.
26.) Manual Inventory Valuation Adjustment
Manual valuation adjustments update the total inventory value based on business requirements.
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.
28.) Stock Adjustment in Specific Warehouse
Stock adjustments are performed for a selected warehouse to correct inventory levels.
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.
User Guide