Importing iif file for invoices, class field is not working

  • 1
  • Question
  • Updated 4 weeks ago
  • Answered
We have begun using 3rd party software to produce our invoices, and then import the invoices into Reckon (we are on the 2018 desktop version) by way of an IIF file. This is working fine with the exception of the Class field. We use class tracking to report on our separate branches, and although the Class field appears in the IIF file it doesn't come through on the invoices in Reckon. Any suggestions please?
Photo of Melissa Read

Melissa Read

  • 90 Points 75 badge 2x thumb
  • frustrated

Posted 4 weeks ago

  • 1
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 39,236 Points 20k badge 2x thumb
Yes. Get your 3rd party software provider to fix their software. Thanks for your question
Photo of Melissa Read

Melissa Read

  • 90 Points 75 badge 2x thumb
That's not very helpful. The class field is there in the IIF file, I can't see any reason it's not working. We have sorted all the other issues with the GST and getting the invoices to go on to jobs etc, so we know what we are doing and have checked that the names of the classes are exactly the same at both ends - I'm more wondering if it's a known fault in Reckon that the class is not coming through?
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 5,882 Points 5k badge 2x thumb
Hi Melissa - where in the IIF file does the Class appear - is it just on the TRNS lines or the SPL lines as well?  For you to get the reporting it sounds like you use, you would need to ensure that its repeated on all the SPL lines?  Cheers Linda
Photo of Melissa Read

Melissa Read

  • 90 Points 75 badge 2x thumb
Hi Linda,

Thanks for your advice - a copy of a sample file for just a single invoice is attached, the Class is in both lines, so I'm just not sure why it's not working :-(


Photo of Data Rec

Data Rec, Employee

  • 4,364 Points 4k badge 2x thumb
Hi Melissa,


The example above works on a Reckon Accounts 2017 AU software.




1. Click on the menu Edit | Preferences
2. Go to Accounting section
3. Go to Company Preferences tab
4. Check if  'Use class tracking' is enabled.


Regards,

Data Recovery Team

Photo of Linda Putland

Linda Putland, Accredited Partner

  • 5,882 Points 5k badge 2x thumb
I know this sounds weird - but I have come across it before - after checking the class settings in Preferences (which I assumed would already be there if you were using Class tracking before you got the third party import happening?)... but if you get one of the import files created by the third party - and then open it in Excel...  then look at how everything lines up - there have been times in my experience, where sometimes the header and/or detail column names in the first two lines - actually have a space in front of them?  when you have it open in Excel - click in those fields and check if there is a space in front of the word CLASS.... then do the same for the Class data in the SPL lines? 
Photo of Data Rec

Data Rec, Employee

  • 4,364 Points 4k badge 2x thumb
Hi Michelle,

I've tested that scenario and Linda is correct.

Whilst the other fields are recognised, the CLASS field is ignored since it contains a space character directly after the 'tab' character delimiter.


Regards,

Data Recovery Team