When you import a .iff file into QuickBooks do you need to provide a TRNSID value in the source file or is this automatically generated during the import process?
@@Stevezedinoz Thanks, Steve. Your videos have been very useful for me. The "iif" documentation I've read states that the TRNSID field is required but doesn't state that you should leave it blank so the transaction number is automatically generated via the import process. I'm guessing that is the same with the DOCNUM field too. I can't seem to find a field that specifies which invoice template should be used with the transaction. Do you know if you can do that? It seems crazy to import thousands of invoice transactions and then have to go into each one in the application to change the invoice template.
Hi Mr. Batten, really great work on this video and editing/importing the iif file all together. I am getting an ; [ERROR] QNTY column is repeated or empty in the header [15113] after importing a purchase order iif file. Could you help me troubleshoot this?
Hi Rakim, Open your IIF file in notepad and see if you have two columns with the header QNTY that might be the cause or a corrupt IIF file. You would try Zed Axis to import the corrupt IIF file as you can ignore the duplicate QNTY column.
Hi Sir, thanks for such a great content...i am facing an issue while uploading a bill on qb as an IIF file....IIF file for purchase bill has quanity details for the purchsed product but when i upload the IIF file, quantity details for the product are not being uploaded and qb is not even showing any kind of error...can you please help with what could be the possible reason and how to resolve the same. Thanks
Hi Vijay, You could open the IIF file in Excel and make sure that a quantity has been specified in the bill, alternatively you could try using a trial of Zed Axis to import the IIF file into QuickBooks if there is a problem in the way the data has been formatted.
I love this video. I use third party software to transfer sales data from POS to back office where I use qb. I need your help to bring data from front counter POS to QB in back office. Please contact me. Aki
When you import a .iff file into QuickBooks do you need to provide a TRNSID value in the source file or is this automatically generated during the import process?
No you dont need to it is not required
@@Stevezedinoz Thanks, Steve. Your videos have been very useful for me. The "iif" documentation I've read states that the TRNSID field is required but doesn't state that you should leave it blank so the transaction number is automatically generated via the import process. I'm guessing that is the same with the DOCNUM field too. I can't seem to find a field that specifies which invoice template should be used with the transaction. Do you know if you can do that? It seems crazy to import thousands of invoice transactions and then have to go into each one in the application to change the invoice template.
Hi Mr. Batten, really great work on this video and editing/importing the iif file all together. I am getting an ; [ERROR] QNTY column is repeated or empty in the header [15113] after importing a purchase order iif file. Could you help me troubleshoot this?
Hi Rakim, Open your IIF file in notepad and see if you have two columns with the header QNTY that might be the cause or a corrupt IIF file. You would try Zed Axis to import the corrupt IIF file as you can ignore the duplicate QNTY column.
Hi Sir, thanks for such a great content...i am facing an issue while uploading a bill on qb as an IIF file....IIF file for purchase bill has quanity details for the purchsed product but when i upload the IIF file, quantity details for the product are not being uploaded and qb is not even showing any kind of error...can you please help with what could be the possible reason and how to resolve the same.
Thanks
Hi Vijay, You could open the IIF file in Excel and make sure that a quantity has been specified in the bill, alternatively you could try using a trial of Zed Axis to import the IIF file into QuickBooks if there is a problem in the way the data has been formatted.
Help Me How to Import TimeSheet Is it possible give me latest Sample File or Give me Instructions for how to do that
Hi Gobi, You will be able to find a sample IIF files on the Intuit website, they have lots of sample IIF files.
Can I import Employee information using IIF file?
Hi Ivy, Yes you can import Employee lists using an IIF file but the fields are quite limited compared to what Zed Axis can import.
I love this video. I use third party software to transfer sales data from POS to back office where I use qb. I need your help to bring data from front counter POS to QB in back office.
Please contact me.
Aki
Hi Aki, Happy to help we have a 30 day free trial of Zed Axis you can download from www.zed-systems.com that will do exactly what you are looking for.