cancel
Showing results for 
Search instead for 
Did you mean: 
masson1964
Level 1

IIF Import Error - If the transaction header contains a date, then the distribution line must have the same date [11091]

I'm attempting to import a IIF file from my Volusion website to QuickBooks. But each TRNS record has the error "If the transaction header contains a date, then the distribution line must have the same date [11091] ".

 

The format is a TRNS record followed by multiple SPL records. There are three dates on the TRNS record and no dates in the SPL records. So I'm at a loss regarding the distrubution line? Does anybody have any ideas?

 

I've attached a screen shot of the pertinent lines in the IIF file.

9 Comments 9
Fiat Lux - ASIA
Level 15

IIF Import Error - If the transaction header contains a date, then the distribution line must have the same date [11091]

Which QBD year version do you have? 

masson1964
Level 1

IIF Import Error - If the transaction header contains a date, then the distribution line must have the same date [11091]

Using QuickBooks Desktop Pro Plus 2021

katherinejoyceO
QuickBooks Team

IIF Import Error - If the transaction header contains a date, then the distribution line must have the same date [11091]

Welcome to the Community and thanks for the screenshot, @masson1964. I'll be here to help you handle IIF import in QuickBooks Desktop.

 

You'll need to add both TRNS and SPL for each date range before importing your IIF files to avoid getting errors like this. When you're all set, you can now import your IIF file again.

 

If you get the same result, I recommend getting in touch with our Customer Care team so we can review your account and determine what's preventing you from importing the file.

 

Here's how to contact our support:

 

  1. Go to the Help menu, then select QuickBooks Desktop Help.
  2. On the pop-up screen, choose Contact us.
  3. Enter your concern on the Tell us more about your question box, like "IIF files import error."
  4. Click the Search button.
  5. Select either the Call us or Message Us option.

 

Here's an article in case you'll need some steps to guide you in performing other tasks with your IIF files, such as bulk editing them, etc. Please head to this link for more details: Tasks you can do with IIF files.

 

I'm always around here to guide you more if you need additional assistance. Take care. 

 

masson1964
Level 1

IIF Import Error - If the transaction header contains a date, then the distribution line must have the same date [11091]

I'm not sure what you mean by "You'll need to add both TRNS and SPL for each date range". 

 

I have a TRNS record with 3 dates (DATE,DUEDATE,SHIPDATE). The SPL records don't have a date field.

Fiat Lux - ASIA
Level 15

IIF Import Error - If the transaction header contains a date, then the distribution line must have the same date [11091]

@masson1964 

IIF file must now (on QBD 2019 or later) be tab-separated as opposed to comma-separated. It's an easy fix you can do in notepad, or you can do it when you select the file type to save from Excel. Try this method or you should try another app to isolate the issue.

BigRedConsulting
Community Champion

IIF Import Error - If the transaction header contains a date, then the distribution line must have the same date [11091]

@masson1964  RE: There are three dates on the TRNS record and no dates in the SPL records. 

 

That's why you're getting the message.  No dates aren't the same as having dates.

masson1964
Level 1

IIF Import Error - If the transaction header contains a date, then the distribution line must have the same date [11091]

In the examples I looked at there was no DATE field for SPL records. But I did find a field called "DATE" in a old sample file from Intuit from 2007. I'll give it a shot. I don't know why each SPL record would require a date as the TRNS record already has one. Thanks!

masson1964
Level 1

IIF Import Error - If the transaction header contains a date, then the distribution line must have the same date [11091]

Yes, my file is tab delimited.

Fiat Lux - ASIA
Level 15

IIF Import Error - If the transaction header contains a date, then the distribution line must have the same date [11091]

@masson1964 

Utilize the trial version of an importer tool to isolate the issue.

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Need to get in touch?

Contact us