Warehouse Wise Average Costing for Odoo | Multi Warehouse Inventory Valuation
by DevIntelle Consulting Service Pvt.Ltd https://www.devintellecs.com$ 28.84
Warehouse Average Costing
Warehouse Average Costing Odoo App gives every warehouse
its own average cost for each product, so you can see what stock
really costs you in each location instead of working from one
company-wide figure. Each product and warehouse pair gets its own
cost record you can open, filter, and group like any other list.
The cost recalculates on its own each time you validate a receipt,
using a weighted average of stock on hand and the quantity received,
with the price taken from the purchase order line. Transfers between
warehouses carry the cost across the way you choose, and every change
is logged with the figures before and after and who made it.
Buyers can preview what an order will do to a warehouse's average
before confirming, and get a warning when a price is out of line.
Quotations show cost and margin based on the shipping warehouse.
Managers can revalue one product or a whole category, and review
valuation, variance, and margin on screen. It suits distributors and
manufacturers running several warehouses who need per-location cost
visibility.
Features
Cost Per Warehouse
Each product keeps a separate average cost for every warehouse, so you can compare what the same item costs across locations.
Automatic Cost Updates
Validating a receipt recalculates that warehouse's average using a weighted average of stock on hand and the quantity received.
Purchase Cost Capture
Incoming cost is taken straight from the purchase order line and converted into your company currency when the vendor bills in another.
Transfer Cost Carry-Over
Moving goods between warehouses carries the cost across, using either the sending warehouse's average or the product's standard cost.
Full Cost Change History
Every cost change is logged with the cost and quantity before and after, the source document, the value impact, and who changed it.
Purchase Cost Impact Preview
See what a purchase order will do to the receiving warehouse's average cost, line by line, before you confirm it.
Price Variance Alerts
Purchase lines priced away from the receiving warehouse's average are flagged against a threshold you set, with a warning and a filter.
Margin On Quotations
Sales lines show cost and margin based on the shipping warehouse, with an order total and a warning when margins get thin.
Single Product Revaluation
Adjust one warehouse cost with a required reason, see the value impact before confirming, and keep the change in the history.
Bulk Revaluation
Apply a percentage or fixed adjustment across a warehouse or product category, then review and tick each product in a preview list.
Warehouse Valuation Analysis
Compare stock value at each warehouse's own average against the standard cost, with the variance in amount and percent.
Variance and Margin Analysis
Review cost changes and sales margin on screen as lists, pivots, and graphs, in detail or summarised by month.
Costing Dashboard
Pick a warehouse and see valuation, cost movement, and margin indicators, top products by value, and recent cost changes.
Warehouse Context In Inventory
Moves, transfers, and inventory valuation lines show the warehouse and its cost, and can be grouped by warehouse.
Costing Access Control
A read-only costing role and a manager role who can revalue, with records kept separate per company.
Enable Warehouse Average Costing
Navigate to Inventory > Configuration > Settings. Enable the Warehouse Average Costing setting and configure default settings like the costing decimal precision and internal transfer cost propagation method.
Product & Category Configuration
Create or select a product and assign it to a product category whose costing method is set to Average Cost (AVCO).
Purchase Flow & Average Cost Calculations
Raise purchase orders at different unit prices and validate the receipts, and each warehouse's average cost recalculates on its own, with every change written to the cost history.
Analysis Reports & Multi-Warehouse Tracking
Open Warehouse Valuation, Cost Variance and its monthly summary, and Margin Analysis and its summary as on-screen lists, pivots and graphs, then compare warehouses by raising purchase orders for different locations.
Execute Manual Cost Revaluation
Open a warehouse cost record and click Revaluate Cost to set a new cost. You see the current cost, quantity and value next to the new cost, the difference and the change percent before confirming, and you choose the accounting date, journal and accounts. The reason you enter is kept with the change in the cost history.
Bulk Cost Revaluation
Adjust several products at once. Filter by warehouse and product category, choose a percentage or fixed amount adjustment, then review the preview list showing each product's current cost, quantity, new cost and value change, and tick the ones to include.
Version 1.0 | Released on : 13th February 2024
-
Is this app compatible with Odoo Enterprise?
- Yes, our app works with Odoo Enterprise as well as Community.
-
If need of customization in this app, How can i contact
?
- Please contact us on odoo@devintellecs.com
-
Do i get free support?
- Yes, you will get free support for 90days.
-
Do i get free updates?
- Yes, you will get free updates for lifetime.
-
Do i have to buy this module for each version ?
- Yes, you have to buy this module for each version.
Support
Why Us?
Devintelle Odoo Services
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) • Invoicing (account) • Purchase (purchase) |
| Lines of code | 5990 |
| Technical Name |
dev_warehouse_average_costing |
| License | LGPL-3 |
| Website | https://www.devintellecs.com |
Please log in to comment on this module