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! 💡📦📈

Last updated