# Purchase Import Error - Item details not found for all items

**YouTube:** [PURCHASE TAX DETAILS NOT FOUND FOR ALL ITEMS -ERROR WHILE PURCHASE IMPORT](https://www.youtube.com/watch?v=yoAOOou-c8o\&list=PLTq0qszGb3BOWeXsjchOzPb3loypEQRRd\&index=14)

 

This tutorial demonstrates how to identify and resolve the **"Purchase Tax Details Not Found"** error that may occur while importing purchase vouchers from an external file in **Logic ERP**.

***

### Identifying When the Error Occurs

* Navigate to the **Main Menu** and expand **Utilities Module**.
* Again Expand **"Import Master/Transactions from External File".**
* Open **Import Purchase Voucher from External File** window.
* Click on **Browse**, select the file to import, and choose the appropriate **Excel sheet**.
* Click **Refresh**.

<figure><img src="/files/absvpwLrCE7A7mm3oqB9" alt=""><figcaption></figcaption></figure>

> If the "Invalid Doc" column shows "No", it means the data structure is correct at this stage.

<figure><img src="/files/1sTBqy4rZgQ6L2raaxTH" alt=""><figcaption></figcaption></figure>

* Enter the required details:
  * **Account Name**
  * **Supplier Name**
  * **Godown Name**
* Click on **Save**.

> You will encounter an error:\
> \&#xNAN;**"Purchase tax details are not found for all items."**

***

### Understanding the Cause

This error can occur due to:

* Missing **GST column** in the Excel file.
* **Mismatch in GST Tax Group name** between Excel and Logic ERP.
* Duplicate or misspelled **Item Group** entries.

***

### **Verify and Correct Item Group Setup**

* Navigate to **Main Menu/Setup Item** and then expand **Setup Items**.
* Select **GST Tax Group** Click on **Level One**.

<figure><img src="/files/oPoGp6v6C7lTneYRcVwB" alt=""><figcaption></figcaption></figure>

> Check for duplicate or misspelled group names (e.g., "GST Apparel" vs "Gst Apparel").

* **Deallocate** items from the incorrect/duplicate group.
* **Reassign** them to the correct group.
* Delete the duplicate group to prevent confusion in future imports.

***

### **Enable Pre-validation for Imports**

To prevent such issues during the import process:

* Go back to the **Purchase Import** window.
* Click on **Configuration**.
* Under **Document Detail Column**, locate the **"Map Only Column"** next to **Field Column**.
* Set the value to **True**.

<figure><img src="/files/Zzk5VMzBlljkOtNq7WoP" alt=""><figcaption></figcaption></figure>

* Click on **Save**.

> This will trigger early validation and detect inconsistencies before the actual import.

***

### **Validate Data Again**

* Reopen the **import file**.
* Select the correct sheet and click **Refresh**.

> If the "Invalid Doc" column now shows "Yes", proceed to investigate.

* Go to **Invalid Item Details** and scroll right to view the **Invalid Remarks**.

> Common issues:
>
> * Column names in Excel don’t match Logic field names.
> * Misspelled or missing tax group names.

***

### **Fix the Excel File**

* Open the Excel sheet.
* Correct the **Group Name** spelling or format to match Logic ERP exactly.

<figure><img src="/files/kKKa0IQC05VGop4eWbSu" alt=""><figcaption></figcaption></figure>

* Save the updated file.

***

### Re-Attempting the Import

* Return to the **Purchase Import** window.
* Browse and select the corrected file and sheet.
* Click on **Refresh**.

> Confirm that the "Invalid Doc" column now says "No".

* Enter:
  * **Supplier Name**
  * **Godown Name**
* Click **Save Bill**.
* Click **Yes** to confirm the import.

> The bill will be successfully imported.

***

### **Verify the Imported Bill**

* Navigate to the **Purchase Voucher** window.
* Search and **modify** the imported bill to verify the entries.

***

### **Need Help?**

If the issue still persists:

* Double-check group names and column headers.
* Use the **early validation feature** for every import.
* If needed, **raise a** [**Support ticket**](/logic-erp-installation-configuration-and-troubleshooting-solutions/troubleshooting/support-tickets.md) through Logic ERP.


---

# 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-installation-configuration-and-troubleshooting-solutions/troubleshooting/purchase/purchase-import-error-item-details-not-found-for-all-items.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.
