Reassign lot/ serial numbers

Estimated reading: 2 minutes 70 views

Introduction

When switching a product’s tracking method in Odoo from No Tracking to By Lots or By Unique Serial Number, it’s important to properly reset and reassign inventory. Failing to do so can lead to inconsistent records, especially if products were already stored without tracking information. This guide outlines how to use inventory adjustments to correct these issues.

Step 1: Set On-Hand Quantity to Zero

Navigate to Inventory app → Products → Products.
Select the product that needs to be updated.
Click the On Hand smart button to access the Update Quantity
In the On Hand Quantity column, set the quantity to 0.
If the product exists in multiple locations, ensure that the total quantity across all locations is set to zero.

Step 2: Change the Traceability Setting

Go back to the product form (Inventory tab).
In the Traceability section, change the Tracking setting from No Tracking to either:
- By Lots, or
- By Unique Serial Number

Step 3: Restore the On-Hand Quantity with Lot/Serial Numbers

From the same product form, click the On Hand smart button again.
On the Update Quantity page, a warning appears: No Stock On Hand.
Click the New button at the top-left.
Enter a new line with:
- A Lot/Serial Number
- The On Hand Quantity you previously had
Save the adjustment.

Tip: Recover Original Quantity

To view previous quantities:
1. Click the ✏️ (pencil) icon in the On Hand Quantity
2. Click the History button on the far right.
3. The inventory adjustment that changed the quantity to zero will show the original value.

Reassign lot/ serial numbers

Introduction

Step 1: Set On-Hand Quantity to Zero

Step 2: Change the Traceability Setting

Step 3: Restore the On-Hand Quantity with Lot/Serial Numbers

Tip: Recover Original Quantity

Related Articles