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
🧾 View the list of purchase vouchers.
🔍 Use search or filters to find the relevant voucher quickly.
✅ 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