HSN Code Error in Purchase Import

YouTube: HSN CODE DOES`NT EXIST IN DATABASE ERROR DURING PURCHASE IMPORT

HSN CODE DOES`NT EXIST IN DATABASE ERROR DURING PURCHASE IMPORT

This tutorial covers how to troubleshoot and resolve common errors encountered while importing purchase vouchers from external files (e.g., Excel or CSV) into Logic ERP.

Issue Overview

• Scenario: Importing purchase data from an external file.

• Error: "Invalid Document: {Yes}" – usually due to missing or undefined HSN codes.

  • Note: You can also read the Invalid Remarks to understand the reason behind the error or why the purchase import is not working.

• Objective: Fix the error and complete the import process successfully.

Step-by-Step Process

1. Begin Import Process

• Navigate to the Utilities\Import Masters/Transactions from External Filesand click on "Import Purchase Vouchers From External File".

2. Select and Load the File

• Click Browse and choose your Excel or CSV file.

• Select the appropriate sheet.

• Click Refresh to load the file.

Identifying the Import Error

• In the Header Details section:

  • If the Invalid Document column displays "YES", there is an error.

• Go to Item Details Grid.

• Scroll right to locate the Invalid Remarks column.

Example Error:

• “HSN code does not exist in database”

Fixing the HSN Code Issue

Option 1: Import HSN Codes from Excel

• Navigate to: Setup and click on Setup Items.

• Select Setup Harmonious Code Descriptions.

• Click Retrieve from Excel

• Use the Help option to check required columns (first two marked with * are mandatory)

• Browse and select your HSN Excel file

• Choose the sheet and click Refresh

• Click Save to import HSN codes

Option 2: Manually Create HSN Code

• Complete the fields as outlined below:

  • Harmonious Serial Number

  • Harmonious Code

  • Description

• Click on Save

Re-Attempt the Purchase Import

• Repeat import steps:

  • Browse the same file

  • Select the correct sheet

  • Click Refresh

• The Invalid Document column should now display "No"

Finalize the Import Process

1. Enter the Account Name

2. Select the Godown where stock will be added

3. Click Save

4. A confirmation message will appear – click Yes to proceed

5. Wait while the bill is imported

6. A summary window will show the bill total

7. Click Save to finalize

Validate Imported Transaction

• Navigate to: Purchase Voucher Window

• Use Modify/Search to locate the imported bill

• Review and confirm all details are correct

Need More Help?

If the issue persists:

• Double-check all HSN codes are correctly defined

• Ensure formatting and column headers match import requirements

• Submit a support ticket if further assistance is needed