When importing check using IIF File what is the Column Header on the SPL Line for Inventory Site

Thanks for sharing the details with us, @AFSMark.

I appreciate you for checking our Intuit Interchange Format (IIF) import kit for QuickBooks Desktop (QBDT). 

I’d like to get this sorted out and get you back in working order. However, it’ll require me to look into your account which I’m unable to do.

To get around this, I recommend checking with our Support team. There, they can securely check your account and can guide you further on what column header to use on the SPL Line for your Inventory Site.

To reach out to them, you can follow these steps below.

1. In your QBDT software, go to the Help menu.
2. Select QuickBooks Desktop Help.
3. Click Contact Us.
4. Enter a brief discussion if your issue and select Let’s talk.
5. Then choose your preferred way to connect with us.

You can also refer to this article for more details: Contact QuickBooks Desktop support.

I’m also adding these articles that you can read to learn more about importing IIF in QBDT:

• Tasks you can do with IIF files
• Export, import, and edit IIF files

In case you have other concerns or queries, you’re always welcome to leave a reply. I’ll be around to help you. Take care and keep safe.

Thank you for responding!!! I have already tried the support route and they basically told me that they don't offer this type of assistance with IIF File Import/Export and he forwarded me a link to a kit which didn't help the programmer of our third party software.  As such, I tried this route next to see if anyone might be able to help us.  It seems like just a little thing to get.  Any other thoughts?

Thank you for your response!  I had already tried the QB support route and they basically said they don't help along the lines of IIF File Import/Export and he sent me a link to a kit that evidently did not help our third party programmer in getting the specific information he needed that I mentioned in my original post.  It seems like this shouldn't be a huge thing to ask of Intuit and I must admit my opinion has always been very good but I sure didn't like this response.  Any other thoughts or recommendations?

@AFSMark 

Explore a 3rd party migration tool as another option. You may create a scheduler to export/import data automatically if required.

https:// transactionpro.grsm.io/qbd

Thank you for your response!  That is what they are needing the information for - it is a third party migration tool to export from their software into our QB Enterprise software.  They need to know what the Column Header is on the SPL Line for the Inventory Site (as I am told, I am not an expert in that area at all).  

Is there an inventory site for the SPL line for IIF files now?

Hi there, Lcolbert.

I'd like to provide you with some information on using .IIF files in QuickBooks Desktop (QBDT) for importing or exporting lists or transactions. 

Right now, the inventory site for the SPL line for .IIF file isn't available. But, you can download the QuickBooks IIF Import Kit for more information on creating the .IIF file. Additionally, you can refer to this article for guidance on importing .IIF files: IIF Overview: import kit, sample files, and headers.

To learn more about import features and how to ensure everything is intact after transferring them, I'm adding these resources for you:

• Import and export data in QuickBooks Desktop
• Understand reports

We recognize that each company has unique needs, and I know how the feature you're looking for would benefit and empower your business. I'd recommend submitting your feedback to help improve the program by going to the Send Feedback Online feature in QuickBooks Desktop.

You can also visit this page or the What's New section on your QuickBooks Desktop to get updates on our latest news about product improvements.

Please let me know if you have any other concerns regarding importing .IIF files in QuickBooks. I'll be happy to get back to you right away. Have a great day!

I am also looking to import Inventory Site into an invoice IIF file.  I don't understand how Intuit can't support importing their defined data.  I can import the IIF successfully as is, but the customer needs the Inventory Site data available in their invoice.  They can't expect to be able to import thousands of invoices, and then go back an manually update one simple field that should be available to import along with all the other SPL fields that are supported.

I am also looking to import Inventory Site into an invoice IIF file.  I don't understand how Intuit can't support importing their defined data.  I can import the IIF successfully as is, but the customer needs the Inventory Site data available in their invoice.  They can't expect to be able to import thousands of invoices, and then go back and manually update one simple field that should be available to import along with all the other SPL fields that are supported.  

Is there a way to mass update that field after the fact?  Is there an ETA as to when Intuit will support importing a field that they added to their invoice template.

Thank you for highlighting your queries, ThinkGreen.  I appreciate the opportunity to address them thoroughly. To ensure that you have a clear understanding and all the information you need, I will go through each of your concerns below. 

In QuickBooks Desktop (QBDT), the data you can import via IIF are only those specified in the Import Kit.

For more details, please refer to this article: IIF Overview: import kit, sample files, and headers.

Regarding the supportability of importing a field added to the invoice template, no timeframe has been provided yet. In the meantime, I suggest sending your feedback about this, including the option to bulk update the inventory site field. Here's how: 

1. Go to the Help menu.
2. Select the Send Feedback Online option, then Product Suggestion.
   
   
   
   
3. Type your feature recommendation in the space provided.
   
   
   
   
4. Hit the Send Feedback button.

We look forward to incorporating your insights into our ongoing efforts to enhance our product. These are carefully analyzed to ensure our updates align with your needs. If you have questions about managing IIF files or other tasks in QBDT, comment below. The Community space is here round the clock to assist.