Cause

When the value in Import data from row is greater than value after to.

Resolution

1. Press Alt+O (Import) > Manage > Mapping Templates > Masters or Transactions > Alter, and select the template to alter.
2. In the Import data from row and to fields:
   1. Ensure to enter whole numbers
   2. Ensure that the value in the to field is greater than or equal to the value in Import data from row field.

Cause

When the value in Import data from column is greater than the value after to.

Resolution

1. Press Alt+O (Import) > Manage > Mapping Templates > Masters or Transactions > Alter, and select the template to alter.
2. Ensure that the value in the to field is greater than or equal to the value in Import data from column field.

Cause

When the value in Row no. for column headers is greater than the value in Import data from row. 

Resolution

1. Press Alt+O (Import) > Manage > Mapping Templates > Masters or Transactions > Alter, and select the template to alter.
2. Ensure that the value in the Row no. for column headers field is lesser than the value in the Import data from row field.

Cause

If the value for Import data from row is lesser than the Row no. for column headers.

Resolution

1. Press Alt+O (Import) > Manage > Mapping Templates > Masters or Transactions > Alter, and select the template to alter.
2. Ensure that the value in the Import data from row field is greater than the value in the Row no. for column headers field.

Cause

If the selected Excel File cannot be read.

Resolution

Select a valid Excel file and try again.

Cause

If the Excel application is not installed in your system.

Resolution

Install the application or check the extension of the file.

Cause

The selected mapping template is corrupt, invalid or not available due to which TallyPrime failed to create the map file before import.

Resolution

• Check the existing Map File or the mapping of fields in TallyPrime to the Excel columns.
• Check the Event Log to know the reason for errors.

Cause

One or more required fields are missing or not mapped correctly in the mapping template. The missing or incorrectly mapped field is displayed in the Calculator Panel.

Resolution

1. Check the Calculator Panel to identify the missing or incorrectly mapped field.
2. Correct the mapping of the required field in the mapping template and try importing again.

Cause

The Unique On value is not specified for either the row or column required to uniquely identify the masters/vouchers.

Resolution

1. Check the Unique On values in the mapping template.
2. Specify the required Unique On row and Unique On column, and save the mapping template again.

Cause

When the entire mapping template is empty.

Resolution

Enter the details and map the fields in TallyPrime to the columns in Excel.

Cause

When the end column number is greater than max limit.

Resolution

Enter a value from A to ZZ and try again.

Cause

When start row/column is greater than end row/column.

Resolution

Enter a value for start row/column lower than end row/column.

Cause

Disc memory is missing to store the file into the system.

Resolution

Restart TallyPrime or clear the space in your system.

Cause

The selected file is invalid, inaccessible, or cannot be opened by TallyPrime.

Resolution

Select a valid file and try again.

Cause

The selected Excel file is missing from the specified folder path or cannot be accessed by TallyPrime.

Resolution

1. Ensure that the Excel file exists at the specified folder path and you have read permission for the file.
2. Select the file again and try importing.

Cause

Invalid Excel Sheet Name.

Resolution

Select a valid Worksheet Name and try again.

Cause

One or more fields in TallyPrime are mapped incorrectly to the corresponding columns in Excel in the mapping template.

Resolution

Check and correct the mapping between the fields in TallyPrime and corresponding columns in Excel, and then save the mapping template again.

Cause

When the file name and path specified in Import Transactions screen is incorrect.

Resolution

Specify the correct path and then import the data.

Cause

This error occurs when:

1. You import closing balances from an existing company into a newly created company, but the required Stock Ledger is not available in the new company.
2. The Stock Ledger is not available in the newly created company.

Resolution

Create the required stock ledgers in the newly created company and enter their closing balances manually. Other masters can be imported successfully.

Cause

The application MS Excel has not been installed in the system.

Resolution

Install MS Excel in the system, since TallyPrime requires MS Excel to carry out the process of exporting in the Excel (Spreadsheet) format. Once the file is exported, it can be opened using other applications like Open Office, Star Office, etc.

Refer to Cheque No. is not within Cheque Range/Invalid Cheque Range/Mismatch in Cheque Range | TallyHelp. 

Refer to No Accounting or Inventory Entries are Available | TallyHelp. 

Refer to Due Date of Order is Missing in Item Allocations | TallyHelp. 

Refer to Incorrect Ledger Selected in Bank Allocations | TallyHelp.