Import Lot/Serial Number in Picking-Receipt and Transfer from Excel File
by BROWSEINFO https://www.browseinfo.com/demo-request?app=import_lot_serial_no&version=18&edition=Community$ 62.39
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Purchase (purchase) • Sales (sale_management) • Discuss (mail) • Invoicing (account) |
| Lines of code | 539 |
| Technical Name |
import_lot_serial_no |
| License | OPL-1 |
| Website | https://www.browseinfo.com/demo-request?app=import_lot_serial_no&version=15&edition=Community |
| Versions | 9.0 10.0 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 |
India | 
Malaysia 
Import Serial Number and Lot Number in Picking/Receipt and Internal Transfer From Excel Odoo Apps
Don't you get irritated by importing lots of serial number while receiving product and transfer goods. Don't you think its reduce your effective productivity to total time waste, importing serial number is import task for WMS must be done carefully , when orders are big on regular basis the whole process become super lengthy, so its defiantly take a toll on your efficiency. This Odoo apps module allow you import lot and serial number in bulk from vendor in incoming shipping and for internal transfer process, it will make whole process so simple less time consuming.
Import Bulk Serial Number for Incoming Shipment using Excel file.
When you get shipment from vendors, Our module allow you to import bulk Serial number in incoming receipt using excel file.
Import Bulk Lot Number for Incoming Shipment using Excel file.
When you get shipment from vendors, Our module allow you to import bulk Lot number in incoming receipt using excel file.
Import Bulk Serial Number for Internal Transfers using Excel file.
When you get shipment from vendors, Our module allow you to import bulk Serial number in incoming receipt using excel file.
Import Bulk Lot Number for Internal Transfers using Excel file.
When you get shipment from vendors, Our module allow you to import bulk Lot number in incoming receipt using excel file.
Import Serial Number and Lot Number
Data File Sample.
Given below is the sample of import file to upload lot and serial number,It is mandatory to use given format to create XLS file.
Import with Lot
Import with Serial Number
- LOT
- - Lot number for the product.
- SERIAL NO
- - Serial number for product.
- QTY
- - Quantity of product lot.
- Expiration Date
- - Expiry date of lot and serial number.
Import Serial Number and Lot Number in Picking Receipt
Import Lot Number
in Incoming
Shipment
Under Product > Inventory > Traceability set "Tracking" as "By Lots" to import product
with lot number on incoming shipment.
Now suppose you have made order of 22 quantity and its generated shipment for that purchase as shown in fig. Now if you want to Import it then you have to select the button which is highlighted in the fig.
Once you click on the button, you will see one wizard which is shown in the fig. Here you have to click on Import Lots/Serial Number Button.
Clicking the "Import Lot/Serial Number" button opens a wizard where you can choose to import either lot numbers or serial numbers based on your product's tracking configuration.
You can download sample file to import lot and serial number by enable "Download Sample Files" option and select "Sample Type" as CSV or XLS and click "DOWNLOAD SAMPLE FILE" button on wizard.
You can shows all set and all lot/serial numbers are imported with expiration date. Now you have to just confirm it.
On click of "Confirm" button you can see picking order's done quantity as per demanded quantity with lot number.
Import Serial
Number
in
Incoming
Shipment
Under Product > Inventory > Traceability set "Tracking" as "By Unique Serial Number" to import product with serial number on incoming shipment.
Now suppose you have made order of 4 quantity and its generated shipment for that purchase as shown in fig. Now if you want to import product with serial number then you have to select the button which is highlighted in the fig.
Once you click on the button, You can see opened "Detailed Operations" wizard, here click on "Import Lot/Serial No" button.
On import wizard you have to select "Serial No" option and upload file containing serial number for product.
You can download sample file to import lot and serial number by enable "Download Sample Files" option and select "Sample Type" as CSV or XLS and click "DOWNLOAD SAMPLE FILE" button on wizard.
Once you click on "Import" button You can see serial number for product will imported with expiration date from excel file.
On click of "Confirm" button you can see picking order's done quantity as per demanded quantity with serial number.
Import Lot
Number in
Internal Transfer
Under Product > Inventory > Traceability set "Tracking" as "By Lots" to import product with lot number on incoming shipment.
Now suppose you transfer 22 quantity and you want to import it with lot number then you have to select the button which is highlighted in the fig.
Once you click on the button, you will see new wizard which is shown in the fig. Here you have to click on Import Lots/Serial Number Button.
Once you click on Import Lot/Serial Number button which we discussed above, you will get another wizard which is shown in the fig.And you will get option to choose import serial number or lot number based on your product's tracking configuration.
You can shows all set and all lot/serial numbers are imported. Now you have to just confirm it.
On click of "Confirm" button you can see picking order's done quantity as per demanded quantity with lot number and you can validate transfer.
Import Serial Number and Lot Number in Internal Transfers
Import Serial
Number in
Internal Transfer
Under Product > Inventory > Traceability set "Tracking" as "By Unique Serial Number" to import product with serial number on incoming shipment.
Now suppose you transfer 4 quantity and you want to import it with serial number then you have to select the button which is highlighted in the fig.
Once you click on the button, you can see opened "Detailed Operations" wizard, here click on "Import Lot/Serial No" button.
On import wizard you have to select "Serial No" option and upload file containing serial number for product.
Once you click on "Import" button you can see serial number for product will imported from excel file.
On click of "Save" button you can see picking order's done quantity as per demanded quantity with serial number.
Version : 15.0.0.0
26 October 2022
Initial release of the app.
Version : 15.0.0.7
22 April 2025
Add functionality to import lot or serial number with Expiration date
Can I Use this module with Odoo Online ?
Do I got free support when I buy an App ?
Do I have to buy module for each version ?
How can I install the module I bought ?
The module I bought doesn't work, What should I do ?
Get Support, For Free!
60 Days Free Support
In case any bugs or issue (Except data recovery)
At Browseinfo we offer end to end solution for Odoo services. Which includes analysis & consultation on the workflows and integration part.
Have Any Question ?
+91-6351620270
Write Email
Sales : sales@browseinfo.in
Support : support@browseinfo.in
Must-Have Apps
Best of the Best Apps
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module