Importing purchases, IIF headings for Item and Description?
glennlittleford
Member Posts: 7 ✭
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
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
0
Comments
-
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
https://www.youtube.com/watch?v=H10XZv-ud-4
Cosmic Accounting Group
Accountants and Tax Agents 22397009
0 -
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.0
-
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.
Glenn0
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community