Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) • Invoicing (account) • Purchase (purchase) • Sales (sale_management) |
Lines of code | 467 |
Technical Name |
eg_warehouse_average_costing |
License | OPL-1 |
Website | https://www.inkerp.com |
Versions | 16.0 17.0 18.0 |
Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) • Invoicing (account) • Purchase (purchase) • Sales (sale_management) |
Lines of code | 467 |
Technical Name |
eg_warehouse_average_costing |
License | OPL-1 |
Website | https://www.inkerp.com |
Versions | 16.0 17.0 18.0 |



Warehouse Costing Management
Managing different warehouse costs and product pricing across multiple locations can be challenging, especially when products have varying landed and service costs. This app solves the problem by enabling warehouse-wise average costing, allowing businesses to easily track and manage costs for products across different warehouses in Odoo.
Highlight Warehouse Costing Management
Warehouse-wise average costing for products
Accurate warehouse-wise inventory valuation
Warehouse-wise costing table displayed in product form
Support for landed cost in internal transfers
Warehouse selection for revaluation and purchases

Features
Warehouse Wise Average Costing:
Automatically calculate and track the average cost of products across different warehouses.
Warehouse Wise Inventory Valuation:
View inventory valuation for each warehouse separately.
Warehouse Wise Costing Table in Products:
Access a detailed costing table for products based on the warehouse.
Landed Cost In Internal Transfer:
Account for landed costs when transferring stock between warehouses.
Warehouse Selection in Revaluation:
Select specific warehouses for product revaluation.
Warehouse Wise Purchase:
Track and manage purchase costs by warehouse.
Screenshot

1) Enable Multiple Stock Locations and Warehouses:
Activate the option to manage multiple stock locations and warehouses.
Navigation : Settings → Users & companies → User

2) Enable Warehouse Average Costing:
Enable the warehouse-wise average costing feature to display warehouse-specific costing in the product form.
Navigation : Settings → Users & companies → User

3) Assign Accounting Features to User:
Assign full accounting features to the responsible user for managing warehouse-wise costing and inventory.

4) Create Multi Warehouse for Average Cost:
Create multiple warehouses to manage average costs for products effectively.

5) Set Product Category for Costing Method:
Set the costing method to "Average Cost (AVCO)" and inventory valuation to "Automated" in the product category.

6) Create a Storable Product:
Create a product and ensure it is marked as storable to enable warehouse-wise costing management.

7) Warehouse-wise Costing Tab in Product:
Within the product form, find the "Warehouse-wise Costing" tab, showing the cost for each warehouse.

8) Purchase Product for Different Warehouses:
Purchase products for different warehouses (e.g., 20 units for My Company warehouse and 10 units for Your Company warehouse). Warehouse can be selected in the RFQ order lines.

9) Warehouse-wise On-Hand Quantity and Cost:
View the on-hand quantity and cost for each warehouse in the warehouse-wise costing tab.

10) Add Landed Cost to Purchased Product:
Add a landed cost for the last purchased product.

11) Cost Price Update After Landed Cost:
See the updated cost price after adding the landed cost to the product.

12) Create Sale Order for Product:
Create a sale order for the product and select the warehouse in the sale order.

13) Select Warehouse in Sale Order:
Select the warehouse in the sale order form.

14) Create Invoice for Sale Order and Check Journal Entries:
Generate an invoice for the sale order and review the associated journal entries.

15) Journal Entries After Delivery:
Check the journal entries after the product delivery is completed.

16) Product Costing Table Before and After Sales Order:
View the product costing table before the new purchase order and after the sales order picking is done.

17) Create Purchase Order for Same Product with Different Price:
Create a new purchase order for the same product but at a different price, and select the warehouse in the PO line.

18) Update Cost Price After Incoming Order:
After the incoming order is completed, the cost price and on-hand quantity are updated in the productâs costing tab.

19) Check Inventory Valuation:
Select the date and warehouse to check the inventory valuation for a specific period.

20) Valuation Report for Selected Warehouse:
Generate a detailed valuation report for the selected warehouse.

21) Check Stock Valuation for Another Warehouse:
Check the stock valuation for a different warehouse.

22) Warehouse Average Costing Table Before Internal Transfer:
View the warehouse-wise average costing table before performing an internal transfer.

23) Perform Internal Transfers:
Transfer stock from one warehouse to another and track costs.

24) On-Hand Quantity and Cost After Warehouse Transfer:
See the updated on-hand quantity and cost after performing the warehouse transfer.

25) Warehouse Selection in Revaluation:
Select the warehouse in the product revaluation wizard for accurate adjustments.

26) Manual Valuation Adjustment:
After making a manual valuation adjustment, the total value of the inventory will change accordingly.

27) Product Cost From Warehouse Cost Tab During Adjustment:
In the product form view, the on-hand quantity and average cost are updated during stock adjustments.

28) Stock Adjustment in Your Company Warehouse:
Perform stock adjustments in your companyâs warehouse and adjust inventory values accordingly.

29) Update On-Hand Quantity and Cost After Stock Adjustment:
View the updated on-hand quantity and cost after performing a stock adjustment.

User Guide
Suggested Products
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module