Import purchase from external file (excel/text)
YouTube: Import Purchase Voucher from External file (Excel / Text)
📥💼 Importing Purchase Vouchers from Excel in Logic ERP
Importing purchase vouchers from an Excel file 📊 can help streamline data entry 🧾, minimize errors ❌, and boost efficiency ⚡. This step-by-step tutorial will walk you through the process of importing purchase vouchers into your system with ease. ✅
🔹Step 1: Access the Import Feature
To begin importing:
Open the Main Menu📂.
Expand the Utilities🛠️ menu.
Select Import Purchase Vouchers from External File📁.
This section allows you to seamlessly import purchase vouchers from an external source, ensuring consistency in records🧷.
🔹Step 2: Upload the Excel File
Once inside the import module, follow these steps to upload the Excel file containing the purchase vouchers:
🔧Choose Configuration – Select the appropriate configuration that matches the format of the data you are importing. This ensures that the system correctly maps the data fields.
📂Browse for File – Click on the Browse button and locate the Excel file on your system.
🔄Load the Data – Click Refresh to extract and display the contents of the Excel file within the system.
After performing these steps, the system will process the file and display the extracted data📄 for your review.
🔹Step 3: Validate the Imported Data
Before proceeding with the import, it is crucial to validate the data:
📋The imported bill details will be shown under the Header Details grid.
✅The Invalid Doc column should display "No", indicating that no errors were found in the document.
📑All items from the Excel sheet will be listed in the grid for review.
🚫If any invalid items exist, they will be displayed in a separate section. These must be corrected before proceeding further.
This validation step ensures data integrity and prevents errors in purchase records🧼🔍.
🔹Step 4: Save the Purchase Voucher
Once the data has been validated, proceed to save the purchase voucher:
🧾Enter Supplier Name – Specify the supplier from whom the purchase was made.
🏢Enter Go-Down Name – If applicable, specify the warehouse or go-down where the items are stored.
💾Save the Voucher – Click on Save Bill to confirm and store the purchase voucher in the system.
By completing this step, the imported purchase data is now successfully recorded in the system📌🎉.
🔹Step 5: Verify the Imported Voucher
To ensure the accuracy of the import, verify the recorded purchase voucher:
Navigate to the Purchase option in the main menu and open the Purchase Voucher Window🛍️.
Click on the Modify✏️ button.
Search for the relevant bill🔎 using the provided filters.
✅Confirm that the purchase voucher details match the original Excel data.
This step allows users to cross-check and confirm that all information has been imported correctly and nothing is missing 🕵️♂️.
✅Conclusion
By following these steps, you can easily import purchase vouchers from Excel file 📊 to Logic ERP — saving time 🕒 and reducing errors 🧠❌and ensuring accuracy and efficiency in data entry. If any issues occur, review the invalid items section 🛑 for corrections before proceeding with the import.
Happy importing! 🎯📥
Last updated