Importing IIF files

  • 1
  • Question
  • Updated 4 months ago
  • Answered
When i am importing an IIF file from another program the banking details in the supplier card are wiped. what do i need to do to stop this from happening?
Photo of Bill N Georgia Seeney

Posted 4 months ago

  • 1
Photo of John G

John G, Information Support Analyst

  • 25,370 Points 20k badge 2x thumb
Hi Bill N Georgia,

Welcome to the Reckon Community.

If I understand your query correctly, you are importing Supplier details which include banking details from an IIF file sourced from a 3rd party and importing it to a company file that has or has not these Suppliers already entered.  The banking details in the source IIF do not appear in the Supplier record in your company file.  


Please check the structure of your source Supplier IIF file to one exported from your company file.  Make sure your column header for the banking details is exactly the same as it is in your exported IIF file.

In my file they appear as:
ACCNTNAME   ACCNTNUM   BRANCHNUM   BANKNAME  LODGEMENT
and are found in columns AW to AZ.

Bank details appear after import....




Hope this helps.


regards,
John
Thank you John,
The importing file does not have the banking detail in it. I have been told that if the banking details are added in Reckon then when the file is imported they stay in the supplier card, however this is not happening in my case.
I am not sure how to fix this issue.

Regards
Photo of John G

John G, Information Support Analyst

  • 25,370 Points 20k badge 2x thumb
Thanks Bill N Georgia,

When an IIF file is imported then the fields in the record are replaced by what is in the IIF file.  If a field is left blank or not included in the IIF file, and the corresponding record in the company file has information in that field, then a blank will be written into the field for that record.  

So, if you are importing limited changes to a Supplier record, and that record has other information in it, then all the company file record information must be in the IIF file to prevent any field with information being blanked out.  

Your best approach will be to export your existing Supplier List to an IIF file, modify the IIF file with new information, save it as an IIF file and then import it back into the company file.  

I hope this helps to understand the IIF import process.


regards,
John
Thank you John