When I process a return for a product that uses the average costing method, it's returned at the average cost. I want it returned at the purchase price. Is there a solution to this issue, as it's causing the inventory valuation report to be inaccurate?
This question has been flagged
1
Reply
1839
Views
Hi,
When a product uses AVCO (Average Cost), Odoo always values returns at the current average cost, not at the original purchase price. This is expected behavior; it is how the AVCO method works by design.
Under AVCO, inventory valuation is based on the weighted average cost of all quantities on hand. When you return a product, Odoo uses that current average cost to maintain consistency in stock valuation. It does not revert to the original purchase price of the specific unit.
If you require returns to be valued at their original purchase cost, AVCO is not suitable. You should use FIFO instead, because FIFO tracks layer-based costs and returns can reference the original valuation layer.
There is no standard configuration in Odoo to make AVCO returns use the original purchase price. Changing this would require custom development and would break standard AVCO accounting logic.
Hope it helps
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
|
2
Mar 26
|
1825 | ||
|
|
0
May 26
|
920 | ||
|
|
0
Feb 26
|
4 | ||
|
|
1
Dec 25
|
2399 | ||
|
|
4
Sep 25
|
5224 |