# 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FUi5cDqWKfh3jzHLiL0IA%2FChoose%20Configuration%20and%20browse.png?alt=media&#x26;token=83bd4a00-290c-46e0-a778-84bb71b0ba81" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FTHfz5Zfdk9YW1bKGz1Ey%2FInvalid%20Doc%20No.png?alt=media&#x26;token=d6b62162-ae96-4aa9-8756-aa110d257c99" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FQN88zoHxw0S5vZwf7Vwq%2FDuplicate%20GST%20Group.png?alt=media&#x26;token=412ae46c-f4f9-4360-a2ee-877155754b63" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FxNbwuVqyd176sUXHeukg%2FMap%20Only.png?alt=media&#x26;token=a8250899-8fc8-4111-96e2-d355b14f4551" 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="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FzC8NCyAPs0Nnlt48Ew7q%2FGST%20in%20Excel.png?alt=media&#x26;token=8f906b2c-d61f-4d23-a253-816236b8dfbb" 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**](https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/troubleshooting/support-tickets) through Logic ERP.
