Invoice imported through iif file is shown as successful but no invoice found on reckon

  • 1
  • Question
  • Updated 1 year ago
  • Answered
I am trying to import iff file with following data:
!TRNS	TRNSID	TRNSTYPE	DATE	ACCNT	NAME	AMOUNT	DOCNUM	CLEAR
!SPL SPLID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM CLEAR TAXABLE
!ENDTRNS
TRNS 1 TAX INVOICE 06/20/17 Consulting fees Vincent 200 234 N
SPL 2 INVOICE 06/20/17 Consulting fees Vincent -100 234 N Y
ENDTRNS

Reckon Accounts Hosted shows that the import was successful, but I cant see any invoice under Customers > Transaction > Invoices (or for that matter, under any item under transaction)

what am I doing wrong.. also, I have a new account, so the only thing that I created is a customer (Vincent)..
Photo of Faisal Ali

Faisal Ali

  • 90 Points 75 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 5,882 Points 5k badge 2x thumb
Hi Faisal - I am away from my normal computer at present so I can't check 100% but I am pretty sure the problem is with the word TAX INVOICE - I think this should just say INVOICE, the same as the split line... you are also missing the taxcode field and the taxamount fields?  I think you have done this because its what the help file says? (I believe this relates to the old US version and isnt completely accurate?) but in my experience with POS and importing tranactions - these fields should contain the same name on both the TRNS and the SPL lines...  I think perhaps get on to Reckon tech support and ask them to send you the format for Australia?
Photo of John G

John G, Information Support Analyst

  • 27,290 Points 20k badge 2x thumb
Hi Faisal,

Here is my test file...




regards,
John