Importing customer payments
I successfully imported iif file for customer payment of invoice but payment is not applied to related invoice. I need help to apply payment to related invoice. I attached the iif file used to import transaction in QuickBooks. Following are the transaction detail and the code I used to to import the transaction in QuickBooks Desktop:
A; Transaction Detail
1: Customer name ABC Party
2: Invoice no:051005
3: Payment method :Visa
4: Amount : 22.26
5: Date :09/26/2020
B: Code
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM PAYMETH
!SPL SPLID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM PAYMETH
!ENDTRNS
TRNS PAYMENT 09/26/2020 RBC Revenue ABC Party 22.26 051005 Visa
SPL 051005 PAYMENT 09/26/2020 Accounts Receivable ABC Party -22.26 051005 Visa
ENDTRNS
Thanks
