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 Serial Number and Lot Number in Picking Receipt
Import Lot Number in Incoming Shipment(Purchases)
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 below in fig. Now if you want to Import it then you have to select the button which is highlighted in the below fig.
Once you click on the button, you will see one wizard which is shown below 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 below in the fig.And you will get option to choose import serial number or lot number based on your product's tracking configuration. When you choose import lot number then you have to import lot number with qty(Inside excel file), when you choose serial number then you have to import only serial number code (inside excel file , example is attached).
User can download sample file to import bill of material 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 in the above fig. that we discussed, you will get the following view which is shown below in the fig, this shows all set and all lot/serial numbers are imported perfectly.Now you have to just confirm it.
On click of "Confirm" button user can see picking order's done quantity as per demanded quantity with lot number.
On import wizard user have to select "Serial No" option and upload file containing serial number for product.
User can download sample file to import bill of material by enable "Download Sample Files" option and select "Sample Type" as CSV or XLS and click "DOWNLOAD SAMPLE FILE" button on wizard.
Once user click on "Import" button user can see serial number for product will imported from excel file.
On click of "Confirm" button user can see picking order's done quantity as per demanded quantity with serial number.
Import Serial Number and Lot Number in Internal Transfers
Import Lot Number in Internal Transfer
Now suppose you transfer 10 quantity and you want to import it with lot number then you have to select the button which is highlighted in the below fig.
Once you click on the button, you will see new wizard which is shown below 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 below in the fig.And you will get option to choose import serial number or lot number based on your product's tracking configuration. When you choose import lot number then you have to import lot number with qty(Inside excel file), when you choose serial number then you have to import only serial number code (inside excel file , example is attached).
Once you click on Import in the above fig. that we discussed, you will get the following view which is shown below in the fig, this shows all set and all lot/serial numbers are imported perfectly.Now you have to just confirm it.
On click of "Confirm" button user can see picking order's done quantity as per demanded quantity with lot number and user can validate transfer.
On import wizard user have to select "Serial No" option and upload file containing serial number for product.
Once user click on "Import" button user can see serial number for product will imported from excel file.
On click of "Confirm" button user can see picking order's done quantity as per demanded quantity with serial number.
