On occasion, errors occur during data importing and it’s important to understand import errors so that we can rectify the issues and import successfully. After an import, Intacct will email these error messages to the user which that is why it is very important to enter your email address into the appropriate field prior to running the import. As shown below, the email address is to be entered into the Import Company Information screen, which is the screen where you’ll choose the file you wish to import and begin the import.
The error report emails are read from the top down and the errors themselves are organized into error sections within the email. In the example shown below there are 3 distinct error sections being displayed as indicated by the coloured boxes.
Starting with Error Message Section 1 above you can see that two of the Transactions being imported already exist. This is perhaps because this file was already imported once and those line items were successfully imported that time but were not removed from the file. Another possible reason for this is that the transaction number or vendor number was typed incorrectly.
Within each error section it is often important to read the error messages from the bottom up. In Error Message Section 1 above the error messages are both of type Description and although they are the same error they are independent of each other. In Error Message Section 2 however, you can see that one line is of type Description and the other is of type Correction. In those cases we recommend reading the Correction first, then the Description, i.e. from the bottom up.
For example, in Error Message Section 2 above you can see the error text on the bottom line reads “Enter a valid account number on line item 2, in transaction ‘73432’, and try again.” This text indicates to you which Transaction ID was the problem and which line item to look at. Reading the next line up we get more specific information about that error in the form of the Description which reads “Invalid transaction The account number ‘8230’ is invalid.”. This tells you exactly what the problem account number is on line item 2 in transaction 73432. You will need to correct this account number prior to re-importing.
Reading the Correction line of Error Message Section 3 you can see that some of the fields in your line item were invalid and they must be corrected with the proper values. To get more information on how to fix this error you can read the Description which states that the contact data entered was invalid and that the vendor must have a contact. The next step will be to find the vendor in question and ensure they have a contact correctly set up.
The length of your error email will depend on how many records failed to import. You will want to read each Error Message Section independently and take the necessary steps to fix the issues then re-import the data. Should any records fail to import on your second run through, simply download the error csv file and then go through the new error email to correct the outstanding issues. Note: It is possible to have several errors for a single record that failed.
