# Import Purchase from External File (Excel/Text)

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

### 📥 **Importing Purchase Vouchers in Logic ERP**

In this tutorial, we’ll show you how Logic ERP makes it easy to **import purchase vouchers** from external files. 🧾✨\
Importing vouchers properly is essential for maintaining ✅ accurate financial records and 📊 seamless operations.

***

#### 🪜 **Step-by-Step Guide**

***

#### 🔓 **Access Import Option**

1. Expand the **Utilities** menu 🛠️
2. Select **Import Masters/Transactions from External Files.**
3. Click on **Import Purchase Vouchers from External File** option 📂\
   This is your starting point to bring external data into Logic ERP.

***

#### 🧰 **Prepare for Data Import**

**🗂️ Select Configuration and File**

* Choose the **correct configuration** for the import. This setup determines how the data from the file will map to the ERP system. 🧠
* Use the **Browse** option to select your Excel file 📄  that contains your purchase vouchers data.
* Click **Refresh** 🔄 to load the most recent data—helps minimizing errors due to outdated information.

***

#### ✅ **Data Validation**

Validate the data being imported:

* Make sure the **"Invalid Doc"** column says **"No"** 🚫📄\
  (This means there are no bad entries!)
* Check if the **build details** appear correctly under the header details grid.\
  🔍 Correct mapping = smooth import!

***

#### 🧾 **Supplier and Voucher Details**

* Enter the **Supplier Name** 👤 to link the voucher correctly.
* Fill in all required **purchase details** as per the ERP system. 💬

***

#### 💾 **Saving and Reviewing Entries**

* If you spot **invalid items**, review and correct them before proceeding ⚠️.
* If everything looks good ✅, click **Save Bill** to finalize the import 💾.

***

#### 🔍 **Verification of Purchase Entry**

* Verify that the purchase voucher has been saved correctly within the system.
* Search for the voucher you just saved. 🔎
* Cross-check all fields to ensure accuracy. 🧾✔️
* Need to make changes? Click on **Modify** 🛠️ button to update purchase details.

***

#### 🎯 **Wrap-Up**

By following these steps, you can **efficiently and accurately import purchase vouchers** into Logic ERP.\
It’s a great way to keep your financial records 📚 clean, consistent, and compliant!


---

# 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/retail/inventory-management/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.