Skip to main content
A
AFSMark
September 23, 2020
Solved

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

  • September 23, 2020
  • 3 replies
  • 0 views

Our third party vendor needs to find out what the Column Header on the SPL line is for the Inventory Site for use in importing into our QB Enterprise v19.0.  Intuit only helps by giving me a link to a kit that does not contain the information that they need.  Anyone have any help on this?

Best answer by BigRedConsulting

Unfortunately there is no Inventory Site field included in the IIF file format.  Intuit added the Site concept a decade ago, but hasn't updated the IIF file format to include it.

3 replies

JasroV
JasroV
September 23, 2020

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:

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.

A
AFSMarkAuthor
September 23, 2020

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?

    Fiat Lux - ASIA
    Fiat Lux - ASIA
    September 23, 2020

    @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

     

    A
    AFSMarkAuthor
    September 23, 2020

    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?

      BigRedConsulting
      BigRedConsultingAnswer
      September 23, 2020

      Unfortunately there is no Inventory Site field included in the IIF file format.  Intuit added the Site concept a decade ago, but hasn't updated the IIF file format to include it.

      L
      Lcolbert
      February 29, 2024

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

        M
        MirriamM
        February 29, 2024

        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:

         

         

        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!

        Terms & ConditionsAccessibility statement