Purchase Import Error - Item details not found for all items

YouTube: PURCHASE TAX DETAILS NOT FOUND FOR ALL ITEMS -ERROR WHILE PURCHASE IMPORT

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.

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

  • Enter the required details:

    • Account Name

    • Supplier Name

    • Godown Name

  • Click on Save.

You will encounter an error: "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.

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.

  • 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.

  • 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 through Logic ERP.

Last updated