cancel
Showing results for 
Search instead for 
Did you mean: 
Active Member

IIF Import Error-matching dates

Attempting to import IIF Files in QuickBooks Desktop 2019 that has sales for multiple days and getting an error message [ERROR] [2019-02-07] The date in the distribution line must be the same as the transaction header [11081] .  File format imports single day sales records correctly.  If the file is hand modified to have all dates the same, the below file imports without issue. What might be missing in our setup to import invoices with multi day sales records?

 

!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT NAMEISTAXABLE ADDR1 ADDR2 ADDR3 ADDR4 DUEDATE TERMS
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE EXTRA
!ENDTRNS
; [ERROR] [2019-02-07] The date in the distribution line must be the same as the transaction header [11081]
;[2019-02-07] The date in the distribution line must be the same as the transaction header [11081]
TRNS INVOICE 2/15/2019 Accounts Receivable Dummy "332.60" 8 N Y Y Dummy 2/15/2019
SPL 1 INVOICE 2/7/2019 Dummy "-294.72" 15 Tunnel Rock - Ticket:15 - 2/7/2019 10:44:08 AM - "-36.8400" "8.00" Tunnel Rock Y
SPL 2 INVOICE 2/15/2019 Dummy "-20.94" 27 Tunnel Rock - Ticket:27 - 2/15/2019 11:11:43 AM - "-2.6175" "8.00" Tunnel Rock Y
SPL 3 INVOICE 2/15/2019 Dummy "-16.94" 28 Tunnel Rock - Ticket:28 - 2/15/2019 11:11:56 AM - "-2.1175" "8.00" Tunnel Rock Y
SPL 4 INVOICE 2/7/2019 NA "-0.00" 15 Combined Tax - Ticket:15 - 2/7/2019 10:44:08 AM - "-332.6000" "0.00" NA N AUTOSTAX
ENDTRNS

 

 

1 Comment
BRC
Established Community Backer ***

Re: IIF Import Error-matching dates

Well, the message is rather stupid as there is no reason to pay any attention to the SPL dates.  Each transaction has one date in an accounting system, not several, and SPL dates are redundant/extra information in an IIF file.  The lack of logical thinking for whoever invented this message is astounding.

 

You can work around this and leave your file the way it is using these recommendations:

BRC QuickBooks 2019 IIF Import Changes and Recommendations