Purchase Import Error - Item details not found for all items
Last updated
Last updated
YouTube:
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.
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."
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.
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.
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.
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.
Open the Excel sheet.
Correct the Group Name spelling or format to match Logic ERP exactly.
Save the updated file.
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.
Navigate to the Purchase Voucher window.
Search and modify the imported bill to verify the entries.
If the issue still persists:
Double-check group names and column headers.
Use the early validation feature for every import.
If needed, raise a through Logic ERP.
