Importing purchases, IIF headings for Item and Description?

  • 1
  • Question
  • Updated 3 weeks ago
Hi.

I need to create a IIF file to import purchase orders into Reckon. In Reckon the purchase order has several columns, ie Item, Description, Qty, Rate, etc. When creating the IIF file, which headings do I use for the Item and Description columns?  I've looked at the sample IIF files but the answer wasn't obvious, there is no header called ITEM or DESCRIPTION.

Thanks
Glenn
Photo of glennlittleford

glennlittleford

  • 140 Points 100 badge 2x thumb

Posted 4 weeks ago

  • 1
hello Glenn, 
Some one here will definitely be able to help you in your  issues.
However, if your need is on  more frequent basis , then we have done for Sales Order Tool that will automate the process and PO  has every items of SO

Photo of glennlittleford

glennlittleford

  • 140 Points 100 badge 2x thumb
Thanks Chandra, but I already have the items list, accounts, etc. I just need to know which headings in the IIF file correspond to the Items and Description columns on the Reckon purchase.
Photo of glennlittleford

glennlittleford

  • 140 Points 100 badge 2x thumb
Well I've worked it out myself.  The IIF headings INVITEM matches up with the purchases Item column, and the MEMO field matches the Description. I also worked out you can post several purchases in the one IIF file by including the  !HEADINGS lines for each new purchase, not just once at the top. If you dont, Reckon crashes!

I have to say, documentation and support from Reckon for the IIF file is pathetic! I've developed my software to export to MYOB and Zero, both relatively easy compared to Reckon. Maybe something to address.

Glenn