IFF invoice import template

  • 1
  • Problem
  • Updated 1 week ago
i am having issues with iff invoice import file - it wont bring up customer details set up in the reckon file

Am using reckon enterprise 2020 but did try in reckon premier 2014 and have same issue so must have something wrong with my template
I can successfully import the file with no errors and looks perfect BUT the customer name and address, payment terms and due date will not come across to the invoice unless i fill in the fields in the template - for the example above you will see have that info blank as is how what to bring the invoices in to reckon
It links to the correct accounts receivable file but have to add the address, due dat and terms if what it to show this on the invoice which is a given that would want to
Is this a know issue as am sure way back in the past did not have to complete this details as would pick from the customer set up.details

Was also hoping to mark the invoices as pending but cant find a way to to that as did not really want to use the to be printed or emailed option - reckon support said could not help with iff issues so am reaching out here
Photo of Gail Friday Office Solutions

Gail Friday Office Solutions, Accredited Partner

  • 1,368 Points 1k badge 2x thumb
  • frustrated

Posted 2 weeks ago

  • 1
Photo of Data Rec

Data Rec, Employee

  • 9,516 Points 5k badge 2x thumb
Hi Gail,

Does that Customer Name "gail" already exist in the data file as a Customer record?

If not, then create that new customer name and fill out the info such as address, terms, etc.
then re-import the IIF you have created.

Regards,

Data Recovery Team
Photo of Gail Friday Office Solutions

Gail Friday Office Solutions, Accredited Partner

  • 1,368 Points 1k badge 2x thumb

Yes it does

There liath the problem, I was hoping that if just entered the name exactly as it is in the customer file on the IFF template that it would use all the info already in the customer record on the invoice ie address, pay terms, and due date. But it does not it correctly assigns to that Customer as a debtor but if don’t complete the address fields etc the invoice works but all other fields are blank.

If Gail had not existed however in Reckon the customer name would be created but address and payment terms etc in the customer record are NOT updated so will have to when run statements check all new customers have addresses as are not imported to the customer file in Reckon just on the actual invoice.

I am going round in circles but have got ICOS now to add these fields to the exported  IFF datafile as need to go live ASAP as thousands of invoices are waiting to be imported but is not how I thought or remembered working years ago so feel have missed a couple of headers maybe in my iff file.BUT would be great if they did not have to as this as I see will cause issues down the track for the client having to spend more time on managing the customer records and issues with double up customers building up in Reckon

The importing of the invoices was supposed to save them time, it will but now will have to spend a great deal of time managing the customer detail info instead.

These are my current details and works perfectly if complete all TRNS lines in Red are entered but was wanting only to add the NAME and the rest be pulled from the customer record

 

I am way down the track with Icos now but maybe have missed a basic stage with IFF imports somewhere so any help or confirmation that this is how the IFF imports of invoices work would be great.

The client is in the cloud so option of ZED Axis would of been preferred choice of multiple importing of transactions 

Photo of Data Rec

Data Rec, Employee

  • 9,516 Points 5k badge 2x thumb
Hi Gail,

It looks like the import process requires that the fields be populated in the IIF file if you want information to be entered into the data file.

The auto-populate works only when the invoice is entered while the user is actually entering an invoice manually.

If you want to use the ZED Axis application, you can download the file to your local computer temporarily (you need to have the  Enterprise single-user application installed so that ZED Axis can integrate with it).
Then perform the import of transactions.
Then upload the update QBW file back to the Hosted platform.
Photo of Gail Friday Office Solutions

Gail Friday Office Solutions, Accredited Partner

  • 1,368 Points 1k badge 2x thumb
Thanks for your reply confirming what o have discovered.
Is strange though as Icos’s other Reckon client says there IFF file does use the customer files contact details but won’t share with me how is working.
Unfortunately the clients file is too big to upload and download on a regular basis as have done on occasion for other reasons and the portable file takes sometimes a few attempts to upload so is not a practical solution. Which is a shame as have used Zed Axis several times for other clients when staring a new company file.
Thanks again for your reply