I have created an .IIF file for input into QuickBooks Premier (AE)
that includes an INVOICE transaction followed by a PAYMENT
transaction. However, even though I have marked the "PAID" column
with "Y" on all lines of the transaction, the INVOICE still shows up
in QuickBooks as unpaid. The transaction looks like this:
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO DUEDATE PAID EXTRA
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO DUEDATE EXTRA
!ENDTRNS
TRNS 5 INVOICE 05/16/02 Accounts Receivable:Deposits Due Smith,
Fred Paris 1 - 1BR Terr 1003.0000 100043_S Security
Deposit 06/07/02 Y AUTOSTAX
SPL 1 INVOICE 05/16/02 Advance Deposits:Security Smith, Fred Paris 1 -
1BR Terr -1000.0000 100043_S Security Deposit Y AUTOSTAX
SPL 1 INVOICE 05/16/02 Advance Deposits:Other Smith, Fred Paris 1 -
1BR Terr -3.0000 100043_O Other Deposit Y
ENDTRNS
TRNS 10 PAYMENT 05/16/02 Checking BBT Smith, Fred Paris 1 - 1BR
Terr 1003.0000 100043_S Security Deposit Y
SPL 1 PAYMENT 05/16/02 Accounts Receivable:Deposits Due Smith,
Fred Paris 1 - 1BR Terr -1003.0000 100043_S Security
Deposit 06/07/02 Y
ENDTRNS
How do I make the INVOICE show up as being PAID by the PAYMENT? |