Assign SIM/Mobile Numbers Against Purchase

YouTube: Import Serial numbers from Excel

Import Serial numbers from Excel

This tutorial demonstrates how to import mobile serial numbers (IMEI numbers) from an Excel file in Logic ERP during the purchase process. This feature helps automate serial number entry, saving time and reducing manual errors.

---

Objective of This Feature

• Bulk import mobile/IMEI serial numbers

• Avoid manual entry of serial numbers

• Improve accuracy and efficiency in purchase entries

• Simplify inventory tracking

---

Navigate to Serial Number Assignment

• Go to Purchase Menu

• Open Assign SIM/Mobile Numbers Against Purchase

---

Select Purchase Voucher

• Choose the relevant Purchase Voucher from the list.

• Select the items for which serial numbers need to be assigned.

---

Import Serial Numbers from Excel

• Click on the Excel Import Option

• Browse and select the Excel file from your device

Important Note

• Ensure:

  • Serial numbers are properly formatted in Excel

  • Data is clean and without duplicates

Automatic Assignment

• Serial numbers will be:

  • Automatically imported

  • Assigned to selected items

---

Key Benefits

• Saves time in bulk serial number entry

• Eliminates manual input errors

• Ensures accurate IMEI tracking

• Enhances inventory management efficiency

---

Best Practice Tips

• Verify Excel data before importing

• Maintain correct serial number format

• Avoid duplicate entries

---

Final Outcome

• Mobile serial numbers are successfully imported from Excel

• Items are accurately mapped with serial numbers

• Purchase process becomes faster and error-free