# Import purchase from external file (excel/text)

YouTube: [Import Purchase Voucher from External file (Excel / Text)](https://youtu.be/iUw3mzxt9WM?si=w68RCC8ixsgIDg1O)

## 📥💼 **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: 

1. Open the **Main Menu**📂.
2. Expand the **Utilities**🛠️ menu.
3. 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:

1. 🔧**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.
2. 📂**Browse for File** – Click on the **Browse** button and locate the Excel file on your system.
3. 🔄**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:

1. 🧾**Enter Supplier Name** – Specify the supplier from whom the purchase was made.
2. 🏢**Enter Go-Down Name** – If applicable, specify the warehouse or go-down where the items are stored.
3. 💾**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:

1. Navigate to the **Purchase** option in the **main menu** and open the **Purchase Voucher** Window🛍️.
2. Click on the **Modify**✏️ button.
3. Search for the relevant bill🔎 using the provided filters.
4. ✅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! 🎯📥


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.logicerp.com/logic-erp-in-action-a-feature-overview/distribution/purchase/import-purchase-from-external-file-excel-text.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.