Skip to Content
Menu
This question has been flagged
1 Reply
112 Views

Hello,

I am using the Inventory module with a 2-step outgoing shipment flow (PICK + OUT), and I manage my products with serial numbers. I am using Odoo 18 on Odoo.sh


For one customer delivery, I had to prepare items on different days.

  • On the first day, I validated a PICK removing Product A.
  • Later, when preparing the same product, I mistakenly skipped creating a new PICK and directly selected the serial number (e.g. 001) in the OUT (Output to Customer) step.

Now Odoo shows the serial number 001 in two locations at once:

  • Stock location
  • Customer location

I tried several things to fix this:

  • Creating a new PICK with the same serial number → still shows 001 in 2 locations (Output + Customer).
  • Setting stock to 0 with an inventory adjustment → still shows 001 in 2 locations (Adjustment + Customer).
  • Returning the OUT (which creates an IN from the customer) → still have 2 serial numbers 001.

In the Serial Numbers Kanban view, serial number 001 is now in None Location. When I try to move it, Odoo gives this error: "Invalid Operation: You can only move a lot/serial to a new location if it exists in a single location."

What is the best way to correct this situation and clean up a serial number that is stuck in multiple locations due to a skipped PICK step?

Thanks in advance for your help!

Avatar
Discard
Best Answer

Hi,


You encountered a serial number integrity issue in Odoo caused by skipping the PICK step in a two-step delivery flow (Pick + Out). By directly assigning the serial number in the OUT step, Odoo now thinks the same serial exists in two places,  in stock and with the customer, which leaves it stuck in the "None Location" and prevents further moves.


The best way to fix this is to first cancel or return the problematic OUT delivery so the serial comes back from the customer to stock. Then, unreserve and correct the PICK, reassign the correct serial, and validate the moves in the proper order. If that does not resolve the duplication, an Inventory Adjustment can reset the serial by forcing its quantity to zero in all wrong locations and re-adding it correctly in the right place.


As a last resort, if even inventory adjustments fail, the issue can be fixed at the database level by cleaning up duplicate entries in the stock_quant table, though this should be done carefully and only with proper backups.


To prevent this problem in the future, always follow the complete multi-step process, use partial deliveries or split shipments if items are prepared on different days, and cancel and redo moves if mistakes happen instead of bypassing steps.


Hope it helps

Avatar
Discard
Related Posts Replies Views Activity
2
Nov 21
5241
1
Jan 25
3176
0
Nov 22
3822
1
Aug 24
13428
1
Mar 15
5757