Import serial /IMEI number wise bulk purchase from external file (Excel/Text)

YouTube: Import Serial numbers from Excel

📥📱 Import Mobile/SIM Serial Numbers via Excel – Step-by-Step Guide

This tutorial provides a comprehensive walkthrough for importing🔑 mobile or SIM serial numbers from an Excel sheet and linking them to specific items within a purchase voucher. This process is designed to streamline inventory management, eliminate the need for manual data entry and saves time ⏱️.

---

🧾Overview

When mobile devices or SIM cards are purchased, it's essential to track their unique serial numbers🔢 for inventory, warranty, and compliance purposes. The system provides a feature to import these serial numbers directly from an Excel file📊, making the process quick and error-free✅.

---

🛠️Step-by-Step Instructions

🔹Step 1: Navigate to the Purchase Menu

• 🔐Log into Logic ERP.

• 📁From the main menu, click and expand the Purchase option.

• 🧾Then select to open Assign SIM/Mobile Numbers against Purchase option.

• 📋This option opens the serial number assignment window, where you can associate serial numbers with purchased items.

This section displays all purchase-related activities, including invoices, vouchers, and stock entries.

---

🔹Step 2: Select a Purchase Voucher

1. 🧾 View the list of purchase vouchers.

2. 🔍 Use search or filters to find the relevant voucher quickly.

3. ✅ Select the voucher for which you want to assign serial numbers.

---

🔹Step 3: Choose the Relevant Items

• 📦Once the voucher is selected, a list of items included in the purchase will be displayed.

• 📱Select the specific items (e.g., mobile phones, SIM cards) that require serial number entry.

---

🔹Step 4: Import Serial Numbers from Excel

• 📤Click on the Import from Excel or Upload Excel button available in the toolbar.

• 🗂️A file browser window will appear.

• 📑Locate and select the Excel file from your device that contains the list of serial numbers.

  📌Note: Ensure the Excel sheet is properly formatted. Each serial number should be listed in a single column, and the number of serials must match the quantity of the selected item(s).

---

🔹Step 5: Automatic Assignment of Serial Numbers

• 🤖After selecting the file, the system will automatically read the serial numbers and assign them to the respective items in the purchase voucher.

• ✅You will see a confirmation message once the import is successful.

• ⚠️If there are any mismatches or errors (e.g., missing serials, invalid formats), the system will notify you for correction.

---

✅Final Confirmation

• 🔍Review the assigned serial numbers to ensure accuracy.

• 💾Save or confirm the assignment to finalize the process.

---

🏁Conclusion

By using the Excel import feature, you can efficiently assign mobile or SIM serial numbers without:

• ❌ Manual errors

• 🚀 You speed up the process

• 📊 Keep accurate inventory trail for future tracking and audits.

• 💼 Especially useful for bulk purchases!

Stay organized, stay efficient! 💡📦📈