Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Serial number assigned to two locations after skipping the PICK step

Subscribe

Get notified when there's activity on this post

This question has been flagged
inventorylocationserial_number
1 Reply
697 Views
Avatar
Benjamin ROCHE

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!

0
Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
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

0
Avatar
Discard
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
Product/Serial not unique when I try to received a returned product.
inventory serial_number
Avatar
Avatar
Avatar
2
Nov 21
5551
unique serial Number
inventory unique serial_number
Avatar
Avatar
1
Jan 25
3597
Package inside of a Package in Inventory (for storing inventory on a skid)
inventory location package
Avatar
0
Nov 22
4146
Add Serial Numbers to Existing Inventory Solved
inventory serial_number serial_numbers
Avatar
Avatar
1
Oct 25
14178
Location structure shows all inventory in v7
warehouse inventory location
Avatar
Avatar
1
Mar 15
6133
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now