Error : Portal Error : Object Reference not set to an Instance
Solution : Object Reference not set to an Instance : The error could be because of multiple reason , most probably you have something incorrect in your excel records.
This error generally happens because of some incorrect data or same voucher with different ledger name or data with some special character in it.
To solve/fix the error, Divide your entire file into two parts and process each file separately.
Check 1 : The following data in excel will cause this error, as same voucher number has been specified with different leger name
Check 1 Solution : Solution to above error
Change the Voucher number so that it's unique or use same ledger when the voucher number is common.
Check 2: You should not have any empty ledger name or empty amount or Zero value in amount column.
Check 2 Solution : The below highlighted are wrong entry and should be removed from excel. Remove empty ledger name which doesn't have amount specified. Remove ZERO value amount specified in ledger.
Check 3:
If you still have the issue , Please try this:
Let's assume you are trying to process a file with 500 records and got this error then divide the file into two files with 250 data in each file, One file will process and other will give same error.
Then divide the excel file again which gives you error into two more file , each with 125 records, One will process and other will fail.
Continue...doing this until the number of records are less then 10, So now you can check which exact row is creating this error, if there is any special character or data issue please fix the issue.
If you still have any issue, Please send us email or create ticket with error details.
Import excel to tally using Excel4Tally.com