Skip to content

Check valuation after a return or additional receipt

Quick summary: Matching received and billed quantities does not guarantee correct remaining stock value. After a return or additional receipt, check valuation and any consumption expense already recorded.


Open Inventory in Odoo

Your Odoo address

Enter the base address of your Odoo instance. It will be stored only in this browser.

The documentation does not receive your address, username, or password.

The remaining-value calculations in this guide apply to FIFO valuation. For another costing method, ask accounting to verify the calculation first.

Agree with accounting whether the bill is a reliable basis for the correction. This is a business decision, not a general Odoo rule. Check credit notes and units of measure. Do not change an old box-to-piece conversion without reviewing the other products and documents that share that unit.

Check stock at the correct location, reservations, completed returns and open documents. Do not return goods that have already been consumed by creating negative stock. You need permission to process stock movements; Adjust Valuation requires Inventory administrator rights.

  1. On the order, compare net posted bills and credit notes with received quantities. Include completed returns.
  2. For an excess receipt, open the original receipt and click Return. Return only the available excess from the appropriate location. Use Update quantities on SO/PO when the return must correct the order’s received quantity. Check the effect on the order before validating.
  3. For a shortfall, check the open receipt first. If it represents the missing goods, correct that document. Create an additional receipt only after ruling out duplication and identifying its order link and correct destination location.
  4. Validate the agreed correction and check the received quantity on the order. An unvalidated return is not a completed movement. Reversing a completed return requires a separate reverse business event; it is different from cancelling a draft.
  1. Open Inventory > Reporting > Stock and click the product’s Total Value. Review incoming movements, remaining quantities and remaining values. To see the full history, remove the default remaining-quantity filter and, if needed, the incoming-movements filter.
  2. Calculate the net purchase value from bills and credit notes, excluding recoverable VAT. Consider the actual order links and landed costs.
  3. Determine remaining stock value from the relevant FIFO receipts. Do not use the average price across all purchases when prices differ and stock has been partly consumed.
  4. If an incoming movement has an incorrect value, select one movement and use Adjust Valuation. Enter the value of the whole movement, not just its currently remaining part. Add a reason and save.
  5. Ask accounting to compare net purchase value, correct remaining stock value and consumption expense already recorded. Post any additional expense only when consumption is substantiated by the related documents.
  6. Check the valuation closing and general ledger balances. Confirm that the correction has not changed taxes, supplier liabilities or entries that were already correct.

A receipt originally contained 20 units. After correction, 2 remain; their bill totals €24.00 and the correct unit price is €12.00. If the remainder still belongs to the original 20-unit incoming movement, the correct New Value for that movement is €240.00. FIFO then assigns €24.00 to the 2 remaining units. Setting the whole movement to €24.00 would leave only €2.40 on the remainder.

This example assumes a simple receipt and return without other costs. Where purchase prices and returns vary, trace the individual movements.

Do not add value to empty stock. For a fully substantiated, completed history: net purchase value = remaining stock + expense already recorded + required additional expense. Review existing entries first to avoid recording the same consumption twice.